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 MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS
5 Answers IBM, Virtusa, Wipro,
what are versions of cognos from starting release to latest in the market?
What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
what is model and how to create model and how to test model?
How can I schedule reports in cognos?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith
2.How do you drill through report from Report Studio to Analysis studio?
What is Dynamic Grouping? what is diff between grouping n levelspan?
Can you define cognos decision stream?
What is the enterprise class platform architecture of cognos 8?