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 you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

0 Answers   IBM,

---

Wt is the Diff between Business Key & member caption?

2 Answers  

---

Can you define materialized view?

0 Answers  

---

how to create cubes in transformer ?

0 Answers   IBM,

---

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

0 Answers  

---

---

When we deploy the report to live the client get the data error how can we resolve that

1 Answers   CTS,

---

Can you define snapshot?

0 Answers  

---

what is #prompt and #promptmany, runningtotal in report studio

1 Answers  

---

how to handle multifact?

2 Answers   IBM,

---

What is value prompt limitations while creating report? What is select and search prompt?

1 Answers  

---

3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

0 Answers  

---

dumps needed ASAP for - C2020-180 Cognos IBM Certification

0 Answers   Aptech,

---