dataflow problem

andreaLin....
andreaLin.... Active Partner
Name Dropper First Comment
in Platform

Hi All,

i have a problem with a calculation between 2 cubes

image.png

First of all, i want update the cube B (5 dimension) using the value of Cube A (2 dimension \the other 3 dimension i used the filter in the procedure) without delete the other part of the cube B.

image.png
image.png

the Algorithm use the cube A and B explained before. The reason of "if(a=0,b,a)" is to update the cube B with the new value of the cube A (only in the combination of Cairo 1, resisdential, principal payment, dummy and months).
BUT this it is useless if the cube B is empty in the interested section and if i try to use this dataflow the result would be zero.

so my request is to understand if it is possible to modify my algorithm and try to include the "empty"cube case

Best regards,

Andrea


Tagged:

Accepted Answer

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    Answer ✓

    Hi @andreaLin.... ,

    we would need to know the dimensions of both cubes in the dataflow (screenshot of the overview tab).

    That should be something like this

    image.png

    Do you extend tuples in the flow, if so, which ones?

    image.png

    Best,
    Helmut

Answers

  • andreaLin....
    andreaLin.... Active Partner
    Name Dropper First Comment

    hi @Helmut Heimann thanks for your reply

    image.png

    the target is cube B and Principal_res is cube A
    and the selections in the procedure are on 1.Division 2.Item and 3.Class

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers

    Hi @andreaLin.... ,

    so it looks like you're not extending the flow to new tuples. But that's what needs to be done.

    Can you please check what happens if you tick "Class", "Division", and "Item Type" in the extend panel of the "Calculation Domain" (refer to my screenshot above)?

    Best,
    Helmut

Categories