| |
GeekInterview.com > Interview Questions > Data Warehousing > Business Objects
| Print | |
Question: Universe Design
Answer: How will you ensure that the universe designed is optimum? |
| April 04, 2009 17:53:35 |
#2 |
| Rajnish_kaushal |
Member Since: April 2009 Total Comments: 10 |
RE: Universe Design
|
Best way to make sure Universe Design is optimum is by following the best practices. couple of things which we can look into for optimisation
1. Connection parameters are set as per the underlying datbase system.
2. Joins in the universe structure. When i say joins we need to make sure that queries traverse minimum nuber of tables.
3. Check Objects and try to use as less SQL functions as possible. Try to get most of things as attributes in ETL or database itself.
4. Make sure derived tables are used as last resort.
5. Unneccesary objects are removed from universe before moving to QA/Production.
6. Make sure LOVs are only ticked for objects which may be or are used in reports. By default most of the time , every object has lovs. So we need to make sure we do not end up making universe bigger than it should be.
7. Make sure Date prompts are defined properly. Make sure LOVs used in Date Prompt do not have time stamping. I have seen this making lot of difference. Date Prompts sometime take time to refresh and this is only because LOV it is trying to show has time element. This leads to 100s of different combinations.
Regards
Rajnish |
| |
Back To Question | |
