Skip to Content
0
Jan 22, 2019 at 10:11 AM

Dynamically Select a characteristic in HANA View

132 Views

Hi,

Need your expert advice on type of join I can use in HANA Calculation View to meet the below requirement.

I am trying to build a HANA Calculation view based on BW Composite Provider and to develop a bex query on top of HANA View.

As attached in the screenshot, My data model consists of 13 characteristics and 1 Key Figures(Measures).

To build my KPI in the report,

Ex 1: If User Entered 005.2019 then

KPI Definition:

KF1

restricted with Fiscal year/Period (001.2019 – 004.2019) (This can be achieved by user exit variable) and

(as user entered 005.2019) restricted with characteristic C05

Ex 2: If User Entered 008.2019 then

KPI Definition:

KF1

restricted with Fiscal year/Period (001.2019 – 008.2019) (This can be achieved by user exit variable) and

(as user entered 008.2019) restricted with characteristic C08

How/Which join I should use to switch characteristic (C01 –C12) DYNAMICALLY based on User entered Fiscal year/Period

Thanks in advance