Cost transparency - Release 1





Query BW


Access the query

The query to be used for the 1st release 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:

  • The Period FROM and TO (even if there is one month, you must enter FROM 01.2020 TO 01.2020) (1)
  • At least one company code (3)

It is also possible to enter:

  • a GBU 
  • a Macro-Package
  • a Cost Package
  • a Function

Click "OK" 



The report is displayed with the list of:

  • Cost Sub Packages
  • Cost Packages
  • Cost Macro Packages




Responsible cost center 

You can add the characteristic Origin Flow (1) to see where the costs are posted:

  • CCA: direct posting in cost center (ex: Cost center 0087-1000 (3))
  • OPA: posting in CO or PM order (ex: Order 12141464 (2))
  • WBS: posting in WBS element (ex: WBS OPT-C18014 (4))

=> The characteristic Resp. CC (5) corresponds to the cost center (3) or the responsible cost center of the order (2) or the WBS (4)

When the responsible cost center is not assigned, it means that it is not well maintained in the order master data (in KO03 - Display Internal Order)

Ex: there is no responsible cost center in the master data of the order 12050670

The Responsible cost center is used to assign costs to: 



Package assignment

Add the object "Package Derivation Source" to see how the sub-package is assigned to a posting: 

  • MATERIAL: there is a material code in the posting. A material group is assigned in its master data that is itself assigned to a sub-package,
  • PURCHDOC: There is no material but a purchase order. There is a material group in the purchase order that is assigned to a sub-package,
  • COSTELMNT: There is neither material nor purchase order. The cost element is used to assign the sub-package. 

In some cases a package can not be assigned. 

When the assignement is not possible, there is a reason code in the column Cost Sub Package.


  • NC_MATNR (1): There is a material code with a material group but the material group is not assigned to a sub-package. 

In the example, the material group 0112 (2) is assigned to the material code 1062492 (3) however the material group 0112 is not assigned to a sub-package in the transcodification table. 

=> The material group 0112 should be included in the table and assigned to a sub-package. 


  • NC_PURDOC (1): There is a purchase order with a material group but the material group is not assigned to a sub-package. 

In the example, the material group 0078 (2) is not assigned to a sub-package in the transcodification table. 

=> The material group 0078 should be included in the table and assigned to a sub-package. 



  • NC_FIN (1): There is a cost element that is not assigned to a sub-package. 

In the example, the material group 98120010 (2) is not assigned to a sub-package in the transcodification table. 

=> The material group 98120010 should be included in the table and assigned to a sub-package. 



Dashboard QlikSense


Access the dashboard

The dashboard is not published yet as it is still under construction. The design of each view was done in the frame of a pre-study with some key-users. 

Click the link: https://qliksense.solvay.com/solvay/sense/app/cb10806a-f6ef-4831-b371-b4915e018fce/overview to access the dashboard. 

There are 3 views in the dashboard for each type of users: 

  • Excom 
  • Budget Owner 
  • Package Owner 

There is also a view "My Report" to set-up a personnal report. 

There are other views in the dashboard in the test environment that shouldn't be used and will be hidden in the future.  



"Excom Cost" view

There are 7 views in the view "Excom Cost"

=> Filters can be added (a) by GBU / Year / Quarter / Month / Function

  1. YTD actual costs Y-1 vs YTD actual costs Y with the Inflation & FX rate
  2. YTD Package costs Y vs YTD Package costs Y-1 RSB
  3. Costs per month or cumulated YTD Y vs YTD Y-1 RSB
  4. Costs by GBU
  5. People costs evolution (FTE is not available in Release 1)
  6. Costs per FTE (FTE is not available in Release 1)
  7. Costs Details (€)

=> The costs details view can be customized by the user (b)







"Budget Owner Cost" view

There are 7 views in the view "Budget Owner Cost"

=> Filters can be added (a) by GBU / Year / Month / Function /  Fixed Costs Group / Plant

=> Selection must be done on GBU / Function or SBS (b)

  1. Cost repartition by function YTD Y vs YTD Y-1 RSB
  2. Costs Evolution (€) by month YTD Y vs YTD Y-1 RSB
  3. Costs Details (€): the costs details view can be customized by the user (c)
  4. People costs evolution (FTE is not available in Release 1)
  5. Costs per FTE (FTE is not available in Release 1)
  6. Top 10 Vendors
  7. Costs per vendor



"Package Owner Cost" view

There are 5 views in the view "Package Owner Cost"

=> Filters can be added (a) by GBU / Year / Quarter (a)

  1. YTD actual costs Y-1 vs YTD actual costs Y with the Inflation & FX rate
  2. Package Costs (k€)
  3. Costs per month or cumulated YTD Y vs YTD Y-1 RSB
  4. Costs by GBU
  5. Costs Details (€)

=> The costs details view can be customized by the user (b)