What are the steps to create DMR model in FM? Give me
brienf discription as interview point of you?
Answer Posted / d
hi,
DMR stands for (DIMENSIONALY MODELED RELATIONAL)DATA
To create a DMR model we need to create regular
dimensions,measure dimensions.
Regular dimensions:
These dimensions have hierarchies,levels,members.
While creating these regular dimension we should assign
1. member captions
2. business key
3.member descriptions
Business key are usually the code for that particular query
item.(say the quer item is a productline then its business
key would be productline code
and measaure dimesions are nothing but the measures
| Is This Answer Correct ? | 34 Yes | 0 No |
Post New Answer View All Answers
how to connect datamarts
How to deploy from one server to another server?
Can you define materialized view?
What are types of batch available in cognos?
Define olap designer?
What is difference between primary key and unique key constraints?
9. What was the most complex type of report you dealt with?
What are the types of studio present in Cognos?
What are the different kinds of panes included in cognos?
What is the size of the cube?
Can you define report item?
Define the slice and dice?
how to create cubes in transformer ?
Explain informatica architecture?
How to do Performence Tunning in Cognos Reports?