IBP & HCI-DS: Possibility to choose datasource table within iFlow with global variable

[former_member70798]

Hi,

Is it possible to choose datasource table within IFlow with help of global variable?

In my case I want to choose from 3 versions of the same calculation scenario (its different versions of same key figures)

Thanks in advance!

[Former Member · Accepted solution]

Hi Sergey,

No this is currently not possible.

There's a similar feature request to change the target table at run-time, but it looks like your case is where you want to dynamically change the source table in a dataflow.

You can log new ideas/feature requests in our Idea Place session, items with highest number of votes will be considered for future releases of HCI-DS.

https://ideas.sap.com/SAPHANACloudIntegrationfordataservices

Thanks,

Ben.

--

Product manager SAP HANA cloud integration for data services and HANA smart data integration

[Former Member]

Hi Sergey,

I think you can do it. Yo can use the 3 Versions as Source Table and join them using the Period ID. Then use the logic to choose which version is the right one in every field mapping.

For example (using 2 versions):

join V1 and V2 using the condition "V1.PERIODID = V2.PERIODID"

In memory you will have the structure:

Then you add the mapping logic to every field

OUTPUT.KF1 -> ifthenelse($Version = '1' , V1.KF1, V2.KF1)

OUTPUT.KF2 -> ifthenelse($Version = '1' , V1.KF2, V2.KF2)

Is this what you were lloking for?

Roberto Ostuni