what is loop in frameworkmanager ?
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 |
what is report studiio and how to start it?
How to create users and permissions in cognos?
What are products of cognos?
What are the types of studio present in Cognos?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
Why do we create shortcuts in framework manager
10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list Rank Running-count
what is materialised view? why we use it in data warehousing?
where do we see the run time of the report ?
Why is auto-regression used in forecasting used on cognos platform?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
What is the advantage of using shortcuts?