- Key Figure Not Added By Bw Generated Analytic View Of Data
- Key Figure Not Added By Bw Generated Analytic View Of Business
Feb 13, 2014 To explain the differences between calculate key figures, restricted key figures and formulas. Queries can contain different types of key figures, Restricted, calculated and also formulas. Below is an explanation of each. Restricted Key Figures The key figure is restricted based on a particular characteristic filter. The member in the selection list is not enabled for planning. The elements of the view can be positioned on multiple axes. The elements can be directly annotated with their axis.
Introduction
A so-called Transient Provider is an InfoProvider in BW that is not modeled in the classic sense in BW, but generates its BW InfoProvider metadata (including the infoobjects) out of the metadata of the source. The concept of Transient Provider is new with BW7.30 and as of today there are several types of Transient Providers implemented in BW.
Their biggest advantage is that the metadata in BW is not persisted, but always generated at runtime, i.e. if the source metadata is changed the Transient Provider is adapted automatically. The Transient Provider is therefore especially helpful in ad-hoc and/or frequent changing scenarios.
Their biggest advantage is that the metadata in BW is not persisted, but always generated at runtime, i.e. if the source metadata is changed the Transient Provider is adapted automatically. The Transient Provider is therefore especially helpful in ad-hoc and/or frequent changing scenarios.
Basically, there are two ways how you can create TransientProviders based on Hana Models. Either you create an Analytical Index or you use the Hana Model directly in a Hana CompositeProvider (HCPR). With SAP BW 7.4 SPS5 and higher, it is recommended to use the option with the CompositeProviders.
CompositeProvider (HCPR) based on HANA Model
As already mentioned above, with SAP BW 7.4 SPS5 and higher, it is recommended to create CompositeProviders(HCPR) based on Hana Models instead of “publishing” HANA models.
- Transaction: RSRTS_ODP_DIS
- The technical name of this kind of Transient Provider (based on a HANA model) always starts with “2H” followed by the technical name of Package and Calculation View
- On the Characteristics and Key Figures tab pages, you can assign BW InfoObjects to the fields. This means that the transient Infoobjects inherit their Meta- and Masterdata. E.g. the attributes of the referenced InfoObject can be displayed in the query (and also used as navigation attributes). It also means the authorizations on these InfoObjects are taken into account. SIDs are created for any master data values that do not exist in the BW system ! See also Setting 'User Confirmed Referential Integrity'
Important Points you need to take into account when using Hana Models(Calculation Views/CV) in BW(HCPR)
- The HANA Model (Calculation View) should only contain formulas which are commutative (which can be calculated before or after aggregation with the same result) - see note 2360503 and the following Example and General aspects of BW reporting on “complex” HANA models. In addition, the HANA model should contain only one level of aggregations.
- Calculated columns with Exception Aggregations defined in a HANA Model ('Counter') are not known by BW Queries. This, in general, leads to incorrect values for such key figures in query results(see note 2267049). Hence, in case exception aggregations are necessary, they need to be defined in a BW query instead, see the following Example.
- Calculation Views with non-unique joins: As discussed in the KBA 2118286, if there are non-unique joins in a HCPR, the setting Join Cardinality is playing an important role since it has an impact on the performance (and memory consumption) and the result of a query. In case you have such a join in a Calculation View which is used in a HCPR, the BW Analytical Engine does not know the details of the join and hence cannot apply the same mechanism in order to avoid duplicate key figure values(see wiki article mentioned in note 2118286). Therefore, in general a query on such a HCPR may display unexpected (duplicated) values.
- Associated InfoObjects: it is important to check whether the data type of the field really matches the data type of the InfoObject. Incorrect assignments can e.g.lead to wrong query results, see the following Example. See also note 2228967. In addition you need to check whether the characteristic uses a conversion routine like ALPHA. If yes, it must be assured that internal values of the corresponding CV field have the correct format(e.g. leading zeros). Otherwise the query may terminate or display incorrect results, see Example II.
- HCPR based on Hana Model: Handling of Null Values
- Associated InfoObjects: Setting 'User Confirmed Referential Integrity'
- When you use Hana Models as BW providers you need to assure that the view does not deliver characters which are not allowed in BW. See Hana Model delivers characters which are not permitted in BW
- Calculated Columns do not use an implicit type casting when being accessed via the ColumnEngine (standard access via BW). This might lead to unexpected results.
Ensure to explicitly define the expected type to avoid an unexpected behaviour, see the following Example. - In case there are Analytic Privileges associated with a Hana Model, the user SAPSID needs the corresponding authorization - see Hana Models with associated Analytic Privileges
- In case key figures of type amount contain currencies where the number of decimal places is unqual to the default of 2 (like JPY), please review Decimal Setting in HCPR on HANA View for Amount Values (KBA 2476282).
- In case you want to use BW Pruning or Hana Native Pruning check the following pages: HCPR based on Hana View with Pruning Table and Pruning Example: HCPR based on ADSO and Hana Model
- In case you want to use calculation view from a different HANA DB in multi tenant scenario: create a local calculation view in BW tenant which is based on the view of the other tenant. HCPRs should only contain views from the BW tenant. See also note 2312583.
- If the Hana Calculation View is client dependent, by default only data from the client the user is logged on is retrieved. However, there is a CV setting which also allows a cross-client access. See Example.
- Calculations Views with parameters and variables
- Technically, parameters are added as so called Placeholders to the SQL statement, see Example.
- Parameters with the names keydate, objvers and language are internally used by the Analytic Engine. Therefore, it is not allowed to use these names for parameters in Hana CVs when they are used in a HCPR. See Example.
- Variables of Hana CVs are used to filter attribute columns. Technically, filter values are added to the where clause of the corresponding SQL statement. In the context of a HCPR such variables are ignored (Note 2412735). If variables are required, you need to define the variables in the corresponding BW query. See Example.
TransientProviders on Analytical Index based on SAP HANA Models
It is possible to “publish” HANA models (Analytic or Calculation Views, not Attribute Views) as a Transient Provider. To publish a HANA model in BW, you simply execute the transaction RSDD_HM_PUBLISH, select the HANA model (using the F4-help) and then “save”. You then have a Transient Provider with the characteristics coming from the “dimensions” of the HANA model and the keyfigures coming from the “measures”.
- Transactions: RSDD_HM_PUBLISH and RSDD_LTIP (overview of all available analytic indexes)
- The technical name of a Transient Provider based on a HANA model always starts with “@3” followed by the technical name of the Analytical Index
- The InfoObjects are given a generic name following the pattern <Providername>@<column_name/alias>
- On the Characteristics and Key Figures tab pages, you can assign BW InfoObjects to the fields. This means that the transient Infoobjects inherit their Meta- and Masterdata. E.g. the attributes of the referenced InfoObject can be displayed in the query (however, these attributes cannot be used as navigation attributes). It also means the authorizations on these InfoObjects are taken into account. SID are created for any master data values that do not exist in the BW system !
- The Analytic Privileges for the DB user for the HANA model are checked, and, if a BW InfoObject is assigned, the Analysis Authorizations in BW are also checked. If a characteristic of the Transient Provider has both, restrictions based on Analytic Privileges and Analysis Authorizations, the filter conditions are combined via a UNION (i.e. the user must have access either based on the Analytic Privileges or the Analysis Authorizations to see data).
Other Types of TransientProviders
Please see TransientObjects and TransientProviers for a good overview to this topic.
SAP Online Documentation
SAP Consulting Notes
- 2228967 Understanding Automatic Field Assignment in the BW Composite Provider
- 2271658Design Considerations for Composite Provider
- 2400004 Checking Pushdown of Exception Aggregations
- 2262899 Transfer Multiple Single Values to HANA Model Input Parameter in a BW Query
- 2603739 Composite Provider: Using input parameter as currency/unit for a keyfigure
- 2438759 HCPR based on Hana Calculation View: Troubleshooting Guide for Queries
Purpose
Key Figure Not Added By Bw Generated Analytic View Of Data
To explain the differences between calculate key figures, restricted key figures and formulas.
Overview
Queries can contain different types of key figures, Restricted, calculated and also formulas. Below is an explanation of each.
Restricted Key Figures
The key figure is restricted based on a particular characteristic filter. A filter his can be done at query level in the 'Filters' tab of query designer or at query output level by doing 'Select Filter Value'. This filter restrcition applies to whole query unlike in RKF where the filter restriction is only for that key figure.
Restricted Keyfigure is keyfigure where you can restrict with Characteristics.
Example1) If you want to value with Actuals or Plan where you will be having same Keyfigure ex.Quantity. two version = 10 (Actuals) and 20 (Plan)
Restricted Keyfigure with Actuals, select version =10 n Quantity keyfigure
Restricted Keyfigure with Plan, select version = 20 n Quantity Keyfigure
Restricted Keyfigure with Actuals, select version =10 n Quantity keyfigure
Restricted Keyfigure with Plan, select version = 20 n Quantity Keyfigure
Example 2) Restricted KF is means to restrict a particular KF with some characteristics value. Suppose your key figure is Sales Quantity and you want to restrict it based on any Material which is your Characteristics then simply drag and drop your KF and right clk on it and just restrict it by the characteristics Material.this will restrict your KF Sales Quantity on the Material Characteristics.
Example (diffrence)
When you use a Filter, i.e. use a char and restrict it to some values in the filter area, this applies to all the KF you may include in the query. On the other hand in an RKF, the restriction of char values affects only this key figure.
(Restricted Key Figure) In your sales analysis report you have customer,material,sales qty,value for an year.You want to show current month sales one more column.You will create a restritcted key figure based on the current month and show it in the report.You will end up with a report
customer,material,sales qty,value,Current Month Qty,Current Month value.
(Filters) The above report you want to show only the current month sales.You will create a filter where the 0CALMONTH = current Month with customer,material,sales qtym,value for the current month only.
customer,material,sales qty,value,Current Month Qty,Current Month value.
(Filters) The above report you want to show only the current month sales.You will create a filter where the 0CALMONTH = current Month with customer,material,sales qtym,value for the current month only.
The Sims 4 City Living CD Key Generator is a fully functional program, EASY TO USE! Our The Sims 4 City Living CD Key Generator is a fantastic tool that let you redeem your The Sims 4 City Living copy FOR FREE! You can use that KEYGEN tool EVERY TIME YOU WANT and REDEEM your WORKING KEYS.
Calculated Keyfigure
If you want add one more filed in reporting point of view, that means for example you have employee salary and commision two key figures are there you want to add one more field, that is Tax, so, you can add one new filed by using some formula. and caliculate the TAX. This is called caliculated keyfigure (CKF)
Example 1. In a DSO we have two iteam Qty and price.. and in target we require Revenue.
So it will be Price * Qty= Revenue ( CKF) Again suppose u require the revenue for the month of April 2008.
Now with the Help of RKF you can restrict the revenue for the month of April 2008 only, so that in RSRT (query) you will find the revenue for the month or April.
So it will be Price * Qty= Revenue ( CKF) Again suppose u require the revenue for the month of April 2008.
Now with the Help of RKF you can restrict the revenue for the month of April 2008 only, so that in RSRT (query) you will find the revenue for the month or April.
Example 2. You have sales amount in your cude with base currency and you want to show that in the report in say 7 different currencies. Which means the same keyfigure in different currencies. Then you can go for a restricted key figure and restrict it in the new selections in columns and set the target currency in the properties. This will display amt in diff currencies.
Use can use a calculated key figure for furthur calculations globally.
Basically u will be creating calculated and restricted keyfigures globally which can be used across different queries on the same info providers.
Use can use a calculated key figure for furthur calculations globally.
Basically u will be creating calculated and restricted keyfigures globally which can be used across different queries on the same info providers.
Diffrence between RKF and a selection : The only difference could be that the RKFs are usable entities that is you can reuse them from one query to another based on the same infoprovider, but if you do not save a selection, then you cannot resuse them in other queries. You need to save them so that they ca be used as RKF's just as formulas so that they can be used as CKF's.
Formula
A formula is local to a query while a calculated Keyfigure is global. When u create a formula it is available for only for that Query. Calculated KeyFigure is applicable across all Queries on same InfoProvider. A Fomula doesnt have Tech name where as CKF must have. All the formula functions from formula builder will be avaialable while creating a formula where as only few of the formula functions are available for CKF.
Related Documents:
Insert SAP Help links or other WIKI content
Related Notes:
Key Figure Not Added By Bw Generated Analytic View Of Business
Insert links to any related notes/KBA that support your topic or are related