Answer / 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..

What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?

5 Answers   IBM,

---

what is the difference between count and running-count functions?

1 Answers  

---

What are all the different types of prompt in cognos?

0 Answers  

---

----------------------Diff b/w MOLAP and ROLAP?

4 Answers   Bank Of America,

---

What is defined as catalog and types of catalogs in Cognos?

0 Answers  

---

---

how to solve many -many relations ship in frame work manager?and how to avoid cartigen product in frame work manager?

8 Answers   HSBC,

---

I have 3 dataitems in a list username,transaction type,transaction amount. In transaction type i have 3 types 'add','update','delete', i have almost 750 rows. After displaying the list report i want to know no. of add's,update's,delete's in 3 different rows

2 Answers  

---

what are the errors faced while bursting the reports and how to solve those errors?

0 Answers   EDS,

---

--------------what is MemberCaption?

1 Answers  

---

what is stitched query???

2 Answers   IBM,

---

What are the differences between Cognos 8 and Cognos 7.x version?

2 Answers  

---

What is a Query Subject?

0 Answers  

---