I have a data flow that is expected to run in HBMP mode, but it doesn't. And it takes too much time to run.
Only setting "Try Force HBMP mode" it runs properly#
See picture. Can someone help me?
thanks for your reply
Your approach is correct, and I've been already tried it, but the problem was another, related to sparse structures, that are different between the factors.
Setting the cubes with dense structure it runs all in HBMP without forcing it, and it's immediate.
Infact, looking at article about HBMP, I read:
But since a sperse structure is considered as a unique entity, and the factors had different sparse structures, it was not running properly.
You could try as follows:
1) create a cube "COS%" (E), same structure of B and C as E = B/C
2) create a cube "COS% by Line" (F) same structure of A as F=E
3) calculate D = A * F
Hope this helps.
Well done Daniele.
I opted for a full sparse solution assuming we were facing a large number of combinations.
The approach I was proposing aims to bring the common sparsity structure to the last dataflow.
Retrieving data ...