If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: Cognos Data Level Security in v11.1.7  (Read 1325 times)

Offline Cognosnewbie26

  • Full Member
  • ***
  • Join Date: Jul 2020
  • Posts: 16
  • Forum Citizenship: +0/-0
Cognos Data Level Security in v11.1.7
« on: 16 Aug 2021 07:19:38 pm »
Hi,
I am applying data level security on 3 dimensions in Cognos one is a regular dimension with attributes, another is a hierarchy based on geography and the third is a fact table. When I brought in the attributes from the first dimension it created cross-joins. Why is that? All the filters were applied based on the hierarchy.
So a user needs to have a role specific to their geography to access a particular hierarchy node.