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 |
After installation of Cognos Reportnet how do i know how much of entire Cognos server is being utilised at any instatnt of time?
diff b/w grouping and aggregation
Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?
4. How many dimensions did you use in your reports?
Where do you set security levels for users in reports?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
8. Can you use calculations in report headers and footers? How?
What is conditional Formatting?
What do you understand by the cognos?
Why Star Schema is de-normalized? Please explain in detail probably with some examples.
How to do Performence Tunning in Cognos Reports?
what is reprompt?