Dataflow between two cube with one different entity

Hello everyone,

I have 2 cube:

- cube A ("Previsione Parametri Valore Elab - IdElab") with dimensions: Year (Anno), Entity 1 (SOCIETA'), Entity 2 (VERSIONE BILANCIO), Entity 3 (PARAMETRI ELAB)

- cube C ("Importo Variabili Budget") with dimensions: Year (Anno), Entity 1 (SOCIETA'), Entity 2 (VERSIONE BILANCIO), Entity 4 (Variabili Budget)

I want to copy values from Cube A to Cube C.

To signal the link between Entity 3 and Entity 4 I made a third cube (cube with these 2 entities:

where i put flag on the intersection to link the Members of the two entities: (example)

Then I made a Dataflow where cube C=cube A*cube B

The aim is to obtain the value that for example is on member "SOCIACC" of cube A in member "DSO001 Soci Acconti" of cube C, but it doesn't work.

I obtain the same result on all cube C's members.

Where is the mistake?

Thanks in advance

Giulia

Find more posts tagged with

Accepted answers

All comments

Dietmar Jeschkeit

Hi Giulia Messina,

your mistake is how BOARD is doing the dataflow. One rule for a dataflow is that the source cubes are aligned to the destination cube before the dataflow is running.

In your example that means that in Cube A dimensioned by Year (Anno), Entity 1 (SOCIETA'), Entity 2 (VERSIONE BILANCIO), Entity 3 (PARAMETRI ELAB) the Entity 3 is omitted because the entity is not in Cube C dimensioned by Year (Anno), Entity 1 (SOCIETA'), Entity 2 (VERSIONE BILANCIO), Entity 4 (Variabili Budget).

Your dataflow then looks in BOARD like:

Cube A (Year (Anno), Entity 1 (SOCIETA'), Entity 2 (VERSIONE BILANCIO)) * Cube B (Entity 4 (Variabili Budget))

Entity 3 (PARAMETRI ELAB) is lost in the dataflow because it is not in the destination cube !

To get the right result you have to add the Entity 3 to the destination cube (maybe a Temp-Cube). Then your dataflow will work. If you use a Temp-Cube you can then do a second dataflow from Temp-Cube to your Cube C by loosing Entity 3 (PARAMETRI ELAB).

Dietmar