Tuesday, April 12, 2011

TM1 Active Reports - Alternative Row shading

Alternative row shading is a good techniques for visual reporting.
With Active forms you can easily achieve it by using a formula in column A such as:

=IF(TM1RPTELISCONSOLIDATED($B$20,$B20),"C",MOD(ROW(),2))

This formula will then return a result of C, 1 or 0 and your format range just needs to cater for these with 1 and 0 being different shading.

Monday, April 04, 2011

Cognos Express 95 Online Mnauals

Useful to keep in your bookmarks:

http://publib.boulder.ibm.com/infocenter/cx/v9r5m0/index.jsp

Sunday, April 03, 2011

TM1 952 Parallel Interaction

TM1 952 introduces and exciting new feature called Parallel Interaction which massively improves the locking around multiple writers to cubes.

There is a good IBM tech note here to read:

https://www-304.ibm.com/support/docview.wss?mynp=OCSS9RXT&mync=R&uid=swg21460595&myns=swgimgmt

TM1 Cube Dependency

Cube dependency has become an important aspect admins should be aware of within their models.
There is a good overview describing what it is and how to cater for it here:

http://publib.boulder.ibm.com/infocenter/ctm1/v9r5m0/index.jsp?topic=/com.ibm.swg.im.cognos.tm1_op.9.5.2.doc/tm1_op_id3833CubeDepenedcy_MN4002.html