RE: What are steps to be taken care to create a good Universe?
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
RE: What are steps to be taken care to create a good U...
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.
RE: What are steps to be taken care to create a good U...
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.
RE: What are steps to be taken care to create a good U...
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
