Repetitive DataFlows

Zain Mahmood

Hello all,

hope you are fine and doing well!

I have following question:

Can someone tell me how to easily adapt DataFlows with a similar configuration? Right now I have an entity with 100 items and I'd like to create a comparison cube with that entity (ACT,BUD,FC,PY). Each comparison has its own cube and I like to filter the new comparison cube with another entity also called comparison containg ACT,BUD,FC and PY.

The Dataflow has following structure:
- Selection
- b=a

For the Selection I just have to change the comparison entity selection and for the b=a-part I have to switch to the respective cube containing the comparison (i. e. ACT, BUD, FC).

It's a bit repettive (in my case 370 clicks per comparison) and it will take hours to achieve that said goal.

Has someone a better idea? Maybe you can export the procedures somehow and adapt it there?

Thank you very much!

Kind regards,
Zain

------------------------------
Zain Mahmood
Business Intelligence Controller
Trevira GmbH
Germany
------------------------------

sudhir raju

Hi Zain, 

Apologies for the delay in our reply. 

I don't fully understand the ask. Would it be possible to provide an example screenshot or a wireframe of what you are trying to achieve?
Alternatively, I can arrange a 15mins call, and we can go through your requirement. 

Please let me know what works well for you. 

Regards, 
Sudhir 


------------------------------
Sudhir Raju
Solution Architect
Board Community
United Kingdom
------------------------------
-------------------------------------------