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
Is it possible to join multiple Databases in a Catalog?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
What are the considerations regarding performance kept in mind while setting up cognos?
Can you explain a cognos controller?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
What are the components used in web tier?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
What are cognos connection initial page components?
what do u mean by bridge group? where we r using this one?
---------------Describe OLAP Reporting and RDBMS Reporting?
-----------------What is Determination Model?
What is the difference between a data mart and a data warehouse?
Write various indexes used in cognos?
10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?