It is the standard Co$ta workbook


Co$ta - Access & run BW workbook

>> Back to the Co$ta project home page

 



Access the workbook

The workbook to be used is BW_WBK_COSTA_0001  – CO$TA - Origin 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_0001  – CO$TA - Origin View" 

Double-click on the workbook to open it

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) 
  • # in "Excluded record" (11) 

It is also possible to enter:

  • a Macro-Package (6)
  • a Package (7)
  • a Sub Package (8)
  • a Function (12)
  • a Fixed cost Group 2 (13)
  • the version of the budget (14)
  • display Adjustment Perimeters Data: by default = # (No). Enter "1" (15)

Click "OK" 



The report is displayed with the list of:

  • Cost Macro Packages
  • Cost Packages




Costa queries: 


Core BW QueryQV Extraction
Origin (New model)BW_QRY_CPCOCT05_1001COSTA - Cost Transparency - Origin viewQV_BW_QRY_CPCOCT05_1001COSTA - Cost Transparency - Origin view



QV_BW_QRY_CPCOCT05_1002QV - Cost Transparency - Origin - Perimiter Change





Origin (Old model)

BW_QRY_CPCOCT01_0002COSTA - Cost Transparency - Origin viewQV_BW_QRY_CPCOCT01_R1_0001QV - Cost Transparency - Release 1