How to optimize the design of Universe? - BO Designer

How to optimize the design of Universe?

- The connection parameters should be set based on the underlying database.

- Use joins in the Universe structure.

- Use less SQL functions.

- Obtain most of the parameters / attributes from the database itself or from ETL.

- Remove unnecessary objects from Universe before moving to production.

- Ensure LOVs are ticked only for the objects that may be used for reports.

- Ensure the Data prompts are properly defined.