Dataflow with open sparsity not working

Options
Uwe
Uwe Customer
First Anniversary First Comment
edited October 2021 in Platform
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

Answers

  • Robert Barkaway
    Robert Barkaway Employee
    First Anniversary Level 100: Foundations of Building in Board Level 200: Leveraging Board for Business Insights First Comment
    edited October 2021
    Options
    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
    ------------------------------
    -------------------------------------------

Categories