Data Flow does not run in HBMP mode

Daniele Di Lorenzo

Hi all

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?

Find more posts tagged with

Accepted answers

All comments

unknown

Hi Daniele.

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.

Gianfranco

Daniele Di Lorenzo

Hi Gianfranco

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:

All cubes in the layout must have all the dimensions of the Data Flow’s “Target” cube, even if at a different level of aggregation.

But since a sperse structure is considered as a unique entity, and the factors had different sparse structures, it was not running properly.

best regards

unknown

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.

Kind regards,

Gianfranco