What is looping and how to avoid it in framework manager?



What is looping and how to avoid it in framework manager?..

Answer / Shobhit Kumar Tripathi

Looping occurs when a query or report repeatedly processes the same data, leading to performance issues. To avoid looping in Framework Manager, use the UNION ALL operator instead of UNION when combining queries that have identical structures.nAlso, be careful with recursive relationships and ensure they are properly defined.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

Explain the characteristics of cognos?

1 Answers  


What are the types of security?

1 Answers  


What is the difference between drill through, drill across?

1 Answers  


example for generated prompt

1 Answers  


Which service handles requests for cognos connection,query studio and event studio.

3 Answers   HCL,


How to move reports one server to another server?

2 Answers   Wipro,


what are burst options you have?

2 Answers   HCL, IBM, TCS,


After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?

1 Answers   IBM,


how you migrate reports to cognos 8 from previous versions?

1 Answers   IBM,


drillthrough vs master detaild report,which one is the best by performance?

3 Answers   IBM,


what is stitched query???

2 Answers   IBM,


WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS?

2 Answers   ABC Infotech, Virtusa,


Categories