Answer Posted / palzkumar

Dimension Table is a table which contains categories and
hierarchies with lowest granule.
Data stored in dimension are nothing but the masters.
Its doesn't store any numeric value or summerised data.

eg.
Product dimension
Customer dimension
Channel dimension
Time dimension
etc..

Time dimension will have the foll records..
Year > Quarter > Month > Week > Day
-------------------------------------
2009 > Qtr-02 > Aug > 35 > 04-sep-08
2009 > Qtr-02 > Aug > 35 > 05-sep-08
2009 > Qtr-02 > Aug > 35 > 06-sep-08

rgds
palz

What are all the types of indexes in Cognos?

1174

---

How to select multiple values from type-in prompt?

1025

---

---------------Describe OLAP Reporting and RDBMS Reporting?

2066

---

What is meant by Reportstudio shortcut?

2139

---

Diff b/w Crossproduct and Outerjoin?

2242

---

where you can save the report net documentation in our local system?

1021

---

What are the types of studio?

1114

---

Define query items?

977

---

What are the advantages of cognos?

934

---

What is meant by alternate drill down with ex?

1049

---

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

---

Can you explain a cognos controller?

985

---

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

2262

---

How to publish a package by running Java Script?

2047

---

What are various types of gateways in cognos?

996

---