| HideElements | ||||||
|---|---|---|---|---|---|---|
|
| Excerpt | ||
|---|---|---|
| ||
The workbook is used to make the link between the analysis of costs at origin and their destination once all the cost transfers are done (assessment cycles etc.) |
Access the workbook
The workbook to be used is BW_WBK_COSTA_0002 – CO$TA - Destination View
=> 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_0002 – CO$TA - Destination View"
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
It is recommended to enter:
- A Period FROM and TO (even if there is one month, you must enter FROM 01.2020 TO 01.2020) (2)
- A PRS company code (4) or a company code (5)
- A GBU (3)
- Fixed cost Group 2: (exclude depreciation)
- != ZRCS-60
- != ZRCS-X60
- != ZRCS-UNL
It is also possible to enter:
- a Macro-Package (6)
- a Package (7)
- a Sub Package (8)
- # in "Excluded record" (9)
- a Function (10)
Click "OK"
The report is displayed with the list of:
- Cost Macro Packages
By default there are 2 columns:
- Actual Origin - Conso view (Conv) = Consolidated origin view converted with exchange rate entered in the prompt
- Actual Destination - Conso view (Conv) = Consolidated destination view converted with exchange rate entered in the prompt
| Info | ||
|---|---|---|
| ||
=> When the rate is different from 100% then it means the program is not able to allocate all costs to a destination object |
Dimensions
Dimensions to be used for the destination view start with "Destination"
Costa query:
| Core BW Query | QV Extraction | |||
| Destination | BW_QRY_CPCOCT05_0002 | COSTA - Cost Transparency - Destination view | QV_QRY_CPCOCT05_0001 | QV Cost Transparency - A destination View (POC) |
Related content
You can find a list with the description of specific rules used in the destination view query
Key principlesChildren Display