Element Security cube rule: Is Skipcheck needed?

Post Reply
harrytm1
Regular Participant
Posts: 226
Joined: Thu Apr 02, 2009 2:51 pm
OLAP Product: IBM Planning Analytics
Version: Latest version
Excel Version: 2003 to 2019

Element Security cube rule: Is Skipcheck needed?

Post by harrytm1 »

Hi all,

I create a rule for ElementSecurity cube to assign access to groups for a dimension "Product". Initially, I did not pull Skipcheck since it is a string cube.

However, everytime I open a cube view of the ElementSecurity cube, it takes a long time to generate the view. This was solved after I put Skipcheck in the rule.

Is this the correct way i.e. using Skipcheck in string cube, especially for a security-related cube?
Planning Analytics latest version, including Cloud
John Hammond
Community Contributor
Posts: 300
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: Element Security cube rule: Is Skipcheck needed?

Post by John Hammond »

Unless you have a small cube you should always use Skipcheck. If you dont use it in a large cube it may bring down the server since number of feeder flags generated = n level elements in dim1 * n level elements in dim2 * etc can be more than grains of sand in the observable universe etc etc

Strangely though the cells in an element security cube do not have to be fed for the security to take effect. Mind you TM1 there are a lot of cases in TM1 where the feeders dont matter.
harrytm1
Regular Participant
Posts: 226
Joined: Thu Apr 02, 2009 2:51 pm
OLAP Product: IBM Planning Analytics
Version: Latest version
Excel Version: 2003 to 2019

Re: Element Security cube rule: Is Skipcheck needed?

Post by harrytm1 »

thanks for the reply.

I initially did not use Skipcheck since it is a string cube. However, after encountering slow view generation in the security cube, I decided to se Skipcheck.
Planning Analytics latest version, including Cloud
Post Reply