Hi!
Does anybody know how i can highlight aggregation or calculation cells in TM1 Cube.
For example as bold or italic text (digits) in the TM1 Cube's Greed?
Thanks a lot!
aggregation element's highlighting
-
David Usherwood
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: aggregation element's highlighting
Welcome to the forum!
From your question I _suspect_ you are from a Cognos Planning background.
The TM1 cube viewer shows non-input cells as grey, input cells as white - but it doesn't distinguish between consolidated, ruled and blocked by security.
Frankly, the cube viewer is pretty limited as a frontend tool for working with TM1. Excel is better. TM1 Web is an option, though it's slower than Excel. To do what you want you'd probably need to handcraft some rules. Maybe others here have smarter ideas.
From your question I _suspect_ you are from a Cognos Planning background.
The TM1 cube viewer shows non-input cells as grey, input cells as white - but it doesn't distinguish between consolidated, ruled and blocked by security.
Frankly, the cube viewer is pretty limited as a frontend tool for working with TM1. Excel is better. TM1 Web is an option, though it's slower than Excel. To do what you want you'd probably need to handcraft some rules. Maybe others here have smarter ideas.
-
Viet
- Posts: 6
- Joined: Mon May 19, 2008 8:57 pm
- OLAP Product: TM1
- Version: 9.4 FP2
- Excel Version: 2003
- Location: France, Paris
- Contact:
Re: aggregation element's highlighting
Hi,
Yes the TM1 cube viewer is very limited, excel and active forms could help but navigating with colour coding is better and much more efficient with Executive Viewer...
Yes the TM1 cube viewer is very limited, excel and active forms could help but navigating with colour coding is better and much more efficient with Executive Viewer...