Data flow hangs at "Aliging"

Chad Botbyl
Chad Botbyl Customer
Second Anniversary
edited April 2020 in Platform

Hello,

 

Running into an interesting issue. Trying to move data from a 3 dimension cube to a 4 dimension cube, both sparse. The data seems to hang at the following location for roughly 3 minutes. Both cubes have a single version defined.

image

 

Cube 1:

  • Month Dense
  • Employee Sparse
  • Version Sparse

Cube 2:

  • Month Dense
  • Employee Sparse
  • Version Sparse
  • Full Account Sparse

Any ideas or input would be great.

 

Thanks

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers

    Hi Chad Botbyl,

     

    did you try the "open sparsity" option in the configuration of your dataflow? Since a dataflow doesn't create new sparse entries, this could be the trick--refer to this thread What is Open Sparsity? for more information.

     

    Kind Regards,

    Helmut

  • Daniele Di Lorenzo
    Daniele Di Lorenzo Customer
    Fourth Anniversary 250 Up Votes 100 Likes 100 Comments

    Hello

    In addition to Helmut Heimann proposal, try also to unflag the HBMP mode or set the Full Account dense

  • William Le
    William Le Customer
    10 Comments Second Anniversary 5 Likes

    Hi Chad Botbyl,

     

    I think because the target cube has one dimension that the source cube doesn't have, then the source value is repeated for each member of the exceeding dimension of the target and the 'open sparsity' is enable in this case.

     

    Regards

    William Le

  • Pietro Di Cino
    Pietro Di Cino Customer
    10 Comments Second Anniversary 5 Likes

    hi, 

    I suppose that you have to use:

    1) a selection on dimension "Full Account";

    2) or a matrix structured by the dimension that allow to split data by "Full Account";

    I think that also HBMP Mode not works properly in this case and can be helpful to unselect this option.

    Regards.

Categories