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 |
| PRS Company Consolidation Method (C_COMPCDE__C_CSMETH) | = 30 +10 |
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
