Answer / bhaskar.nagi

A regular dimension contains descriptive and business key
information and organizes the information in a hierarchy,
from the highest level of granularity to the lowest. It
usually has multiple levels and each level requires a key
and a caption. If you do not have a single key for your
level, it is recommended that you create one in a
calculation. A measure dimension is a collection of facts.
You can create a measure dimension for one or more query
subjects that have a valid relationship between them.

Answer / abd hfz

Regular Dimensions
Regular dimensions represent descriptive data that provides
context for data modeled in measure dimensions. A regular
dimension is broken into groups of information called levels
which is organized into hierarchies. In turn, the various
levels can be. E.g. hierarchies of a product can be Prdt no,
Prdt name, Prdt line, Prdt description. Used in analysis
studio & in drill up & down methods.
Measure Dimensions
Measure dimensions represent the quantitative data described
by regular dimensions. Measure dimension is the object that
contains the fact data & Measure dimensions differ from fact
table because they do not include the foreign keys.

What is Star schema group?

1 Answers   IBM,

---

what is the difference between group span and level span

1 Answers   Satyam,

---

How do you test the reports? Explain the Unit testing procedures after developing the reports?

1 Answers   HP, TCS,

---

what is the difference between enterprise data warehouse and data warehouse

4 Answers  

---

Hi Friends, Just want to know, day to day is increasing or decreasing Cognos Usage in the Market? New Reporting tools to driving Reporting Market Spotfire, Tableau,Qlick View, some other New Tools. Which Reporting tool can generate Lot of Opportinities in the Market? Please Reply to this, My Advanced Thank to you. Thank You Kumar

2 Answers  

---

Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?

4 Answers   IBM, Wipro,

---

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

1 Answers   Facebook,

---

if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me

2 Answers   WNS,

---

what is the difference between rollup aggregation and aggregation ?

1 Answers  

---

can any body explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible.

8 Answers   Mind Tree,

---

Can any one give the example for slicing and dicing of data ?(with simple query)

3 Answers   Cognos,

---

How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

0 Answers  

---