Procedure to populate cube

andreaLin....
andreaLin.... Active Partner
Board Developer Name Dropper First Comment
edited November 8 in Platform

Hi all,

i just want to ask how to do the following thing:

basically i have Cube A (1 dimension as Entity ) and Cube B ( Month dimension)

i want to create a procedure that can use Cube A to populate Cube B based on a month selection.

I hope you can help me with this problem.

Best regards,

Andrea

Tagged:

Accepted Answers

Answers

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

    Hi @andreaLin.... ,

    if you want to do that in dataflows, you'll need to select before the dataflow—remember that any selection will have an effect on the target of the flow.

    Then you could select line 1 from cube a and months 202403, ..06, ..09, ..12, flow cube a into b.

    Then select 2 from cube a and repeat step 1 with the according months.

    That will be quite cumbersome and perhaps error prone. It would be easier if cube a had the month's dimension as well. Why does it have to be that way?

    You could, of course, use a mapping:

    Lines (from cube a) x months (from cube b).

    Then just multiply b = a x <mapping>

    Best,
    Helmut