Co$ta - Access & run BW query
>> Back to the Co$ta project home page
Access the query
The query to be used is BW_QRY_CPCOCT01_R1_0001 – Cost Transparency – Release 1
=> Go to Analysis for Office in excel
=> Click "Open Data Source"
Go to the tab "Search" and enter "BW_QRY_CPCOCT01_R1_0001" in the search bar.
Double-click on the query to open it
Run the query
It is mandatory to enter:
- Conso view (1) : enter 1 to apply the legal entity consolidation rate or 0 not to take the consolidation rate into consideration
- The Period FROM and TO (even if there is one month, you must enter FROM 01.2020 TO 01.2020) (2)
- At least one company code (3)
It is also possible to enter:
- a GBU (6)
- a Macro-Package (4)
- a Cost Package (4)
- a Function (7)
It is also recommended to enter # in "Excluded record" (5)
Click "OK"
The report is displayed with the list of:
- Cost Sub Packages
- Cost Packages
- Cost Macro Packages