Interested to Buy Any Domain ? << Click Here >> for more details...
what is loop in frameworkmanager ?
- 4 Answers
- 12331 Views
- Texas, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s.srinivas
A LOOP IS A CLOSED PATH IN FRAME WORK MANAGER DUE TO
JOINS.WE ILL RESOLVED IT BY CREATING ALLIAS AND CREATING
SHORT CUTS
| Is This Answer Correct ? | 7 Yes | 0 No |
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 |
Answer / shekar
loop is closed path in reportnet it called as ambigous
relation ship. that means a query subject contians
multipule paths to retrive the data
it is a exception to reslove to create a shortcut on that
query subjet
other wise it displys wrong results in reports and
perfomens is digreegs.
| Is This Answer Correct ? | 4 Yes | 1 No |
Which service handles requests for cognos connection,query studio and event studio.
Can any body suggest me that Drill through of packages is possible? If yes, how it can be done?
If you got any problems while developing the reports, then what will you do? How will you debug the problems? This question isasking in many interviews,,,, pls help me,,,
how can I test reports in cagnos?
How to change Boolean variable Yes As "TRUE" and No as "FALSE" in Cognos reporting studio?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
diff b/w layout calculation and query calculation
In Report page i have three types like (List,Cross tab,Chart), using Conditional Block i need only type of Report (Chart)at run time.How to do this I need The Complete Steps to do this?
How do you call a store procedure within a transformation?
What do you understand by the term 'dynamic cube'?
How you create IQD In ReportNet FrameWork?
What are the uses of query explorer? Give example for each use in detail. It is not given clearly in user guide so explain in detail.
Teradata 
