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

Explain how data modeling is useful to cognos in daily life?

2 Answers  

---

Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!

5 Answers   DELL,

---

wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container

0 Answers  

---

What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?

1 Answers   IBM,

---

How to do Performence Tunning in Cognos Reports?

0 Answers  

---

What is cognos reporting tool?

0 Answers  

---

----------------Describe DWH Architecture?

0 Answers   Bank Of America,

---

why we r using report studio in webbased only and fm windows based only

1 Answers  

---

When we save a report in report studio with what extn it save?

0 Answers  

---

---------------How to identify First Record and Last Record?

2 Answers  

---

Hi Friends, What is the Max no.of rows in a report & a page? If we have Master, Detail Reports, I have define drill through, Requirement is When i run Master Report it should run in HTML, when i drill through to detailed report it should get into PDF is it Possible in Cognos? Thank You Kumar

2 Answers  

---

Name the types of gateway?

0 Answers  

---