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....

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

........

Answer / narayana

avoid loops:using shortcuts.
we have ambiguous relationships types:
hierarchical relationships,recursive relationships,multi-
valid relationships.to avoid these relationships using
shortcuts.

Answer / palzkumar

Both are right...

What is cognos connection?

0 Answers  

---

what is the difference b/w mdx and sql?

4 Answers   Cap Gemini, IBM,

---

How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?

4 Answers  

---

Where do you edit cognos sql in report studio?

3 Answers   HCL,

---

Why do we create shortcuts in framework manager

4 Answers  

---

4. How many dimensions did you use in your reports?

0 Answers   IBM,

---

Explain about Parametermap?

1 Answers  

---

What is Dynamic Grouping? what is diff between grouping n levelspan?

2 Answers   CybAge,

---

how to create relationship between emp and salgrade tables in frameworkmanager?

1 Answers   TCS,

---

Part 1 : Cognos 1.What are the technologies that are used in cognos? 2.What are complex reports? 3.What is page break? 4.What is layout component? 5.How do you use extract function? 6.What is the use of Crosstab space? 7.What is Rank()? 8.What is the use of Query calculation and layout calculation? 9.What is Slicer and Dicer? 10.How can you create users in Cognos? 11.What is last child member? 12.What is the use of Conditional blocks? 13.What is Conditional Formatting? 14.What is group span? 15.In which types of reports does the page breaks applicable? Is it applicable in excel reports? 16.I want to show a up arrow and down arrow image in cross tab report, if the revenue is > 5000 (up arrow) and if <5000 (down arrow)? How will you achieve this? 17.What are types of Filters in RS? What is Summary Filter and Detail Filter? 18.What is Cast Function? 19.How will you create prompts for the example like this : In a single report I want a) List report (Need a prompt for this) b) Crosstab report (Need a separate prompt for this) c) Chart ()(Need a separate prompt for this) Part II : Framework Manager (FM) 1. What is Determinant in FM? 2. What is Cardinality? 3. What are the types of filters used in FM? 4. Can we create cubes with Relational Data sources? 5. What is Aliasing and Shortcut? 6. What is Session Parameter & Parameter Maps? 7. How many types of securities that we have in FM? 8. What is Data Security in FM? Part III : Data warehousing 1.What are various types of Schemas? 2.What is Star Schema and Snow Flow Schema? Difference between both? 3.What is surrogate key? Part IV : Databases 1.What are NVL Functions? 2.What is left outer join? Give an Example? 3.Can we straightaway use the tables that we have in the database instead of creating the package’s FM and making use of them, through Report Studio (RS)?

2 Answers   Satyam,

---

what is the difference between enterprise data warehouse and data warehouse

4 Answers  

---

how u burst the reports? if u r bursted reports is not reached to destination how u identify???

2 Answers   Infosys, Wipro,

---