Resolving Loops and using Aggregate Navigation

building semantic layer
1

Hi All

I have built a universe which consists of 5 Dim tables, 2 Fact Tables and 1 Agg table with 2 aliases. After including all the joins and creating all the objects i have done a Integrity check and unfortunately i find there are 500 loops :roll_eyes: found which is not a sign of a good Universe.

Could you please assist me which is the best way? As of now the options that i see are

  1. Creating Alaises for the Dimension tables and using Aggregate Awareness
  2. Creating Contexts
  3. Going for multiple Universes for each Fact table

Please let me know your inputs or if you need any more information.

chetan.mudike :us: (BOB member since 2008-02-13)

2

Pretty simple:
Create one universe context for each fact table.
If you had done a search you should have found loads of topcis on this by the way :wink:

Note:
Do NOT alias dimension tables, if they are common to the fact tables (conformed dimensions).

Andreas :de: (BOB member since 2002-06-20)

3

Let us know how you have connected all the tables. By looking only we can suggest a better way.

Rakesh_K :india: (BOB member since 2007-12-11)

4

Hey Andreas,

Thanks for your reply…I have done the same thing. Creating contexts for each Fact table and setting Aggregate Navigation for each objects created from the Fact Table.

Thanks Again!!!

chetan.mudike :us: (BOB member since 2008-02-13)