Dataflow with open sparsity not working

Uwe

I have found a solution!

hi,

I have a problem with "open sparsity".
I have values in a cube by customer, item and sales organization (all as sparsity) and now I want to change the values from one sales organization to another by procedure.
To do this, I first select the organization I want to take the values from and write them to a temporary cube. Then I want to select the new organization and take the existing values as well as the values from the previous one.
Unfortunately, this does not work because the sparsity does not open even though I have checked "open sparsity".
What can I do?

Thanks a lot

Robert Barkaway

Hi Uwe,

For open sparsity to work your source cube will need to have all 3 dimensions for the sparsity, all dense; You'll probably need a second temporary cube, same dimensionality as your target cube but dense, you flow to that first and then flow that to your target cube with Open Sparsity enabled.

Hope that helps.

Kind Regards,
Rob

------------------------------
Robert Barkaway
Senior Consultant
Board Community
United Kingdom
------------------------------
-------------------------------------------