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


Please Help Members By Posting Answers For Below Questions

------------- How to identify the Revenue Column in Report?

1816


What is difference between informatica power mart and power center?

562


how you provide security to reports? How you provide security to packages ?

627


I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?

1680


Can you explain a cognos controller?

597






Which studio is used to create reports?

603


Can you define metrics designer?

600


What is the complex report you faced in real time?

1728


What are the types of folder present in cognos?

632


how to connect datamarts

2370


What are the types of studio present in Cognos?

613


How security is concerned with Reportnet? Explain its implementing steps.

1609


what is hints in cognos and where we use it.

1986


Can you define report item?

586


Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

1626