Building Summary Cube from Detail Cube

[kattaviz]

Hi,

I am new to Transformer modeling. We have to create 2 cubes (Summary,Detail). I want to know if it is possible to create Detail Cube first and then Summary cube from Detail cube. I have one large Detail table in my Database. I would like to create two cubes (Summary,Detail) form that single table.

[MFGF]

You can build them from the same Transformer model, yes.

[bloggerman]

I was just reading more to understand cubes better and was wondering by what we mean by Summary and Detail cubes.

How do we build them through the same model?

[MFGF]

I was just reading more to understand cubes better and was wondering by what we mean by Summary and Detail cubes.

How do we build them through the same model?

A summary cube and a detail cube generally have the same overall dimensions, but the summary cube has fewer levels

eg a model with two dimensions - Time and Geography

The Summary Cube has just the Year level in the Time Dimension, and the Country level in the Geography dimension.
The Detail Cube has Year, Quarter and Month levels in the Time Dimension, and Country, Region and City levels in the Geography dimension.

In Transformer you can add multiple powercubes in the Cubes window, then edit the properties of each to define which dimensions/levels are included.

Cheers!

MF.

[bloggerman]

You mentioned you can edit a cube to exclude dimensions and measures. Does it hide measures or completely removes it from the cube? If it hides the dimensions then the size of the cube would remain the same. Could you please confirm. Thanks

[MFGF]

Hi,

Measures can be included or excluded - if they are excluded, they are physically not in the cube at all.

Dimensions can be fully included, omitted, or represented as a view.  If they are omitted, they are physically not in the cube.  To get a summary cube, a Custom View would need to be defined for each relevant dimension to summarise the members at the top level. These custom views would then be used in the cube, and would result in only the top level members (and their relevant summarized measure values) being included in the cube.

Regards,

MF.