Answer Posted / hashmatulla baig

SELECT empno, sal
FROM
(
select empno, sal, ROW_number() OVER (order by sal desc) R
from emp
order by sal desc
)
WHERE R = 5;

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 ?

1679

---

Can you define framework manager?

616

---

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1489

---

What is the difference between Standard and Metrics folder?

567

---

How to apply securities for reports in cognos connection?

2110

---

---

What are the different types of reports present in cognos?

567

---

What are cognos connection initial page components?

595

---

WHAT ARE THE DISTNICT VARIABLES?

1741

---

----------------Describe DWH Architecture?

1643

---

What is the function of cognos dispatcher?

585

---

What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

704

---

what is hints in cognos and where we use it.

1984

---

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

1866

---

what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

1865

---

What are all types of Batches?

568

---