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 |
Create 12 columns for months by writing single case statement?
Can you define bitmap index?
Can you define a datastore in cognos?
Can you define pivot?
How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?
1.tyes of security in cognos?.how to use rank function? 2.what is content store? 3.what is content manager? 4.how 2 use rank function?
What is Render Variable? where u can use?
how many types of keys are there i.e primary key and foreign key etc..?
-------------Diff b/w Union and Unionall?
what is the use of macros&folders&herarchies in frameworkmanger?
Due Date (Highlight Issues in Blue where Due Dates are less than Todays Date),I have only Due Date column then how to over come the problem.How to find out which Due Date are less than Today Date...Kindly provide the detail steps to my mail ID-->asimcognos10@gmail.com
Can you explain cognos planning?