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
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
is cognos 7 is better than cognos 8
What errors and types of errors you faced in Cognos ReportNet?
Define datastores in cognos?
What is called cognos reporting tool?
Can you define fan trap?
What is zero-foot print?
what are slowly changing dimensions? Why we are used scd?
Can you define report item?
2. What functional area you worked on.
What are all the components of Report Studio?
What are the two types of framework manager?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
Mention the difference between ‘macros’ and ‘prompt’?
Can you explain cognos planning?
