What is Regular Dimension and Measure Dimensions and Diff
b/w them ?

Answers were Sorted based on User's Feedback



What is Regular Dimension and Measure Dimensions and Diff b/w them ?..

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.

Is This Answer Correct ?    19 Yes 2 No

What is Regular Dimension and Measure Dimensions and Diff b/w 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.

Is This Answer Correct ?    6 Yes 2 No

Post New Answer

More Cognos Interview Questions

what are the joins present in reportnet?which is most widely used?

2 Answers   IBM, Satyam,


Cleared COG-112 with 100% score today. What next certification should i go for?

0 Answers   IBM,


how u will design the report if the objects are available

0 Answers   Ness Technologies,


write a query to display the third record from the employee table?

6 Answers   HCL,


These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab to List? 2.How do you approach and who tells you what exactly the way report has to be developed so that i meets the client requirements? 3.Can we link the List and Chart thats created in the same report? 4.Where do you edit sql in cognos8 ? 5.What is the difference between native sql and oracle sql? 6.What is the difference between MOLAP and ROLAP? 7.What is the use of BI in datwarehousing? 8.What are set functions? 9.How do you test a report? 10.What are the variables you find in toolbox? 11.How many types of filters are there in cognos8? All the answers r welcomed .U can reach me at vinod.davala@gmail.com

4 Answers   IBM,






I have 3 dataitems in a list username,transaction type,transaction amount. In transaction type i have 3 types 'add','update','delete', i have almost 750 rows. After displaying the list report i want to know no. of add's,update's,delete's in 3 different rows

2 Answers  


can we put more measure on cross tab? If so how many? How this affect the aggregation?

4 Answers  


If you need latest cognos certification dumps to get certified in first attempt with 100% score, please e-mail to getmecert@yahoo.com

4 Answers  


How do add dynamic titles in PP?

3 Answers  


Anybody sugest me either url address or website for cirtification in Cognos from cognos.com !

3 Answers  


please tell me architecture of the cognos8?

4 Answers   IBM, TCS,


What are the different type of securities can we apply in framework manager?

1 Answers  


Categories