TM1 Forum

Posted: **Mon Sep 18, 2017 12:47 pm**

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;

: Capture.JPG (39.11 KiB) Viewed 3209 times

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,

: Capture2.JPG (26.52 KiB) Viewed 3209 times

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

Posted: **Mon Sep 18, 2017 1:40 pm**

Hello!

Create alternative hierarchies for each user group

Add a dimension which describes user group (e.g. Department?)

Write Excel formula (SUM)

Posted: **Tue Sep 19, 2017 7:13 am**

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,

Posted: **Tue Sep 19, 2017 7:52 am**

Then yours is 3rd option: You can write the excel SUM (..) formula, so it will calculate only the available projects

TM1 Forum

Consolidation values by User Access

Consolidation values by User Access

Re: Consolidation values by User Access

Re: Consolidation values by User Access

Re: Consolidation values by User Access