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 |
what is field set? what is the query calculation and layout calculation?
if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me
what is textsource variable
how you provide security to reports? How you provide security to packages ?
what is fact less fact give me proper example?
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?
How many types of models are present in cognos.?
2. What is With Clause In Cognos?
fiscal year means what???
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 ?
what is mean by cognos powerhouse?
what is #prompt and #promptmany, runningtotal in report studio