Hello All
In 10.2 tm1 contributor, The rules driven N cells are grayed out but the consolidation cells are not. Eventhough the consolidation cells are not grayed out, no one is able to enter data as those cells are rule driven. I want to color rule driven column at consolidation level.
Is that possible than what would be the resource?
Thanks
Dharav
How to make columns color in tm1 contributor?
-
mvaspal
- Community Contributor
- Posts: 341
- Joined: Wed Nov 03, 2010 9:16 pm
- OLAP Product: tm1
- Version: 10 2 2 - 2.0.5
- Excel Version: From 2007 to 2013
- Location: Earth
Re: How to make columns color in tm1 contributor?
Hi
If it is standard cube view then it is as expected: you have rules on N: level but not on C:
At the moment I am not aware of a parameter in Performance Modeler where you could disable break back on C: levels (this is why you see C: cells in white)
So I think you would have the following options:
- apply READ to C: level elements; depending on the version you use, it could be done with cell security from 10.2 but you can do it with element security in versions before 10.2
- use active forms instead of cube views - a bit more effort to develop them but you can easily format the input forms
I think you can find other threads about this topic on the forum, this has been discussed a couple of times, you may need to search for tm1 web instead of Contributor.
If it is standard cube view then it is as expected: you have rules on N: level but not on C:
At the moment I am not aware of a parameter in Performance Modeler where you could disable break back on C: levels (this is why you see C: cells in white)
So I think you would have the following options:
- apply READ to C: level elements; depending on the version you use, it could be done with cell security from 10.2 but you can do it with element security in versions before 10.2
- use active forms instead of cube views - a bit more effort to develop them but you can easily format the input forms
I think you can find other threads about this topic on the forum, this has been discussed a couple of times, you may need to search for tm1 web instead of Contributor.