Co$ta - Release 2

>> Back to the Co$ta project home page








Determination Rules for Cost Package


General Principles for the Database R2

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


Full Business rules here.


Cost Package Determination (R2)


General Table

Exception Table (old codes; etc)



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 option Selections

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


REMINDER: When you set a filter, it is applied to all the dashboard views and related graphs


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


7. My report view (in addition to the Package owner) 

  • Go to Qlik Sense here, select My report


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


Other details about the Package Owner Qlik here.

Package Owner BW detail


Directly in BW (WBP) : search for “BW_QRY_CPCOCT01_R1_0001” and choose the highlighted query


Template already filtered to match Qlik Sense dashboard by Macro Package here.


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


Other details about the Co$ta BW query here.

You can see in more detail on the documentation information about the dimensions, for example Package Derivation Source under Co$ta - Package assignment.

Determination Rules for Budget Owner Dimensions

Dimensions of Budget Owners in Dashboard










  • IF no CC assigned costs will show as not assigned
  • IF CC not assigned to ZCBS hierarchy the Cost stay as NA (Function) (no GBU, no Plant; etc)


Derivation from other Objects


IF No CC assigned. The Cost stay as NA (no GBU, no Plant; etc)

Only Order category: 01 and 30


Budget Owner (GBU) Qlik detail


1. Go to Qlik Sense here, select budget owner cost and confirm GBU is selected



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)

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



7. My report view (in addition to the Budget Owner)

  • Go to Qlik Sense here, select My report


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


Keep in mind that these are costs at Origin so they will have GAP to GBU/cost center reports.

Main reasons:

  • Allocations to CAPEX
  • Costs charged / received to / from other CC group
    • Normally via secondary Cost Elements
    • Eg: Allocations from Plant FC to SG&A / SG&A to Plant FC
  • Allocations to variable costs
  • Cost Charge back to Interco or External
  • Spare parts consumed

Other details about the Budget Owner Qlik here.

Budget Owner (GBU) BW detail


Directly in BW (WBP) : search for “BW_QRY_CPCOCT01_R1_0001” and choose the highlighted query


Template already filtered to match Qlik Sense dashboard by Macro Package here.


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

Other details about the Co$ta BW query here.

More details in the documentation information of the dimensions, for example:


Budget Owner (Function) Qlik detail


1. Link to co$ta dashboard here

  • Select Budget owner Cost

  • Confirm that FUNCTION is selected


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 the costs from non-ERP Cytec entities are out off scope, by the end of June 2020,  the YTD impact is around 1.1 MEUR


2. The cost allocated from other Function team by 2nd cost elements  (WP1:99XXXXXX, PF1:9XXXXXXXXXX) are out of scope


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


Other details about the Budget Owner Qlik here.

Budget Owner (Function) BW detail


Directly in BW (WBP) : search for “BW_QRY_CPCOCT01_R1_0001” and choose the highlighted query


Template already filtered to match Qlik Sense dashboard by Macro Package here.


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"

Other details about the Co$ta BW query here.

More details in the documentation information of the dimensions, for example:


  • No labels