| HideElements | ||||||
|---|---|---|---|---|---|---|
|
| Info | ||
|---|---|---|
Cost allocation in Costa by Macro package / GBU can change (including historical data) as soon as a master data (ex: cost center, cost element etc) is updated in SAP.
|
Access the workbook
The workbook to be used is BW_WBK_COSTA_0003 – COSTA CO$TA - Snapshot vs Current Comparison (Core Query)
=> Go to Analysis for Office in excel
=> Click "Open Workbook"
Go to the tab "
SearchRole"
Enter "Costa" in the search bar, click
Open the folder "Cost Transparency" and select the
workbookworkbook "BW_WBK_COSTA_
00030003 – CO$TA - Snapshot vs Current Comparison
(Core Query)"
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) =
- P000000 = Actual data
- PYYMMDD = Snapshot done on the DD/MM/YY (ex: 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 (2)
- 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
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.
