Answer Posted / amar
this comes under DMR ( Dimensional modeled relational ).
suppose we have REGION_ID and REGION_NAME.
While creating regular dimension level...
REGION_ID will treated as BUSINESS_KEY
AND
REGION_NAME will treated as MEMBER_CAPTION.
In the above regular dimension,
Using business_key ( REGION_ID ) we will display
member_caption ( REGION_NAME ).
Thanks.. I hope its use full..
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
------------- How to identify the Revenue Column in Report?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
hi friends pls forward impropmtu interview question
2. What functional area you worked on.
What are the components of the report studio?
What is called Cognos powerplay?
Can you define query studio?
What is model filter?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
What do you understand by ‘ibm predictive maintenance and quality’?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
9. What was the most complex type of report you dealt with?
Write some methods to apply securities in framework manager model?
what is power prompt in cognos ep7series?what is the use of this?