COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: peter13579 on 26 Mar 2018 03:01:51 AM

Title: Set multiple Data Security in Framework Manager
Post by: peter13579 on 26 Mar 2018 03:01:51 AM
Hi there,

I like to implement an Access Concept in Framework Manager. The Goal is to have three Data Access Groups in a combination.
1. Business Unit                i.e. BU = 1
2. Plants and Products       i.e. Plant = 1234 and ProductLine = 4711
3. Markets                        i.e. Market = France

How can I set the Data Security in FM to get a combination of These 3 filter conditions. I have tested to implement it with "Specifiy Data Security", but the conditions seems to work with an "OR" not with "AND". It's no Option to create all possible combinations like filter condition (like BU = 1 and Plant = 1234 and ProductLine = 4711 and Market = France).

I'm looking for a more comfortable way to do it.

Greetings Peter
Title: Re: Set multiple Data Security in Framework Manager
Post by: Francis aka khayman on 30 Aug 2018 05:12:18 PM
you can define all those AND conditions in Filter Definition

eg

[Database Layer].
.[BU] = 1 AND [Database Layer].
.[Plants] = 1234 and [Database Layer].
.[ProductLine] = 4711 ...etc