| HideElements | ||||||
|---|---|---|---|---|---|---|
|
| Info | ||
|---|---|---|
.
|
Access the workbook
The workbook to be used is BW BW_WBK_COSTA_0003 – CO$TA - Snapshot vs Current Comparison0007 – Tool to track PO Material Group change
=> Go to Analysis for Office in excel
=> Click "Open Workbook"
Go to the tab "Role"
Open the folder "Cost Transparency" and select the workbook "BW_WBK_COSTA_0003 – CO$TA - Snapshot vs Current Comparison0007 – Tool to track PO Material Group change"
Double-click on the workbook to open it
| Note |
|---|
If you can not access the workbook => go to the page Co$ta - BW Authorization |
Run the workbook
Enter:
The snapshot name (1) =:
P220302 is the snapshot done on the )- A Period FROM and TO (even if there is one month, you must enter FROM 01.2020 TO 01.2020). It's the Fiscal period of data you are looking for (21)
- The period of the last change of Purchase order
- Enter the GBU / Package / Company as in the standard workbook (3)
Dimensions
The workbook is similar to the standard workbook Co$ta - Access & run BW query but with:
- Less dimensions available
- 3 dimensions not available in other Co$ta workbooks:
- Snapshot Name
- Snapshot data
- Snapshot time
- 1 dimension can give you the month of Purchase order month
- PO MatGrp Chge Mth
Ex: In this example we can trace all purchase order where Material group have been changed in 01.2022 , the new Material Group and the previous one
Ex: For the same selection (Macro-Package P00002), the actual amount = 2 753 100 € while on the total amount was 2 981 460 €
there is a decrease of the costs in the Macro-Package P00002 that can be explained by adding more dimensions in the report.
