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

The logic and best practices are to:

If a business request can’t follow these rules, a new user group "role" needs to be created - no exception can be applied.

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

The logic here is to use:

Workspaces are not visible by default - "Allow" is applied as below:

Workspaces / User Group

CM - Role Demand Planner

CM - Role Regional Sales Manager

CM - Role Forecast Account Manager

CM - Role PMI Admin.

CM - Role PMI

Remote WorkspacesDenyDenyDenyDenyDeny
![ADMIN SBS] Modify Key Structural ElementsDenyDenyDenyDenyDeny
![ADMIN SBS] Technical ViewsDenyDenyDenyDenyDeny
0. Admin data [AERO]AllowDenyDenyDenyDeny

00. New DFU Creation & Life Cycle [AERO]

AllowDenyDenyDenyDeny

000. Master Data Mass Update

AllowDenyDenyDenyDeny
1. Statistical forecast [AERO]AllowDenyDenyDenyDeny
2. Demand Review [AERO]AllowDenyDenyDenyDeny
2. Demand Review [AERO] - AmandaAllowDenyDenyDenyDeny
2. Demand Review [AERO] - back upAllowDenyDenyDenyDeny
2. Demand Review [AERO] - KevinAllowDenyDenyDenyDeny
2. Demand Review [AERO] - KpAllowDenyDenyDenyDeny
2. Demand Review [AERO] - only ProgramAllowDenyDenyDenyDeny
3. Forecast reliability & ABC classification [AERO]AllowDenyDenyDenyDeny
4. FCN [AERO]AllowDenyDenyDenyDeny
5. Budget Review [AERO]AllowDenyDenyDenyDeny
6. PMI [AERO]AllowDenyDenyAllowAllow
6. PMI [AERO] - Admin onlyAllowDenyDenyAllowDeny
7. Pricing Modification [AERO]AllowDenyDenyDenyDeny
8.a Skyline [AERO]AllowDenyDenyDenyDeny
8.b Engines [AERO]AllowDenyDenyDenyDeny
8.c Build Rate [AERO]AllowDenyDenyDenyDeny
9. Simulation [AERO]AllowDenyDenyDenyDeny
Web. Sales Team ForecastAllowAllowAllowDenyDeny
Web WorkspacesDenyDenyDenyDenyDeny
1a. Sales team forecast - Default view.AllowAllow AllowDenyDeny
1b. Sales team forecast - Default view with graph.AllowAllow AllowDenyDeny
1c. Sales team forecast - List View with full data.AllowAllow AllowDenyDeny
1d. Sales team forecast - List View with STF only.AllowAllow AllowDenyDeny
1e. Sales team forecast - List View for import and exportAllowAllow AllowDenyDeny
2. Forecast Change Notice.AllowAllow AllowDenyDeny
3. New combination.AllowAllow AllowDenyDeny
4. Alerts.AllowAllow AllowDenyDeny
5. PMI viewAllowAllow AllowDenyDeny
6a. Sales Report by CustomerAllowAllow AllowDenyDeny
6b. Sales Report by ProgramAllowAllow AllowDenyDeny
7. Collaborative reviewAllowAllow AllowDenyDeny
HomepageAllowAllow AllowDenyDeny

ii. Models

a. Core Models 

Forecast Models are not visible by default - "Allow" is applied as below:

Models / User Group

CM - Role Demand Planner

CM - Role Regional Sales Manager

CM - Role Forecast Account Manager

CM - Role PMI Admin.

CM - Role PMI

Forecast ModelsDenyDenyDenyDenyDeny
F01C-1.Material:Shipto@DCAllowDenyDenyDenyDeny
F02C-2.Material:Forecast Customer@SpecAllowAllowAllowAllowAllow
F03C-3.ProgramAllowDenyDenyDenyDeny
F04C-4.MarketDenyDenyDenyDenyDeny
Forecast Models (bi-levels)DenyDenyDenyDenyDeny
1-2.Cst-SitAllowDenyDenyDenyDeny
2-3.Itm-FamAllowDenyDenyDenyDeny
3-4. Shipto-CustGrDenyDenyDenyDenyDeny

b. User Models

User Models are not visible by default - "Allow" is applied as below:

Models / User Group

CM - Role Demand Planner

CM - Role Regional Sales Manager

CM - Role Forecast Account Manager

CM - Role PMI Admin.

CM - Role PMI

User ModelsDenyDenyDenyDenyDeny
_TechDenyDenyDenyDenyDeny
ABC DFU (Value)AllowDenyDenyDenyDeny
ABC lvl1 ( Unit)DenyDenyDenyDenyDeny
ABC lvl2 (Regular)DenyDenyDenyDenyDeny
ABC lvl2 (Unit)DenyDenyDenyDenyDeny
ABC lvl3 (Regular)DenyDenyDenyDenyDeny
ABC lvl3 (Unit)DenyDenyDenyDenyDeny
ABC lvl4 (Regular)DenyDenyDenyDenyDeny
ABC lvl4 (Unit)DenyDenyDenyDenyDeny
ABC lvl4 (Value)DenyDenyDenyDenyDeny
ABC ProgramAllowDenyDenyDenyDeny

ABC Program (Value)

DenyDenyDenyDenyDeny
ABC ResinAllowDenyDenyDenyDeny
U00 - Import - INAllowAllowAllowDenyDeny
U99 - Export - OUTDenyDenyDenyDenyDeny
x. Currency ManagementDenyDenyDenyDenyDeny
x. Master Tables UpdateAllowDenyDenyDenyDeny
x. SupersessionAllowDenyDenyDenyDeny
y. GBU - AERO - DPAllowAllowAllowAllowAllow
y. GBU - AERO - PMIAllowAllowAllowAllowAllow
z. BudgetAllowAllowAllowDenyDeny
z. KPIsDenyDenyDenyDenyDeny
z. Pricing ManagementAllowAllowAllowDenyDeny

iii. Shortcuts

Shortcuts are not visible by default - "Allow" is applied as below by folder:

Shortcuts / User Group

CM - Role Demand Planner

CM - Role Regional Sales Manager

CM - Role Forecast Account Manager

CM - Role PMI Admin.

CM - Role PMI

0. SBSDenyDenyDenyDenyDeny

1. USER ROLE

AllowDenyDenyAllowAllow
A. AEROAllowDenyDenyDenyDeny

iv. Master Tables

Security of Master Tables is usually set-up when related to User Management: when a new scope is created (new user or scope transition), the condition should be inputted in both visibility and modification columns.

Master Table / User Group

CM - Scope Demand Planner

CM - Scope Regional Sales Manager

CM - Scope Forecast Account Manager

CM - Scope PMI Admin.

CM - Scope PMI

Ship-toNoneRSM conditionFAM conditionPMI Admin. conditionNone
Regional Sales ManagerNoneRSM conditionNoneNoneNone
Primary Sales CoordinatorNoneNoneNoneNonePMI SC1 condition
Material:Shipto:Spec@DCNoneRSM conditionFAM conditionNoneNone
Material:ForecastCustomer@SpecNoneRSM conditionFAM conditionActive Ship-to | CMPMI SC1 condition

Forecast Customer

NoneRSM conditionFAM conditionPMI Admin. conditionNone

Forecast Account Manager

NoneRSM conditionFAM conditionNoneNone

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