Skip to Content
Author's profile photo Former Member

Best Practices while creating a Universe.


Here i am mentioning some best practices while creating a universe :

1. Common Points in Universe Conversion

  • Check all parameters and settings after conversion
  • Sometimes they change, though I haven’t seen this with SP-04
  • Run the Integrity Checker after conversion
  • Make sure that all joins and objects still parse Correct any issues
  • You can choose your Default settings for the Integrity Checker

Preference -> Information Design  Tool -> check Integrity

2. Welcome to the Family

  • Use Families to keep track of your tables
  • One family for each fact, and related tables One family for conformed dimensions One family for Alias tables
  • One family for Derived tables
  • You can use a comment box for a legend of colors Be consistent with colors across all universes

3. Did You Know You Could Color Code Descriptions?

  • That’s right! Use HTML Tags to color code the descriptions of objects.


  • A good universe has 300 to 500 objects, but may have up to 700 objects
  • This depends on the technical ability of the users
  • Unless you need a multi-source universe, create it as a single-source universe
  • This avoids the overhead of using the Data Federation layer
  • Every object, without exception, should have a description
  • Descriptions must be in user friendly terms
  • Don’t use underscores in anything seen by a user
  • Develop, and stick to, naming conventions
  • Document everything you do!
  • Someone else may need to continue your work
  • Use user friendly names for all universes, folders, and objects
  • Have a team of power users check your work throughout the development process
  • Create all LOV s from dimension tables, even if you have to create them
  • Alternately, you can create static LOV s
  • Give LOV s meaningful names
  • This will help when troubleshooting LOV issue

Hope these above mentioned points will help while creating universe.



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good Information 🙂 😎

      Author's profile photo Former Member
      Former Member