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

Daniele Santandrea

Hello Zain Mahmood,

maybe, you can try using a matrix cube in your dataflow.
To better understand, could you please send me a screenshot of the Cube Structure/Procedure Steps?

Regards,
Daniele