Procedure to populate cube

andreaLin....

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

ANKITA SAHA

Hi,

Andrea you can follow the steps given below -

andreaLin....

https://community.board.com/discussion/comment/18904#Comment_18904

Hi,

The first cube is used for client data entry. Based on specific months, the procedure (or anything else) will update the second cube in a different data view.
(in reality there is a middle phase that i'm trying to skip using something more simple)

Helmut Heimann

Hi @andreaLin.... ,

then I'd suggest to follow the idea of using a mapping cube (where @ANKITA SAHA has provided a comprehensive example).
Let us know if that will work for you.

Best,
Helmut

Helmut Heimann

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