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
What are query items?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
Define the cognos reporting tool?
how to create cubes in transformer ?
how to create measures and dimensions?
Explain the difference between powerplay transformer and power play reports?
Explain the characteristics of cognos?
How create measures and demensions?
What is the use of powerhouse?
Define query items?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What is a Datastore in Cognos?
how you migrate reports to cognos 8 from previous versions?
What junk dimension contains?