Dataflow between two cube with one different entity

Unknown
Unknown
edited April 2020 in Platform

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)

image

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

image

 

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 B) with these 2 entities:

image

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

image

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

image

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

Answers

  • Dietmar Jeschkeit
    Dietmar Jeschkeit Active Partner
    Fourth Anniversary 100 Comments 25 Up Votes 25 Likes

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

     

    BR

    Dietmar

Categories