Resolving loops in universe

[former_member758697]

Hi,

Anyone please answer below query:

Which are the key points should I keep in mind while resolving the loops in the universe.

and when shall I use an alias to resolve the loop and when a context?

Thanks,

Hemlata Kasar

[Former Member · Accepted solution]

Hi Hemlata,

a very simplyfied answer for a thread like this:

-If you have two fact tables, then go for contexts.

-Make sure you defined correctly your cardinalities and row counts, so that loop detection will predict correctly.

Please check the documentation:

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp6_info_design_tool_en.pdf#page=120

And posts in internet, e.g.:

http://www.dagira.com/2009/07/22/context-versus-alias-overview/

:

Best regards,

Victor

PS: The semantic layer space is more suitable for this kind of questions, this space is intended for Web Intelligence

[Former Member]

Hemalata,

Please go through below references to get complete understanding on resolving loops.Coming to your question on when to go for alias and context

Alias would solve problem in cases where there is Only one lookup table in the schema or if A look up table that receives only "one" ends of joins

table1--- many to one--- lookup table-- One to many table2

Context would resolve problem in cases where there is more than one fact table in schema

Ensure there are no one to one joins in schema which prevent loop detection, alias detection, context detection etc. and make sure all cardinalities are set before using any detection options.

http://businessobjectsforum.blogspot.in/2008/07/resolving-loops-in-universe.html
http://www.bidw.org/business-objects/universe-design/understanding-loops-and-its-resolution-techniqu...

Resolving loops section on Page#227

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_universe_design_tool_en.pdf

Thanks

Mallik