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 upgrade drivers in Cognos 8?
Can you explain the advantage of using shortcuts?
Define query studio?
Explain the characteristics of cognos?
how many facts&dimensions tables in a sales project?can any body name those dimensions and fact tables please
where you can save the report net documentation in our local system?
what is report view?
how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.
What is the importance of having monitor service in cognos?
is there any difference between operational database and data base?if yes what r they?
Why are meta service important then other services?
how u migrate the reports from impromptu to reportnet???