Security Management is split by Role dans Scope depending on the object you want to give users access to.
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.
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 Workspaces | Deny | Deny | Deny | Deny | Deny |
| ![ADMIN SBS] Modify Key Structural Elements | Deny | Deny | Deny | Deny | Deny |
| ![ADMIN SBS] Technical Views | Deny | Deny | Deny | Deny | Deny |
| 0. Admin data [AERO] | Allow | Deny | Deny | Deny | Deny |
00. New DFU Creation & Life Cycle [AERO] | Allow | Deny | Deny | Deny | Deny |
000. Master Data Mass Update | Allow | Deny | Deny | Deny | Deny |
| 1. Statistical forecast [AERO] | Allow | Deny | Deny | Deny | Deny |
| 2. Demand Review [AERO] | Allow | Deny | Deny | Deny | Deny |
| 2. Demand Review [AERO] - Amanda | Allow | Deny | Deny | Deny | Deny |
| 2. Demand Review [AERO] - back up | Allow | Deny | Deny | Deny | Deny |
| 2. Demand Review [AERO] - Kevin | Allow | Deny | Deny | Deny | Deny |
| 2. Demand Review [AERO] - Kp | Allow | Deny | Deny | Deny | Deny |
| 2. Demand Review [AERO] - only Program | Allow | Deny | Deny | Deny | Deny |
| 3. Forecast reliability & ABC classification [AERO] | Allow | Deny | Deny | Deny | Deny |
| 4. FCN [AERO] | Allow | Deny | Deny | Deny | Deny |
| 5. Budget Review [AERO] | Allow | Deny | Deny | Deny | Deny |
| 6. PMI [AERO] | Allow | Deny | Deny | Allow | Allow |
| 6. PMI [AERO] - Admin only | Allow | Deny | Deny | Allow | Deny |
| 7. Pricing Modification [AERO] | Allow | Deny | Deny | Deny | Deny |
| 8.a Skyline [AERO] | Allow | Deny | Deny | Deny | Deny |
| 8.b Engines [AERO] | Allow | Deny | Deny | Deny | Deny |
| 8.c Build Rate [AERO] | Allow | Deny | Deny | Deny | Deny |
| 9. Simulation [AERO] | Allow | Deny | Deny | Deny | Deny |
| Web. Sales Team Forecast | Allow | Allow | Allow | Deny | Deny |
| Web Workspaces | Deny | Deny | Deny | Deny | Deny |
| 1a. Sales team forecast - Default view. | Allow | Allow | Allow | Deny | Deny |
| 1b. Sales team forecast - Default view with graph. | Allow | Allow | Allow | Deny | Deny |
| 1c. Sales team forecast - List View with full data. | Allow | Allow | Allow | Deny | Deny |
| 1d. Sales team forecast - List View with STF only. | Allow | Allow | Allow | Deny | Deny |
| 1e. Sales team forecast - List View for import and export | Allow | Allow | Allow | Deny | Deny |
| 2. Forecast Change Notice. | Allow | Allow | Allow | Deny | Deny |
| 3. New combination. | Allow | Allow | Allow | Deny | Deny |
| 4. Alerts. | Allow | Allow | Allow | Deny | Deny |
| 5. PMI view | Allow | Allow | Allow | Deny | Deny |
| 6a. Sales Report by Customer | Allow | Allow | Allow | Deny | Deny |
| 6b. Sales Report by Program | Allow | Allow | Allow | Deny | Deny |
| 7. Collaborative review | Allow | Allow | Allow | Deny | Deny |
| Homepage | Allow | Allow | Allow | Deny | Deny |
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 Models | Deny | Deny | Deny | Deny | Deny |
| F01C-1.Material:Shipto@DC | Allow | Deny | Deny | Deny | Deny |
| F02C-2.Material:Forecast Customer@Spec | Allow | Allow | Allow | Allow | Allow |
| F03C-3.Program | Allow | Deny | Deny | Deny | Deny |
| F04C-4.Market | Deny | Deny | Deny | Deny | Deny |
| Forecast Models (bi-levels) | Deny | Deny | Deny | Deny | Deny |
| 1-2.Cst-Sit | Allow | Deny | Deny | Deny | Deny |
| 2-3.Itm-Fam | Allow | Deny | Deny | Deny | Deny |
| 3-4. Shipto-CustGr | Deny | Deny | Deny | Deny | Deny |
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 Models | Deny | Deny | Deny | Deny | Deny |
| _Tech | Deny | Deny | Deny | Deny | Deny |
| ABC DFU (Value) | Allow | Deny | Deny | Deny | Deny |
| ABC lvl1 ( Unit) | Deny | Deny | Deny | Deny | Deny |
| ABC lvl2 (Regular) | Deny | Deny | Deny | Deny | Deny |
| ABC lvl2 (Unit) | Deny | Deny | Deny | Deny | Deny |
| ABC lvl3 (Regular) | Deny | Deny | Deny | Deny | Deny |
| ABC lvl3 (Unit) | Deny | Deny | Deny | Deny | Deny |
| ABC lvl4 (Regular) | Deny | Deny | Deny | Deny | Deny |
| ABC lvl4 (Unit) | Deny | Deny | Deny | Deny | Deny |
| ABC lvl4 (Value) | Deny | Deny | Deny | Deny | Deny |
| ABC Program | Allow | Deny | Deny | Deny | Deny |
ABC Program (Value) | Deny | Deny | Deny | Deny | Deny |
| ABC Resin | Allow | Deny | Deny | Deny | Deny |
| U00 - Import - IN | Allow | Allow | Allow | Deny | Deny |
| U99 - Export - OUT | Deny | Deny | Deny | Deny | Deny |
| x. Currency Management | Deny | Deny | Deny | Deny | Deny |
| x. Master Tables Update | Allow | Deny | Deny | Deny | Deny |
| x. Supersession | Allow | Deny | Deny | Deny | Deny |
| y. GBU - AERO - DP | Allow | Allow | Allow | Allow | Allow |
| y. GBU - AERO - PMI | Allow | Allow | Allow | Allow | Allow |
| z. Budget | Allow | Allow | Allow | Deny | Deny |
| z. KPIs | Deny | Deny | Deny | Deny | Deny |
| z. Pricing Management | Allow | Allow | Allow | Deny | Deny |
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. SBS | Deny | Deny | Deny | Deny | Deny |
1. USER ROLE | Allow | Deny | Deny | Allow | Allow |
| A. AERO | Allow | Deny | Deny | Deny | Deny |
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-to | None | RSM condition | FAM condition | PMI Admin. condition | None |
| Regional Sales Manager | None | RSM condition | None | None | None |
| Primary Sales Coordinator | None | None | None | None | PMI SC1 condition |
| Material:Shipto:Spec@DC | None | RSM condition | FAM condition | None | None |
| Material:ForecastCustomer@Spec | None | RSM condition | FAM condition | Active Ship-to | CM | PMI SC1 condition |
Forecast Customer | None | RSM condition | FAM condition | PMI Admin. condition | None |
Forecast Account Manager | None | RSM condition | FAM condition | None | None |
i. Workspaces
ii. Models
iii. Shortcuts
iv. Master Tables
i. Workspaces
ii. Models
iii. Shortcuts
iv. Master Tables
i. Workspaces
ii. Models
iii. Shortcuts
iv. Master Tables
i. Workspaces
ii. Models
iii. Shortcuts
iv. Master Tables
i. Workspaces
ii. Models
iii. Shortcuts
iv. Master Tables
i. Workspaces
ii. Models
iii. Shortcuts
iv. Master Tables
i. Workspaces
ii. Models
iii. Shortcuts
iv. Master Tables
i. Workspaces
ii. Models
iii. Shortcuts
iv. Master Tables
i. Workspaces
ii. Models
iii. Shortcuts
iv. Master Tables
Here are some examples on concret cases, raised by ticket through the years.
For ex: for a Sales Employee of a given GBU
| # | Description | Screenshot |
|---|---|---|
| 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, |
|
For example, QSM-285899
| # | Description | Screenshot | Reference view |
|---|---|---|---|
Problem Reporting! | |||
| 1 | user SANTOSMA all black view while open the work space, |
|
|
Trouble Shooting! | |||
| 2 | The grid view has a split on dimension Material:Shipto@DC into
|
| |
| 3 | If you connect as the user into the rich client and right click => Configure |
| |
| 4 | The problem is on Material : the view has a filter on Material, on condition 'GBU - TS: Yes & Planned Material | TS : Yes' : |
| |
| 5 | User 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 : |
| |
| 7 | select here the 3 conditions (pressing control key allows to multiple select them) : |
| |
| 8 | And 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' : To remove the condition 'GBU - SA&D' in Material table associated with user group TS - US / Marcio Santos |
| |