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 is meant by alternate drill down with ex?
How do we drill through from a powerplay cube to reportnet?\
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
How is possible this scenario using in type-in prompt.?
how to merge 2 crosstabs thans
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
Explain the characteristics of cognos?
-------------What is Coditional Prompting?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
What are the message flows?
what is the procedure for scheduling conditional rendering?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
Name the types of report?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?