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.

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.

if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?

2 Answers   CTS,

---

in which scenario we go for views in cognos or oracle?

1 Answers  

---

Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!

5 Answers   HCL, Wipro,

---

Why do we create shortcuts in framework manager

4 Answers  

---

What is the difference between macros and prompt?

2 Answers   IBM,

---

drillthrough vs master detaild report,which one is the best by performance?

3 Answers   IBM,

---

What are initial page components of Cognos connection?

0 Answers  

---

what is crosstab space

1 Answers   IBM,

---

what are burst options you have?

2 Answers   HCL, IBM, TCS,

---

What is Online View?

0 Answers   IBM,

---

hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

0 Answers   TCS,

---

What is difference between drill through and drill down?

3 Answers  

---