Wt is the Diff between Business Key & member caption?
Answer Posted / 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 |
Post New Answer View All Answers
What do you understand by the term 'aggregate advisor?'
what is degenerate key in oracle ?whare do we use it?
What is drill down and slicing and dicing whats the difference between them?
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
explain how to create powerplay reports?
What is zero-foot print?
Define the slice and dice?
What is the size of database for you project?
How to test a cube?
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
what are the errors faced while bursting the reports and how to solve those errors?
What is the advantage of using shortcuts?
hi friends pls forward impropmtu interview question
2. What functional area you worked on.
----------------Describe DWH Architecture?