Cube consolidation?

[jvaneert]

Hi there,

For our 4 sales organization i make sales cubes.
Eacht month i update 4 cubes.

Is it possible to consolidate these cubes into 1 sales cube?

Each cube is built with a query from a unique data source. So 4 datasources are queried for 4 cubes.

What are the possibilities.

Jules

 

[Draoued]

if the 4 cubes are exactly the same .
In one model , you can create 3 others cubes, and defined alternative sources in the cube property so you ll run one model and 4 cubes will be created.

 

[jvaneert]

Draoued,

I want 1 cube with the data from 4 sources included.

regards

jules

 

[Draoued]

désolé Jules.

take the 4 sources , and add them in the data sources, Transformer will do the consolidation by itself.
So in data sources , you ll have 4 iqds which are populating the same measures.
Maybe you'll need an extra info , to identify the sales organisation