Resolving loop

[former_member672670]

Hie Guys,

I have a loop in my universe among three tables. All the tables in the Universe are alias tables. When I used detect loop functionality, I got a message telling that the loop cannot be resolved with context. Can anyone guide me on resolving this issue? I've attached the snapshot of the loop below. Thanks.

[Former Member]

You will have to understand how the object from these tables are intended to be used by the end user.

And based on that you will have to create a alias of one of the Dimension to resolve the loop..

[former_member672670]

All i have is an ODBC connection to the database and a SQL query to a Webi Report. The only objects I am familiar with are the ones in the Select clause in the SQL query. What happens if I do not resolve the loop?

[Former Member]

If you do not resolve the loop then you will get less number of records than it should when you use objects from all three tables simultaneously..

[former_member4998]

Hi

If you don’t resolve the loops you will get wrong results and SQL runs in closed path structure. Please find the below link for more info about the Loop’s

http://businessobjectsforum.blogspot.de/2008/07/resolving-loops-in-universe.html

[Former Member]

What do the various tables do?

In business terms, how do they relate to each other?