| HideElements | ||||||
|---|---|---|---|---|---|---|
|
| Table of Contents | ||||
|---|---|---|---|---|
|
Determination Rules for Cost Package
General Principles for the Database
R1R2
A. Primary Postings in SAP Objects:
Cost Center (CC)
PM Orders and Internal Order
WBS
Most frequent cases: Reception of Purchase orders or posting of monthly payroll
Exceptions:
B1. COPA posting for commissions (to PL wo Intermediate CC)
B2. Good receipt (stock) for spare parts (No PL impact in Origin view)
- Consumption of Spare parts in CC/WBS/Order are filtered out to avoid double counting
| HTML Wrap | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
|
Cost Package Determination (
R1R2)
Package Owner Qlik detail
1. Go to Qlik Sense here, select Package Owner cost
2. Choose your package:
2.1. Directly in cost details
- Hit the Macro Package dimension
- Select the package
- Hit the confirm selection button
Cost results for the selected Macro package on the dashboard, graphs and total costs (cost details is set to have this 6 dimensions view)
2.2. Via optionSelections
Hit 
(the button on the top right)
- You can select any dimension, like cost center, month and entity etc.
- If the options are in dark gray, it means there is no data for these options
3. Four standard Graphs are already set up, three can be customized in terms of figures you want to see.
- Hit the description to change the comparison data
4. Cost details
- It works by drag & drop;
- Build your view to analyze the costs;
- Select the order of available dimensions to establish the levels on the dashboard
- Example for Macro Package Industrial Services
| HTML Wrap | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
5. You can create a bookmark to store the filters, for the moment the layout is not saved, so you have to rebuild Cost details sequence each time
- You can get back to it choosing bookmark and selecting it
- You can also share the bookmark to any other person
6. At the bottom you can find Vendor costs info (2020 / 2019)
- A table with the higher costs vendor to lower costs vendor
- A graph with the same info or by biggest delta Vs 2019
8. You will find Standard filters and Data sets
- Click on your selection to select / unselect data sets
9. You can choose to work the data as Table or Pivot table
For both:
- Do the selections and the field will move to the dashboard
- You can hit the dimension button and filter what is not available in the standard filters
Table: you can change the sequence of the dimension
Pivot table: you can move also from row to column
| HTML Wrap | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
Package Owner BW detail
Directly in BW (WBP) : search for “BW_QRY_CPCOCT01_R1_0001” and choose the highlighted query
| HTML Wrap | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
Than you have to do this selections in the prompt alongside the periods you are looking in Qlik Sense
For Cost Macro Package
- Select only the Package under analysis (right click on the dimension)
- Filter by member-make your selection
When finished:
- Use the filters or copy paste to another sheet completing the header of the columns without info
- Create a new sheet and insert a pivot table
The total amount should match the dashboard
- Drill down to detail
- Check Macro Package by any dimension
- Example: Material group and Material
| HTML Wrap | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
Determination Rules for Budget Owner Dimensions
Dimensions of Budget Owners in Dashboard
| HTML Wrap | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
|
Derivation from other Objects
| HTML Wrap | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
|
Budget Owner (GBU) Qlik detail
2.Choose your GBU:
2.1. Directly in cost details
Hit the GBU / Function dimension
Select the GBU and hit the confirm selection button
You will get the costs for the selected GBU on the dashboard, graphs and total costs (cost details is set to have this 6 dimensions view)
| Note |
|---|
The access macro-package People is restricted by GBU depending on the user ID profile. |
2.2. Via option Selections
Hit option (the button on the top right)
You can select any dimension, like cost center, month and entity etc.
If the options are in dark gray, it means there is no data for these options
3. There are two standard Graphs already set up
- Hit the description to change the comparison data
4. Cost details
- It works by drag & drop
- Build your view to analyze the costs
- Select the order of available dimensions to establish the levels on the dashboard
- Example for GBU Soda Ash with Macro Package and Plant
5. You can create a bookmark to store the filters, for the moment the layout is not saved, so you have to rebuild Cost details sequence each time
- You can get back to it choosing bookmark and selecting it
- You can also share the bookmark to any other person
6. At the bottom you can find Vendor costs info (2020/2019)
- A table with the higher costs vendor to lower costs vendor
- A graph with the same info or by biggest delta Vs 19
8. You will find Standard filters and Data sets
- Click on your selection to select / unselect data sets
9. You can choose to work the data as Table or Pivot table
For both:
- You just need to do the selections and the field will move to the dashboard
- You can hit the dimension button and filter what is not available in the standard filters
Table: you can change the sequence of the dimension
Pivot table: you can move also from row to column
10. Download the data to Excel
| HTML Wrap | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
Budget Owner (GBU) BW detail
Directly in BW (WBP) : search for “BW_QRY_CPCOCT01_R1_0001” and choose the highlighted query
| HTML Wrap | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
Than you have to do this selections in the prompt alongside the periods you are looking in Qlik Sense
For GBU
- Select only the GBU under analysis (right click on the dimension)
- Filter by member-make your selection
When finished:
- Use the filters or copy paste to another sheet completing the header of the columns without info
- Create a new sheet and insert a pivot table
The total amount should match with Qlik Sense.
- Drill down to detail
- Check GBU by any dimension
- In this example: Material group, Fixed cost group 3 and cost center
| HTML Wrap | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
Budget Owner (Function) Qlik detail
2. Directly in cost details:
- Hit the “GBU/Function” → “Cbs”
- Hit “2 - Function” and specify the desired function
You will get the costs according to the selection
3. There are two standard Graphs already set up
- Hit the description to change the comparison data
4. Layout change by moving the buttons under Costs Details
Example 1:
Results by Cost Group and Company
Example 2:
Results by Company and Cost Group
Major difference against current Function Fixed Costs report
1. Only the costs from WP1/PF1 are considered in the COSTA project
For thecostsfrom non-ERP Cytecentities are out off scope, bytheendof June 2020, the YTD impactisaround 1.1 MEUR
Sample: Office facility cost, relocated from order/WBS
Sample: Yearly bonus true up, the cost is booked to a common cost center first, then allocated to the specific cost center by cycle
Budget Owner (Function) BW detail
Directly in BW (WBP) : search for “BW_QRY_CPCOCT01_R1_0001” and choose the highlighted query
| HTML Wrap | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
Then you have to do this selections in the prompt alongside the periods you are looking in Qlik Sense
Filter the function by field “2 Function”:
Some of key fields have been included in the template, like:
- Cost Center
- Cost Element
- Vendor
- WBS
- Order
- CAPEX / OPEX
Results displayed by Cost Macro Package in sheet “Check"
| HTML Wrap | ||||||
|---|---|---|---|---|---|---|
| ||||||
|