TM1 Forum

Outside of creating alternate rollups, is there any way to have a consolidation only reflect the elements that a user has access to?

For example the user below would only have access to Golf and all of its ancestors and descendants:

All Products = 100
-Camping = 26
--Tents = 18
--... = 8
-Golf = 74
--Clubs = 44
--Tees = 5
--Balls = 25

The All Products value is correct and the expected result in TM1 but the functionality I am looking to achieve is in the example below:

All Products = 74
-Camping = 26
--Tents = 18
--... = 8
-Golf = 74
--Clubs = 44
--Tees = 5
--Balls = 25

Any thoughts?

Garsdale49 wrote:Outside of creating alternate rollups, is there any way to have a consolidation only reflect the elements that a user has access to?

Nope.

As mattgoff said, consolidation no.
Maybe an excel report that dynamically shows only elements to which user has access to and simple "=SUM(...)" function is satisfactory workaround.

If your cube had the security groups dimension or something similar then you could probably do something with rules that populated the values in the security group dimension depending on the access.
If you then put security on the groups dimension such that the user only had access to the one group they were a member of then the user wouldn't need to select anything special to see the view of data you wanted them to see.

I've not tested the above and never implemented it, it's a pretty unusual thing to want to do.

HTH

Cheers,