Answer / amp mohan

Surragate Key: It is a system generated Key and used to
eliminate the redundancy in the primary key.Its act as a
Primary key.so there are always integers.

Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

0 Answers  

---

8. Can you use calculations in report headers and footers? How?

1 Answers  

---

What is difference between page break and section report? What is main advantage datawarehousing over oracle?

0 Answers  

---

What is model?

0 Answers  

---

5. Which type of report you build more, list, crosstab or chart and why?

0 Answers   IBM,

---

---

If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.

4 Answers   IBM,

---

can reportnet supports cubes???

4 Answers   IBM, Wipro,

---

My report output is showing data as 1 11 111 2 22 222 3 33 333 How can I sort this to 1 2 3 11 22 33 111 222 333

1 Answers  

---

What are the components of the report studio?

0 Answers  

---

what is reprompt?

3 Answers   TCS,

---

Can you define set to be cardinality?

0 Answers  

---

2. What is With Clause In Cognos?

2 Answers   Wipro,

---