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
Can you define confirmed dimension?
What is a Folder?
What is cognos powerhouse?
Why is auto-regression used in forecasting used on cognos platform?
What is a Query Subject?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
-----------------What is Direct and Conventional loading?
What errors and types of errors you faced in Cognos ReportNet?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
Why cognos scenario is used?
What is the difference between Open Connection command ang Open Session Command?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
What are the different kinds of panes included in cognos?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
What is the size of database for you project?