Answer:
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
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
| Previous Question | Next Question |
| How create measures and Demensions? | What you mean by Drill across and what is the difference between drill through, drill across? |