Wednesday, April 27, 2011
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.
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
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
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
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
Subscribe to:
Posts (Atom)