Data Flow does not run in HBMP mode

Options
Daniele Di Lorenzo
Daniele Di Lorenzo Customer
First Anniversary 5 Likes Advocate 5 Up Votes
in Platform

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? 

Answers

  • Unknown
    Unknown
    Options

    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
    Daniele Di Lorenzo Customer
    First Anniversary 5 Likes Advocate 5 Up Votes
    Options

    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
    Unknown
    Options

    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

Categories