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

Number of Cubes

Started by dssd, 21 Nov 2012 12:29:53 PM

Previous topic - Next topic

dssd

I need to determine the number of cubes that i need to use.....I have the below scenario where i have 4 subject areas which deal with different areas of the same business. I have total 5 dimensions...all of which are not applicable to each subject area. Should i have

5 different cubes with 5 different models
5 different cubes with 1 model but exclude a dimension while building the cube? Which is better and why?

dssd

Could anyone share their views

tjohnson3050

If most of the dimensions are shared across subject areas, I would use one model.

dssd

Scenario is something like below

             SArea1      SArea2      SArea3    SArea4
Dim 1       X                X                X             X
Dim 2       X                X                X             X
Dim 3                         X
Dim 4      X
Dim 5                                           X

How many Models? How many cubes should we build?

tjohnson3050

If you want to report on the subject areas together, and cube size is not an issue, then build one model and one cube.


MFGF

It also depends on whether people from one area of the business would be confused by seeing information from another subject area. As tjohnson3050 says, either build a single cube if this is not an issue, or build separate cubes for each subject area from a single model. If you create separate models, you will end up modelling the dimensions multiple times, and you run the risk of modelling them slightly differently, plus you will be repeating the same work over and over.

MF.
Meep!

cognostechie

You could also build just one cube and set security on the subject areas by different user groups (if the users need to see only their subject area)

bdbits

And to add to the numerous choices before you... :-)

You can build one Transformer model, then create different cubes within the one model. You can select which dimensions and measures are included/excluded in the properties for the cube. This has the benefit of one model, but a simplified user experience.

dssd

Can i exclude a level from a cube like i can exclude a dimension. Time dimension is uptil Day but now i want my cube to only have until Month but keep the model as the same. Is it possible?

tjohnson3050

You can create multiple hierarchies with different levels within a dimension.  Go to view - categories.

dssd

Thanks. Are there any maintenance issues associated with it. Would i loose the views if i clean house