Skip to Content

Hi,

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.

Additionally,

  • 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.


Thanks,

Shardendu





To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply