If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Building Summary Cube from Detail Cube

Started by kattaviz, 24 May 2010 03:03:32 PM

Previous topic - Next topic

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.
thanks & regards
Satish Katta

MFGF

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

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

Quote from: bloggerman on 18 Aug 2010 12:04:03 PM
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.
Meep!

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.
Meep!