Dashboard responsible to provide Inventory Management analysis.
Around 200 worldwide users.
The SAC Models are prepared to restrict the user access by Global Business Unit (GBU), but it was decided to give the users plenty access currently:
Team | Team Description | Explanation |
|---|---|---|
| SD_VIEWER | SD Viewer | SAC Team |
Note: Once the authorization police changes, new teams (GBU based) should be created and SD_VIEWER replaced.
List of authorization objects mandatory for the application.
Authorization object | Explanation |
|---|---|
| SAP_IM_GBU | Dimension for Global Business Unit |
Current Authority definition:
The dashboard Inventory Visibility Tool 2.0 was built in SAP Analytics Cloud, the data is imported from SAP BW in three different models in SAC:
SAC Production: https://solvaysa.eu10.hcs.cloud.sap/sap/fpa/ui/tenants/12b3c/app.html#;view_id=home
Direct link for this dashboard: https://solvaysa.eu10.hcs.cloud.sap/sap/fpa/ui/tenants/12b3c/app.html#/story&/s/A067F307F32E198C9978416A0ABE989C/?resourceType=STORY&mode=view
The dashboard contains nine tabs to split the data analysis between the models as follow:
Tab Name | Source SAC Model | SAC Measures |
|---|---|---|
| Welcome | MM-IM Total Stock (Detail) MM-IM SMOG (Detail) MM-IM DIOH | Standard → Value Total Stock (EUR) Integrated Margin → Integrated Margin SMOG as % of Total Stock Value → Standard / Values (Stock) SMOG as % of Total Stock Value Integrated Margin → Integrated Margin / Integrated Value (Stock) DIOH Quantity (AVG) → DIOH Quantity with Average configuration and aggregated by GBU, Plant and Material |
| Stock Overview | MM-IM Total Stock (Detail) | Standard → Value Total Stock (EUR) Integrated Margin → Integrated Margin |
| Stock Analysis | MM-IM Total Stock (Detail) | Standard → Value Total Stock (EUR) Integrated Margin → Integrated Margin |
| Stock Details (Jump) | MM-IM Total Stock (Detail) | Standard → Value Total Stock (EUR) Integrated Margin → Integrated Margin |
| SMOG vs. Total Stock | MM-IM SMOG x Stock | SMOG as % of Total Stock Value → Standard / Values (Stock) SMOG as % of Total Stock Value Integrated Margin → Integrated Margin / Integrated Value (Stock) |
| SMOG Analysis | MM-IM SMOG (Detail) MM-IM Anticipation | SMOG IN - SMOG with Operation FIRST SMOG END - SMOG with Operation LAST |
| SMOG Details (Jump) | MM-IM Anticipation | N/A |
| DIOH | MM-IM DIOH | DIOH Quantity (AVG) → DIOH Quantity with Average configuration and aggregated by GBU, Plant and Material |
| Glossary | N/A | N/A |
Note: Due the high volume of data, the Import Jobs are broken by GBU:
Object | Description | SAC Folder | Object Type |
|---|---|---|---|
| MM-IM Total Stock (Detail) | SAC_BW_QRY_CPMMIM01_0001 | /Public/02_SD/Models/Import | Model |
| MM-IM SMOG x Stock | SAC_BW_QRY_CPIMMM02_0004 | /Public/02_SD/Models/Import | Model |
| MM-IM SMOG (Detail) | SAC_BW_QRY_CPIMMM02_0003 | /Public/02_SD/Models/Import | Model |
| FI-WC DOS Inventory x Sales | ZTEST_SAC_BW_QRY_CPFIWC04_0001 | /Public/02_SD/Models/Import | Model |
| FI-WC Working Capital Inventory | ZTEST_SAC_BW_QRY_MVFIWC01_0005 | /Public/02_SD/Models/Import | Model |
| MM-IM Weekly Stocks | SAC_BW_QRY_CPMMIM01_0001 | /Public/02_SD/Models/Import | Model |
| MM-IM Anticipation | SAC_BW_QRY_CPMMIM01_0003 | /Public/02_SD/Models/Import | Model |
| MM-IM DIOH | SAC_BW_QRY_CPMMIM01_0005 | /Public/02_SD/Models/Import | Model |
| Inventory Visibility Tool 3.0 | Inventory Dashboard | /Public/02_SD | Story |
| Stock Detail | Detailed report from stock with data explorer | /Public/02_SD | Story |
| SMOG Detail | Detailed information for under observation and SMOG in the last day of previous month | /Public/02_SD | Story |