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
---------------Tell me about DWH Concepts?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
What is set to be cardinality?
What is the model filter?
how to merge 2 crosstabs thans
What errors and types of errors you faced in Cognos ReportNet?
Define query studio?
Give the advantages of cognos?
What is defined as data mining?
what is catalog and types of catalogs in cagnos and which is better?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
Give me any example of semi and non additive measures?
hi my name is siraj i want to know cognos queriy language
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?