What is loop in frameworkmanager ?
Answers were Sorted based on User's Feedback
Answer / rajitha
Loop is an very dangerous exception in framework manager we
can resolve the loop create alias table. loop Dispaly wrong
results in the reportnet.
A Loop is a Closed Path Circuit....
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / nasa
loop is nothing but closed path
it occurs when relation have like
table 1->relation with-> table 2-> relation with-> table 3-
relation with ->table 1.
here table 3 have the relation again with table 1 so simply
we can say here loop is occurred..
by using shortcut or alias we can resolve this...
table 1->relation with-> table 2-> relation with-> table 3-
relation with -> short cut table 1.
by right click on table we will get shortcut and alias
options..
shortcut: if we update or any modification in original table
that will effect on shortcut of that particular short table
alias: if we update or any modifications in original table
that will not give any effect on alias table
........
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / narayana
avoid loops:using shortcuts.
we have ambiguous relationships types:
hierarchical relationships,recursive relationships,multi-
valid relationships.to avoid these relationships using
shortcuts.
| Is This Answer Correct ? | 3 Yes | 0 No |
Usage of Stored Procedures in Cognos
1 Answers General Motors GM, TCS,
How can I disable the drill-down for the last level of my dimensional hierarchy ????
in u r data u having duplicates how to fetch the latest data in our report?
11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance
What are different events in Report studio?
im having null data in one of the cell in my report i have to display as "no data" when u run the report how can i achive this problem?
Can you define cognos powerplay?
what is symmetric key?where do u use this?
How to a create header dynamically in a crosstab report in cognos 8.1?
we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer
how u will determine the performence tune will occur either in report or system
Please answer me the below questions, It's really urgent, and ur help would be appreciated. 1. What is looping in FM? How do u control it 2. How do u create IQDs in FM? Explain 3. What are the diff u noticed between Cognos 8.2 and Cognos 8.4 4. Can we use cube as a data source? How 5. How do u connect ur database in FM? do u connect directly 6. What's the structure of your database? Say u use Oracle 7. Did you use tables or views to bring the data from your DB 8. Does the dimensions of analysis studio have hierarchy? 9. Did you create any dashboards? How u created, explain