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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Set multiple Data Security in Framework Manager

Started by peter13579, 26 Mar 2018 03:01:51 AM

Previous topic - Next topic

peter13579

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

Francis aka khayman

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