dataflow problem

andreaLin.... · 2024-11-13T18:02:43+00:00

There was an error rendering this rich post.

Hi All,

i have a problem with a calculation between 2 cubes

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.

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

Find more posts tagged with

Dataflow

Procedures

Accepted answers

Helmut Heimann

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

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

Best,
Helmut

All comments

Helmut Heimann

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

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

Best,
Helmut

andreaLin....

hi @Helmut Heimann thanks for your reply

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

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