Answer Posted / abd hfz

Rank is a function which arrange the data in ascending order
by giving no to them similar to s.no. but skips no for the
same data.
e.g.
Name Revenue
abc 1000
pqr 2000
mno 2000
xyz 3000

If we have Rank(Revenue) then O/P will be,

Rank(Rev) Name Revenue
1 abc 1000
2 pqr 2000
2 mno 2000
4 xyz 3000

what is online view?

1901

---

-----------------What is Direct and Conventional loading?

2137

---

What is a Pivot?

1075

---

What is Additive function?

1994

---

Can you define confirmed dimension?

1035

---

Can you explain model durability?

1020

---

what is degenerate key in oracle ?whare do we use it?

2527

---

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 ?

2154

---

Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

2015

---

How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

3267

---

What is the difference between regular dimension and derminant?

2218

---

please please give me some banking calculations in framework manager.

2048

---

Can you explain cognos planning?

1058

---

What do you mean by query studio?

904

---

Can you define framework manager?

988

---