What are the steps to create DMR model in FM? Give me
brienf discription as interview point of you?



What are the steps to create DMR model in FM? Give me brienf discription as interview point of you..

Answer / 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

More Cognos Interview Questions

what is field set? what is the query calculation and layout calculation?

2 Answers   Syntel,


if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me

2 Answers   WNS,


what is textsource variable

2 Answers   HCL,


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

0 Answers   IBM,


what is fact less fact give me proper example?

2 Answers  






Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? Please explain with examples? Q3. Suppose we have a table which is holding a large number of records. There are 4 columns which are very frequently used in the Cognos reports, so can we create indexing on those 4 columns?

2 Answers   Mphasis,


How many types of models are present in cognos.?

4 Answers  


2. What is With Clause In Cognos?

2 Answers   Wipro,


fiscal year means what???

8 Answers   iFlex, iGate,


i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

0 Answers  


what is mean by cognos powerhouse?

1 Answers   TCS,


what is #prompt and #promptmany, runningtotal in report studio

1 Answers  


Categories