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

how can I test reports in cagnos?

0 Answers   IBM,

---

What is snapshot ?

4 Answers   IBM, TCS,

---

What are the advantages and disadvantages of using Transformer cube?

1 Answers   TCS,

---

Write some methods to apply securities in framework manager model?

0 Answers  

---

What are the different types of OLAP. Which one is Cognos Powercube?

2 Answers   HSBC,

---

Can you explain dynamic query mode?

0 Answers  

---

can anybody tell me when do use 'running total'...give an example for the usage of running total

2 Answers   EDS,

---

what is reprompt?

3 Answers   TCS,

---

10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list  Rank  Running-count

1 Answers   Data Semantics,

---

how can i provide security to my reports in report studio?

3 Answers   TCS,

---

How to find out OLTP data OLAP data ? i.e 5 years data is OLTP or OLAP. please anybody help me...

2 Answers   HCL, IBM,

---

What is main difference mapplets and mapping?

0 Answers  

---