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