what is loop in frameworkmanager ?
Answers were Sorted based on User's Feedback
Answer / s.srinivas
A LOOP IS A CLOSED PATH IN FRAME WORK MANAGER DUE TO
JOINS.WE ILL RESOLVED IT BY CREATING ALLIAS AND CREATING
SHORT CUTS
| Is This Answer Correct ? | 7 Yes | 0 No |
A LOOP IS NOTHING BUT A CLOSED PATH DUE TO JOINS IN FRAME
WORK MANAGER. THE JOIN CONSISTS OF ATLEAST THREE TABLES.
THIS PROBLEM CAN BE RESOLVED BY USING ALIAS OR SHORT CUTS.
THE LOOP GENERALLY DEGRADES THE PERFORMANCE BECAUSE IT TAKES
MORE EXECUTION TIME AND DISPLAY WRONG RESULTS DUE TO A
NUMBER OF JOINS.SO WE BETTER TRY TO AVOID USING OF LOOPS IN
FRAME WORK MANAGER TOOL.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / shekar
loop is closed path in reportnet it called as ambigous
relation ship. that means a query subject contians
multipule paths to retrive the data
it is a exception to reslove to create a shortcut on that
query subjet
other wise it displys wrong results in reports and
perfomens is digreegs.
| Is This Answer Correct ? | 4 Yes | 1 No |
Explain the difference between native sql and cognos sql?
what is the use of lock and unlock
How to create measures and Demensions?
3. What was the size of your cube?
What are user classes?
diff b/w dimension and regular dimension
difference between impromptu and cognos8
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
in reportnet how u burst the reports for every 5th day, 10 th day, 15 th day, 20 th day
What are the advantages of using cognos sql?
What are the different types of important services used in cognos?
What is the difference between a cascading report and drill through the report?