How to create two cubes using one model.

[Atul73]

Hi,
I have one model with which I want to generate two powercubes for two different customers.
All the data is stored in one single table.
For ex. I have two cutomers A & B. And I have 100 records for each customer A & B.
I want to generate a cube for customer A & B separately.
The dimensions & measures are same for both the customers.

How do I do this ?

Atul.

 

[n30er]

Does the data for both customer need to be in both cubes? If not, try using the customer name as a dimension, creating a dimension view for each customer, and using each view for the 2 cubes appropriately.

 

[Guest_imported]

Create a cube group based on customer name

In Transformer select the PowerCubes Window
Right Click
Select from Menu Insert PowerCube
Select CubeGroup tab
From box select cubegroup dimension eg (All Customers)
Select level (Customer Name)
This will now generate a separate cube for each customer in the model.

This is a feature of 6.61, Transformation Server for Windows

Regards

Tony Goldsmith