AnsweredAssumed Answered

Data flow not working

Question asked by william.le on Jul 30, 2018
Latest reply on Aug 1, 2018 by breuber

Dear all,

 

I want to make a data flow action with 3 cubes.

1. Cube A: 5 dimensions: month, base article, customer, production article, production manufacture.

2. Cube B: 3 dimensions: production article, production manufacture, sub article.

3. Cube C: 6 dimensions: month, base article, customer, production article, production manufacture, sub article.

All dimensions are sparsity except month. I want to compute C= A*B. Below are step what i'm doing now

C = A, with open sparsity

C'=B, with open sparsity. It takes a lot of time at this step, maybe because cube B only has 3 dimensions but C' has 6 dimensions.

C = C*C'.

Board takes a lot of time to calculate this. I think because i use data flow with open sparsity and huge cubes. Does anyone have any solutions for this case.

 

Thanks and best regards

Willam Le

Outcomes