Wt is the Diff between Business Key & member caption?
Answers were Sorted based on User's Feedback
Answer / k naveen kumar
Business Key just act as a referential key when we are
navigating from one level of information to another level of
information
Member caption is used for display the output for the
different level of information.
| Is This Answer Correct ? | 14 Yes | 2 No |
Answer / kvbr
_businessKey
Represents the key for the level. The level can be defined as unique if the business key of the level is sufficient to identify each set of data for a level.
The _businessKey role can be assigned to only one attribute in a level.
The Root Business Key property shows the value of the business key for the root member. The root member is an artificial level created for dimensionally modeled relational models. To enable drill-through on conforming dimensions, you must set the Root Business Key property.
_memberCaption
Presents the caption for a member that will be shown in the IBM Cognos studios.
The _memberCaption role is necessary to leverage member functions and to enable dragging and dropping levels in the IBM Cognos studios.
Ensure that the data type is set to string for the item that will be assigned the _memberCaption role.
| Is This Answer Correct ? | 5 Yes | 1 No |
What is conditional Formatting?
what is stitched query???
what is materialised view? why we use it in data warehousing?
---------------Tell me about DWH Concepts?
Can i apply drill through on chart in report studio?
Guys... which difficult you faced in your projects that should be difficult to you not to others... any one can explain but should be clear steps... and with examples... how you handle that......?
what is filter?give me one example that you created a report in your project?
What is the difference between List and Cross tab? Could some on explain with an example..
actually we are migrating one project to ACTUATE business intelligence solution to COGNOS REPORTNEt? why the client want to migrate from ACTUATE to COGNOS REPORTNEt? what are the special features in COGNOS REPORTNEt?
what are slowly changing dimensions? Why we are used scd?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
i have a sales project interviewe asked tel me the how many facts&dimensions used in ur project.