Answer Posted / samir kumar sahoo.
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 |
Post New Answer View All Answers
Define dimensions?
What is difference between primary key and unique key constraints?
Define the slice and dice?
can we insert all types of charts in a list report? what r the realtime prompts?
What actually a project contains?
how you create security to reports?
What is the difference between Standard and Metrics folder?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
What are all types of Batches?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
Mention the difference between ‘macros’ and ‘prompt’?
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
------------------What is Inline Query?
What do you understand by the cognos?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?