Hi All,
Brief Problem description :
When TM1 element level security is defined for more than one element in a dimension, data is getting filtered only for the first element in Cognos BI report.
Detailed description :
I am trying to implement element level security in TM1 (V 10.1) . I have done it on 2 dimensions - Country and City.
We are using Cognos groups for this. I have created 2 groups and added a user to these 2 groups and defined access (Write/None) at element level.
When I checked in cube viewer I am getting only those elements for which I have defined access and data is also getting filtered.
When I use the above TM1 cube as data source in Cognos (V 10.1.1) and If you apply TM1 security on 2 elements from a single dimension, although in the report it shows 2 elements, the report data gets filtered only based on the first element in the dimension !!! . If access restriction is there for only single element then both data and prompts are filtering out correctly.. !!!
I have tried to put this in a simple list report. I have a dimension 'Year' for which there are no access restrictions. When I use Year and any measure in a list, data is coming only for the first element from a dimension if it has element level security for more than one elements.
Even I tried by removing the named hierarchies in hierarchy properties cube.No luck...
Can anybody suggest a solution to solve this problem. Not really sure whether its from TM1 side or Cognos BI side