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?
Element Security cube rule: Is Skipcheck needed?
-
- 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?
Planning Analytics latest version, including Cloud
-
- 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?
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.
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.
-
- 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?
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.
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