How To Optimize The Design Of Universe?

1.	How To Optimize The Design Of Universe?
Answer» 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 LAWs are ticked only for the objects that may be used for REPORTS. Ensure the Data prompts are PROPERLY defined.

Answer»

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 LAWs are ticked only for the objects that may be used for REPORTS.
Ensure the Data prompts are PROPERLY defined.

Discussion