Co$ta - BW Snapshot vs Current

>> Back to the Co$ta project home page

 



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.


In order to facilitate the analysis of changes from period to another, a snapshot of Costa is made every week in BW. This way, the current data can be compared with the data shot in the previous weeks. The comparison is done with the report "Snapshot vs Current Comparison" described in this page.

Access the workbook

The workbook to be used is BW_WBK_COSTA_0003  – COSTA - Snapshot vs Current Comparison (Core Query)

=> Go to Analysis for Office in excel 

=> Click "Open Workbook"



Go to the tab "Search"

Enter "Costa" in the search bar, click and select the workbook "BW_WBK_COSTA_0003 – CO$TA - Snapshot vs Current Comparison (Core Query)" 

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

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)


Click "OK" 



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.