Data flow hangs at "Aliging"

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.

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

Find more posts tagged with

Accepted answers

All comments

Helmut Heimann

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

Hello

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

William Le

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

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.