Description | CBS - GBU - Costing Overall (Core query) |
|---|---|
| Technical Name | QVSBS_BW_QRY_MPR_FC001_0023 |
Application | CBS |
Info-provider | MPR_FC001 |
Usage type | Qlikview Source |
Expected users |
Workbook/Query General Description
This query is used as a source for the "Used Cost Centers" KPI in the SBS RTR and SBS Macro KPI dashboards in QV. The objective is to get the list of all the cost centers which have an amount posted on each period for the current and previous years. QV doesn't use the amount itself but simply counts how many cost centers had an amount each month.
When QV loads the data from this query it also gets the cost centers were the Check Amount = 0. This is normal because this happens when there is a + and - that totals 0. We still want to consider that cost center as "used". |
General parameters
Global properties
| Tab | Screenshot | Comment |
|---|---|---|
| Extended |  | For QV to be able to access it. |
Variables
Definitions
Variable Name | Info-Object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
C_YPERAA | 0FISCPER | Client Exit | No Selection | Selects automatically current end previous year fiscal periods |
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| InfoProvider (0INFOPROV) | CUB_FC005 + CUB_FC006 | Only PF1 and WP1 data - in this KPI we only include PF1 and RCS cost centers (excludes CICC / Acetow) |
| Currency Type (0CURTYPE) | 10 - Company Code Currency | We only need 1 type of currency - Filter so that we don't take lines for other currencies |
| Fiscal period (0FISCPER3) | 001 to 012 | This is to exclude fiscal periodes 013 to 016 which are not used in this KPI |
| Cost Center (C_COSTCTR) | <> # | As this query is used to count used cost centers, we exclude amounts not coming from cost centers (Ex : WBS...) |
| Controlling area (0CO_AREA) | <> Z010 | We exclude cost centers from Z010 controlling area (Non Solvay Entities) - This was created for the New Eco Services |
Key figures
Check Amount
Description
It's the sum of the Debit and Credit. The amount itself is irrelevant : we only want to know if there was an amount or not.
Since in many cases Debit + Credit = 0, what we do in this calculation is in fact Debut - Credit. There are still some cases where it will be 0 but QV can actually still pick up those lines.
Calculation rule detail
Debit Amount - Credit Amount
Debit Amount
Description
Debit amount used for the Check Amount key figure.
Calculation rule detail
Amount (0Amount) with Sending/Receiver = S (Debit Posting or Receiver Debit Posting)
Credit Amount
Description
Credit amount used for the Check Amount key figure.
Calculation rule detail
Amount (0Amount) with Sending/Receiver = H
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
| Rows | 0FISCPER | Fiscal Period | Used as the time dimension in QV |
| Rows | C_COSTCTR__C_COMPCDE | Company Code | Company code of the cost center. Used as a dimension for QV. QV also takes the country and zone from it. |
| Free | C_COSTCTR | Cost Center | This will be used in QV to count. |
| Free | C_COSTCTR__0LOGSYS | Source System | This will be used in QV for filtering between PF1 and WP1 cost centers |
| Free | C_COSTCTR__C_FUNCT_1 | 1 Organisation | This will be used in QV to check how many cost centers do not have an organisation (and therefore do not exist in the standard cost center hierarchy ZCBS |