Show TOC

Supported BW FunctionsLocate this document in the navigation structure

Below you will find a list of functions, which are supported for generating SAP HANA views from queries.

Characteristics
Characteristics, which are selected in the query as dimensions or free characteristics, are assigned as attributes in the SAP HANA view. Navigation attributes of characteristics, which do not have standard as their master data access type, are not supported. If a global restriction for a variable is defined on a characteristic, an attribute is added to the SAP HANA view. This attribute represents the characteristic - even if the characteristic is not selected as a dimension or free characteristic in the query. All compound parents of the selected characteristics are automatically visible as attributes in the SAP HANA view.
Key Figures
Key figures with standard aggregation MIN, MAX or SUM are supported.
Filter
The filter selection restricts the entire query. All the InfoProvider data is aggregated using the filter selection of the query. Restrictions on hierarchy nodes and restrictions with variables, which exclude variables, are not supported. There can be a maximum of one variable per characteristic - unless the variable is of type single value. Variables of type single value represent one value exactly - as there is no limitation regarding the number.
Restricted Key Figures
You can restrict the key figures of an InfoProvider for reuse by selecting one or more characteristics. The key figure that is restricted by one or more characteristic selections can be a basic key figure, or a key figure that is already restricted. Restrictions on hierarchy nodes are not supported. Restrictions with variables are supported if they have specific properties (see below).
Calculated Key Figures
Calculated key figures are supported. The BW query formula is converted to an equivalent SAP HANA expression. Due to the differences in processing special values and calculating units, which are unique on the BW server, the result of the query execution on an ABAP system or BICS system can differ from the result when the SAP HANA view is used. For more information, see SAP Note 2080686 Information published on SAP site.
Currency Translation
Currency translation is based on currency translation types. The following functions are supported:
  • Exchange rate type
  • Exchange rate type from variable
  • Inverse exchange rate
  • Exchange rate determination using FI module
  • Dynamic determination of exchange rate type
  • InfoObject for determining target currency
  • Source currency from data record
  • Select target currency when converting
  • Fixed target currency
  • Target currency from variable
  • Fixed time reference: current date, key date, time reference from variable, query key date
  • Variable time reference: standard InfoObject, start/end of calendar year, start/end of calendar year/quarter, start/end of month, exact day
  • Time shift

The generated SAP HANA view contains the following properties:

  • The result of currency translation is rounded after the corresponding TCURX-CURRDEC entry. If this entry does not exist, the result is rounded to two decimal places.
  • Heterogeneous currencies are aggregated using the standard aggregation of the key figure.
  • If the currency translation cannot be performed when the SAP HANA view is called, the error is ignored and the key figure is not converted.
  • If the source currency is initial, the key figure is not converted and the resulting currency is NULL.
  • In the case of native SQL access, the resulting currency can be accessed by using the attribute <UID of key figure>_UNIT.
Quantity Conversion
Quantity conversion is based on quantity conversion types. The following functions are supported:
  • Conversion factors using central units of measure (T006)
  • Conversion factor using reference InfoObject
  • Conversion factor using reference InfoObject if available; otherwise central units of measure (T006) are used
  • Conversion factor using central units of measure (T006) if available; otherwise reference InfoObject is used
  • InfoObject for determining unit of measure
  • Unit of measure from data record
  • Select unit of measure for conversion
  • Fixed source unit of measure
  • Target unit of measure from variable

The generated SAP HANA view contains the following properties:

  • In the case of native SQL access, the resulting unit of measure can be accessed by using the attribute <UID of key figure>_UNIT.
  • If the data type of the key figure is QUAN, the result is rounded to three decimal places. If the data type of the key figure is FLTP, the result is rounded to 16 decimal places.
  • Heterogeneous quantities are aggregated using the standard aggregation of the key figure.
  • If quantity conversion cannot be performed when the SAP HANA view is called, the error is ignored and the key figure is not converted.
  • If the source quantity is initial, the key figure is not converted and the resulting currency is NULL.
Variables
Variables are parameters of a query, which are used as placeholders for characteristic values. Variables with the following properties are supported for currency translation and quantity conversion and for calculated key figures:
  • Processing type is Manual Entry/Default Value
  • It represents one value only.
  • It has a default value. If it is based on 0DATE, the initial default value is converted to a now () function
Variables with the following properties are supported for global restrictions:
  • Processing type is Manual Entry/Default Value
  • the operator must include and not exclude values
  • It represents one single value only, multiple single values, an interval or a selection option.
  • Default values are only supported for single values and multiple single values, if the list of default values only contains one value.
The generated SAP HANA view contains the following properties:
  • BW variables for currency translation and quantity conversion are converted into an SAP HANA input parameter. If the SAP HANA view is called using native SQL, the input parameter cannot be supplied. In this case, the default values are applied.
  • Using SAP HANA SQL you can supply the parameters with the following addition:
    with parameters 
    ('placeholder '=('$$<VARIABLE_NAME>$$',‘<VARIABLE_VALUE'))
  • BI clients, which can read the BIMC folder from SAP HANA, can generate a corresponding variable screen.
  • BW variables for global restrictions can be transferred to SAP HANA views variables. If the SAP HANA view is called using native SQL, these variables are ignored.
Non-Cumulative Key Figures
Non-cumulative key figures with exception aggregation LAST are supported. For more information on restrictions, see SAP Note 2032830 Information published on SAP site.