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 Table of contents?

0 Answers   Cap Gemini,

---

diff b/w dimension and regular dimension

1 Answers  

---

what are the types of facts ? explain them?

2 Answers   Business Objects, Informatica, Syntel, Teradata,

---

How u provide security to reports in report studio or in cognos connection?

1 Answers   Cap Gemini,

---

Explain the different types of views used in cognos.

0 Answers  

---

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

0 Answers   Accenture,

---

What are all the types of report?

0 Answers  

---

Name the types of gateway?

0 Answers  

---

2. What functional area you worked on.

0 Answers   IBM,

---

Why Star Schema is de-normalized? Please explain in detail probably with some examples.

2 Answers   DELL,

---

Which one is better among Value and select & search prompts,in terms of performance?

2 Answers   L&T,

---

Name the types of report?

0 Answers  

---