Designing a good universe includes a clear understanding of the client requirement, choosing correct database schema, choosing correct data modelling techniques.
1. Analyze the requirement.
2. Identify the report requirement.
3. Choose the correct schema.
4. Create the Connection.
5. Choose the tables and objects.
6. Specify the joins and cardinalities.
7. Detect the loops, Chasm Trap and Fan Trap.
8. If any join path problem is there then resolve it using alias and context.
9. Test the universe.
|