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 (blue star)
  • 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 repord" (5) 

Click "OK" 



The report is displayed with the list of:

  • Cost Sub Packages
  • Cost Packages
  • Cost Macro Packages




(blue star) new