General presentation
Objective of the application
Dashboard responsible to provide Inventory Management analysis.
Usage information
Around 200 worldwide users.
Roles & Access
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.
Authorization objects
List of authorization objects mandatory for the application.
Authorization object | Explanation |
|---|---|
| SAP_IM_GBU | Dimension for Global Business Unit |
Current Authority definition:
Dataflow presentation
Overview
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:
- MM-IM Total Stock (Detail) - Source BW Query SAC_BW_QRY_CPMMIM01_0001 (Historical) )and SAC_BW_QRY_CPMMIM01_0002
- MM-IM SMOG (Detail) - Source BW Query SAC_BW_QRY_CPIMMM02_0003
- MM-IM SMOG x Stock - Source BW Query SAC_BW_QRY_CPMMIM02_0004
- FI-WC DOS Inventory x Sales - Source BW Query SAC_BW_QRY_MVFIWC01_0002
- FI-WC Working Capital Inventory - Source BW Query SAC_BW_QRY_CPFIWC04_0001
- MM-IM Weekly Stocks - Source BW Query SAC_BW_QRY_CPMMIM01_0001 and SAC_BW_QRY_MVFIWC01_0002
- MM-IM Anticipation - Source SMOG: SAC_BW_QRY_CPMMIM02_0005, Under Observation: SAC_BW_QRY_CPMMIM01_0003 (Obsolete) and SAC_BW_QRY_CPMMIM01_0004 (Slow Moving)
- MM-IM DIOH - Source BW Query SAC_BW_QRY_CPMMIM01_0005 and Source BW Query SAC_BW_QRY_CPMMIM01_0006 (Historical)
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
Dashboard Details
The dashboard contains nine tabs to split the data analysis between the models as follow:
Tab Name | Source SAC Model |
|---|---|
| Welcome | MM-IM Total Stock (Detail) MM-IM SMOG (Detail) MM-IM DIOH |
| Stock Overview | MM-IM Total Stock (Detail) |
| Stock Analysis | MM-IM Total Stock (Detail) |
| Stock Details (Jump) | MM-IM Total Stock (Detail) |
| SMOG vs. Total Stock | MM-IM SMOG x Stock |
| SMOG Analysis | MM-IM SMOG (Detail) MM-IM Anticipation |
| SMOG Details (Jump) | MM-IM Anticipation |
| DIOH | MM-IM DIOH |
| Glossary | N/A |
Loading Frequency
- Weekly for STOCK, every Tuesday morning.
- Monthly for SMOG, 3rd day of following month.
Note: Due the high volume of data, the Import Jobs are broken by GBU:
SAC Folders
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 |