Interested to Buy Any Domain ? << Click Here >> for more details...
What is Regular Dimension and Measure Dimensions and Diff
b/w them ?
- 2 Answers
- 20595 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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..
how will optimiz the performance of sql in FM ?
What is the use of cognos decision stream?
Can i apply drill through on master detail relationship report?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
What is a business view? and what is the difference b/w business view and folder?in cognos report life cycle when it will be involved ?
how to convert crosstab into list?
------------------What is Focalpoint?
Explain the difference between native sql and cognos sql?
how many types of variables in cognos report net and cognos 8
what is exact catalog size?
How the Bursting happens in same report and how to Print the bursting Report?
Teradata 
