Custom Rollup Issue

Post Reply
AskAndAnswer
Posts: 3
Joined: Fri Jun 02, 2017 6:35 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Custom Rollup Issue

Post by AskAndAnswer » Mon Nov 06, 2017 8:27 pm

Hello,

I am running into an issue with the user created custom rollups. When users add a custom rollup to the cube view, they do not see any consolidated data there, though they have write access to all leaf elements in the rollup, and all elements' data is loaded, no rules. An admin can see totals, so I assume it's a security issue. Is there a way to fix it?
There is an element security cube that limits access to the elements in the dimension, this particular user has access to everything, but I guess when a custom consolidation is created, security does not apply to it.

lotsaram
MVP
Posts: 3006
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TM1, CX
Version: TM1 10.2.2 PA 2.0x
Excel Version: 2010 2013 365
Location: Switzerland

Re: Custom Rollup Issue

Post by lotsaram » Mon Nov 06, 2017 9:32 pm

AskAndAnswer wrote:
Mon Nov 06, 2017 8:27 pm
Hello,

I am running into an issue with the user created custom rollups. When users add a custom rollup to the cube view, they do not see any consolidated data there, though they have write access to all leaf elements in the rollup, and all elements' data is loaded, no rules. An admin can see totals, so I assume it's a security issue. Is there a way to fix it?
There is an element security cube that limits access to the elements in the dimension, this particular user has access to everything, but I guess when a custom consolidation is created, security does not apply to it.
When you say "user has added a custom rollup" you need to clarify exactly what you mean. It seems you aren't talking about a user defined consolidation but perhaps the user creates a rollup via running a TI process?

If the dimension has element security then any new element will have NONE access for all groups until security is defined so if you have a process run by users to create elements then that process needs to also make sure security gets assigned for any new element.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

AskAndAnswer
Posts: 3
Joined: Fri Jun 02, 2017 6:35 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: Custom Rollup Issue

Post by AskAndAnswer » Tue Nov 07, 2017 4:18 am

I mean a rollup that user creates by picking elements in the subset editor and clicking Rollup button. It creates a custom consolidation "}ROOLUP_ELEM", and this is what stays empty in the cube view while the user has access to all elements underneath and all regular consolidations in the dimension.

Post Reply