COGNOS Questions and Answers

What is loop in frameworkmanager?


Loop: loop is a closed path (relation) that exists among 3 (or) more tables. For example, if we have ‘3’ tables T1, T2, T3 then, a loop exists among these tables only when we create joins in the following fashion:


Loop: T1 —> T2 —> T3 —> T1


To resolve the above problem, we have to create a shortcut (or) Alias to the Table T1.


No Loop: T1 —> T2 —> T3 —> Alias (or) Shortcut of T1