Level 100

Walter

I have two cubes (A and B). With a Data view, cube A looks something like this;

and Cube B looks something like this;

I want to generate a 3rd table which SUMS both tables.
Like 29(in red) from 1st table to 3(in red) from 2nd table.
I did this at the level of database using SQL. However, I need to do this in board.

Any suggestions, links to related resources, etc. will be highly appreciated.
Thanks

Helmut Heimann

Hi @Walter ,

I'm assuming that you have a unique identifier for your line-items (let's say a record number). That should be a dimension of both cubes A and B. The second dimension could be Month for example (the columns of your table). Then you could just use a DataFlow into a third cube adding both up ( c=a+b ).

Hope that helps!
Helmut

Walter

@Helmut Heimann

Thanks for your response. I’ll endeavor to implement using this approach.
I tried and it worked. Thanks