Merge Cubes

Previous Member
Previous Member
500 Up Votes 500 Likes 500 Comments Second Anniversary
in Platform

Hi all,

 

I have two cubes with the same data in, but for different date ranges.

 

I'm trying to merge the two cubes together in a procedure but seem to only ever get the values from the second cube. 

 

I've tried a=b and a=a+b.

 

Any ideas?

Answers

  • Etienne CAUSSE
    Etienne CAUSSE Customer
    Fourth Anniversary 250 Up Votes 100 Comments 100 Likes

    Hi,

    do you have the same sparse/dense structure for both cubes ? if the time range is different, a selection on the date range contained in cube A, then dataflow with cube B=cube A should be enough.

    If the sparsity is different, the "open sparsity" flag can be required.

  • Andrea Florio
    Andrea Florio Active Partner
    Third Anniversary 10 Comments 5 Up Votes 5 Likes

    hi Neil Chapman and Etienne CAUSSE,

    the replay of Etienne CAUSSE is correct but i don't know why, sometimes the "open sparsity" flag can not be enough. If you have problems again you can put with data entry '1' in a target cube for the intersections of entities. I'm shure afther this the dataflow functions.

    Regards

  • Alexander Kappes
    Alexander Kappes Employee
    Fourth Anniversary 250 Likes 100 Comments 5 Answers
    edited March 2020

    Dear Neil Chapman,

     

    I assume that your cubes are able to be summed without sparsity problems.

     

    According to your description the correct case will be summing Cube A and B, but your formular is wrong.

     

    For the case that your target cube is also part of the source your dataflow has to look like this:

     

    image

     

    For your case A = A + B Block A is ignored because of dataflow rule that target cube can´t be used in formular.

     

    Hope it helps

     

    regards

     

    Alexander Kappes

Categories