1. Security Management Logic

Security Management is split by Role dans Scope depending on the object you want to give users access to. 

1.1 Role

1.2 Scope


2. Security by GBU

As explained above, security is applied based on GBU and role. Here is the summary of GBU roles list.

2.1. DP2 - Composites (CM)

i. Workspaces

ii. Models

iii. Shortcuts

iv. Master Tables

2.2 DSCP1 - Soda Ash and Derivatives (SD)

i. Workspaces

ii. Models

iii. Shortcuts

iv. Master Tables

2.3 DP3 - Novecare (CS)

i. Workspaces

ii. Models

iii. Shortcuts

iv. Master Tables

2.4 DP3 - Oil and Gas (OG)

i. Workspaces

ii. Models

iii. Shortcuts

iv. Master Tables

2.5 DP3 - Special Chem (CH)

i. Workspaces

ii. Models

iii. Shortcuts

iv. Master Tables

2.6 DP1 - Aroma (PA)

i. Workspaces

ii. Models

iii. Shortcuts

iv. Master Tables

2.7 DP1 - Perox (PE)

i. Workspaces

ii. Models

iii. Shortcuts

iv. Master Tables

2.8 DP1 - Silica (SI)

i. Workspaces

ii. Models

iii. Shortcuts

iv. Master Tables

2.9 DP1 - Technology Solutions (TS)

i. Workspaces

ii. Models

iii. Shortcuts

iv. Master Tables

2.10 DSCP2 - Specialty Polymers (SP)

i. Workspaces

ii. Models

iii. Shortcuts

iv. Master Tables


3. Examples

Here are some examples on concret cases, raised by ticket through the years.

3.1 Example #1 - Simple

For ex: for a Sales Employee of a given GBU

#DescriptionScreenshot
1

right click the master table Sales Employee ID, then click Security,

In the Advanced security tab, for each user group, associate the conditions to the corresponding user groups,

2

right click the master table Material:shipto@DC, click Security,

In the Advanced security tab, for each user group, associate the conditions to the corresponding user groups,




3.2 Example #2 - Complex

For example, QSM-285899

#DescriptionScreenshotReference view

Problem Reporting!

1user SANTOSMA all black view while open the work space,

Trouble Shooting!

2

The grid view has a split on dimension Material:Shipto@DC into 

  • Country 
  • Ship-To
  • Sold-To
  • Material
  • and the original data field dimension, Material:Shipto@DC


3

If you connect as the user into the rich client and right click => Configure on the view, you can check which one is empty (the one with /) :


4The problem is on Material : the view has a filter on Material, on condition 'GBU - TS: Yes & Planned Material | TS : Yes' :


5User belongs to those groups : 


6

The only group having a security configured on the master table 'Material' is TS - US / Marcio Santos, with the visibility condition 'GBU - SA&D'


Finally, a right click =>  hierarchy view (with a super user account) on the master table 'Material' shows that there is no intersection between the combination of the conditions used to filter the grid and the condition of visibility :


7select here the 3 conditions (pressing control key allows to multiple select them) :



8And we can see that no material fulfills the 3 conditions : 


Fix!

9

The problem is on Material : the view has a filter on Material, on condition 'GBU - TS: Yes & Planned Material | TS : Yes' : 
The only group having a security configured on the master table 'Material' is TS - US / Marcio Santos, with the visibility condition 'GBU - SA&D' 

To remove the condition 'GBU - SA&D'  in Material table associated with user group TS - US / Marcio Santos







4. Useful documentation