Hi All,
Im wondering if there is a way to display the value of Consolidated elements to be based on the access a specific user has in Tm1 web,
Example;
The user has access only to first 4 projects of Grp_A (A1 to A4) , so the view is as in the screen shot below,
Now can we dynamically show total of these projects which the user has access to instead of the actual totals.
Please let me know,
Thanks
Consolidation values by User Access
- Elessar
- Community Contributor
- Posts: 340
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Consolidation values by User Access
Hello!
- Create alternative hierarchies for each user group
- Add a dimension which describes user group (e.g. Department?)
- Write Excel formula (SUM)
Best regards, Alexander Dvoynev
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
-
- Posts: 30
- Joined: Wed Dec 05, 2012 2:18 pm
- OLAP Product: IBM Cognos Planning Analytics
- Version: 2.0
- Excel Version: 2010
Re: Consolidation values by User Access
Hi,
Thanks for the reply!
We currently have around 100 users in the system with already belonging to specific group. But their access to this dimension ( Project as given in example) varies user to user and is hard to define groups and hierarchies for that.
is there anyother way to fix this?
Thanks,
Thanks for the reply!
We currently have around 100 users in the system with already belonging to specific group. But their access to this dimension ( Project as given in example) varies user to user and is hard to define groups and hierarchies for that.
is there anyother way to fix this?
Thanks,
- Elessar
- Community Contributor
- Posts: 340
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Consolidation values by User Access
Then yours is 3rd option: You can write the excel SUM (..) formula, so it will calculate only the available projects
Best regards, Alexander Dvoynev
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.