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"

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" 

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: 

• a GBU (with its profit center in WP1, its Business area in PF1)
• a plant with its profit center
• a function with the hierarchy ZCBS and a BSA when it is maintained

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. 

• 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. 

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.  

"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