Looking for a little clarification on a security item that was brought to my attention by a user.
If I am a user and I have access to 3 children that roll up to a parent. The parent has a total of 6 children. If I grant security access to that parent and I go to report data off that parent will that aggregation be an aggregation of the 3 children I have access to or the 6 total children of the parent.
I heard this might be an enhancement in newer versions of TM1 but I am not totally sure. The version of TM1 I am working with is a couple of versions behind and consolidations sum the total of the children.
Number Consolidation based on security settings
-
- Posts: 90
- Joined: Tue Aug 19, 2008 4:56 pm
-
- MVP
- Posts: 3105
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Number Consolidation based on security settings
It's the sum of 6 children, not 3.
I haven't heard of changes in this respect.
It's been always like still and will most probably remain like this.
I haven't heard of changes in this respect.
It's been always like still and will most probably remain like this.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- MVP
- Posts: 2831
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Number Consolidation based on security settings
TM1 does not alter the results of a consolidated calculation to reflect only those cells beneath which a specific user has security access and likely never will. Doing so would totally blow out of the water the concept of cached results since now it would have to be by user.
-
- Community Contributor
- Posts: 247
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: Number Consolidation based on security settings
Reporting consistent numbers would become a nightmare so I'd be surprised if this was implemented
-
- MVP
- Posts: 3651
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Number Consolidation based on security settings
That would be anything but an "enhancement". It would be a nightmare.cdhodge2002 wrote:If I am a user and I have access to 3 children that roll up to a parent. The parent has a total of 6 children. If I grant security access to that parent and I go to report data off that parent will that aggregation be an aggregation of the 3 children I have access to or the 6 total children of the parent.
I heard this might be an enhancement in newer versions of TM1 but I am not totally sure. The version of TM1 I am working with is a couple of versions behind and consolidations sum the total of the children.
"Alternate facts" might be in vogue in politics but in finance and analytics the sum of a consolidation has an objectively correct value which is not influenced by users' ability to see all of the components underneath or not.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
- Steve Rowe
- Site Admin
- Posts: 2410
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Number Consolidation based on security settings
Interesting problem though...
If you have a parent with 4 children and you have access to the parent and 3 of the children only then the security breaks.
Answers on a postcard.
If you have a parent with 4 children and you have access to the parent and 3 of the children only then the security breaks.
Answers on a postcard.
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- 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: Number Consolidation based on security settings
just an argument from the other other side: this worked in Cognos Planning, and many times proved to be a great feature; just search this forum for people looking for CP's access tables and then the non-perfect workarounds that TM1 gives you...
there are use cases when accumulating only those elements that you have access to is very useful; i.e. I do not think custom consolidations will be supported in CAFE/PAw, and building a User Group based hierarchy may not be the perfect solution
So I don't think this is a black/white topic
there are use cases when accumulating only those elements that you have access to is very useful; i.e. I do not think custom consolidations will be supported in CAFE/PAw, and building a User Group based hierarchy may not be the perfect solution
So I don't think this is a black/white topic
-
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: Number Consolidation based on security settings
Even in Cognos Planning the access tables did not affect the way in which the consolidation was done. If there data was there it was aggregated, even if it was invisible to the user. We had arguments internally about the problem Steve highlights but there was never any question of doing the aggregation any other way.
The other aspect was that as you moved up the organisation hierarchy (what we used to call the eList - you know, late 90s, e-Everything) you got the union of the access below.
The other aspect was that as you moved up the organisation hierarchy (what we used to call the eList - you know, late 90s, e-Everything) you got the union of the access below.