VARIABLES IN SAP HANA CALCULATION VEW

Variables are the dynamic filters which needs to be applied on the final result (i.e. User can provide the filter during the runtime of the execution).

HOW TO CREATE VARIABLES

To Create variables click on the Semantics and go to Parameter/Variable tab and click on the PLUS Sign.

Variable creation

In the new variable creation widow, we need to give the Variable name, Label(Description) and the attribute  the field where the dynamic filter going to be applied and the selection type needs to be mentioned

• Single Value
• Interval
• Range

We can also mention whether multiple entries are allowed for this variable and whether this variable is mandatory based on the requirement.

For our understanding I have created HANA View on top below table with variable on Plant.

Data without variable

    Entering PLANT = 1000,2000 as variable

Now records with plant 1000 and 2000 alone got filtered.

We will see about creation of input parameters and difference between variables and input parameters in SAP HANA in next post.

Compounding in SAP BW

A compound attribute differentiates a characteristic to make the characteristic uniquely identifiable.

Let's say that you have a manufacturing company and you have manufacturing plants in different country(India,USA,Australia,China) and in each country you have 5 storage location for these plant(10,20,30,40,50). Then it is meaningless to Just mention Storage location(10,20,30,40,50) without plant in Report or KPI. Because storage location 10 will be available in all countries and it makes no sense by just mentioning storage location alone in report. So we need to compound Plant with storage location.

In storage location Info object compounding tab we need to include plant as the superior info object(Plant). Once Plant is compounded with storage location whenever we use Storage location info object in creating  DSO, Infocube or BEX Query, automatically Plant info object will be added to the respective Objects.

The Compounding Infoobject Acts as a compounding Primary Key at the Master Data Table.

InfoObjects in SAP BW

InfoObject is the smallest building block. You need to use InfoObjects to design or configure other SAP BW objects such as InfoCubes, DataStore objects (DSOs), MultiProviders, queries, InfoSets, and so on.  

InfoObjects can be classified into the following types:

• Characteristics (for example, customers)
• Key figures (for example, revenue)
• Units (for example, currency, amount unit)
• Time characteristics (for example, fiscal year)
• Technical characteristics (for example, request number)

Characteristic:

• This type of InfoObject represents business entities that are the subjects of analysis, for example, product, customer, and marketing regions.

Key figure

• This type of InfoObject represents numeric measures of business entities, for example, weight, number, quantity, and amount.

 Time characteristic

• This type of InfoObject represents the period of the transaction between entities, for example, date of billing, month of sale, and fiscal year. Time characteristics are delivered by SAP and aren’t customizable.

Unit

• This type of InfoObject represents the unit of measure for the numeric measures of business entities, for example, the currency, unit of weight, unit of volume, and so on.

Technical characteristic

• This type of InfoObject represents entities that are internal to SAP BW and are technical in type, for example, a data load request ID. (The data load request ID helps in the maintenance and administration of the SAP BW system.) Technical characteristics are delivered by SAP and aren’t customizable.