jagadeswarreddy.palagani

• Sep 5th, 2005

 

1)make the joins with optimization  
2)reduce the creation userobjects more in the universe 
3)class should not be more than 60  
4)try to use aggreateware on measure objects

Nidhii

 Profile Answers by Nidhii 

• Mar 12th, 2007

 

I would like to add to that
1.Give meaningful name to the Universe
2.Give meaningful names for objects as the user may nt be aware of the technical terms of underlying objects
3.Group all similar objects(coming from single table) into same class/subclass
4. Give meaningful,similar names to alias tables
5. set cardinalities to all the joins present
6.resolve loops.
7.Resolve fan trap and chasm trap if any
8.Define contexts according to the requirement
9.Use aggregate awareness if necessary

I cud think of only these easy,but important steps.

Hope this will be useful to you
Regards,
Nidhi

Kumar Ranu

• Apr 16th, 2007

 

I would like to add...

Universe contains Dimensions and facts.
These are linked with joins so there must be indexes on the dimensions table's columns and if nessesary fact table's columns.

Mostly Bitmap indexes are recomended as for repeated values for unique ones one can use binary indexes.

second one..

Prompts try to find out what kind of prompts are required like is it query based or object based.

Should hide the classes from the users which contains useless objects.

Ranu

sar

• Apr 22nd, 2007

 

Additionally
-- Follow naming convention 
-- Objects and conditions in a class should be either hierarchial or alphabetical
-- Classes/ Sub Classes should be logical
-- Organize the schema, no clutters of joins