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
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
How we check the errors before running the report?
What are the ways to import data into catalog?
What is the difference between set functions and filter function in dimensional data?
What are the main services provided by application tier?
What is the metric store database?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
What is Additive function?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
Define metrics studio?
how to explain health care project and which reports we can create in health care doain?
How can I schedule reports in cognos?
Can you define folder?
How do we drill through from a powerplay cube to reportnet?\
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks