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
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
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