What is Regular Dimension and Measure Dimensions and Diff
b/w them ?
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 to convert crosstab into list?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
What will happen if scheduling a report with a prompt page?
can we create master detail report where master and detailed container is separate?
What is catalog and types of catalogs in cagonos and which is better?
Which studio is used to create reports?
Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.
what are the types of scheduling and what are the errors faced while scheduling then how to solve those errors?
1 Answers Dr Reddys, TCS, Thomson Reuters,
Define the cognos reporting tool?
What is the difference between drill through, drill across?
What is cognos connection?
what is physical layer and presentation layer?