Answer / amar

Scope relation ship, between regular dimension and measure
dimension.

Answer / chiru

After completing ur DMR Models, u will get Dimensions Tables i n Dimesnsion Tab and Measure Tables at Measure Tab on..If u want to check whether is relation between Dimension Table and Measure Table, just click on Measure Table, then an yellow colour display on dimension table, it implies relation is there between both tables.. . On right Corner in framework Manager there is scope icon.. by using scope icon we can set the hireriachy levels in relation between Both tables.


For example In Dimesion Table we have Region---Country--- city
By using scope we can set the relation uption Country Level only..............

what is an sid (surrogate key)?

4 Answers   IBM,

---

we have a list of 80,000 records, i would like to display in excel sheet but excel sheet has capacity of 60000 record.. how you going to display?

2 Answers   Accenture,

---

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  

---

How to crate cubes in transformer ?

3 Answers  

---

I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?

6 Answers  

---

what is degenerate key in oracle ?whare do we use it?

0 Answers  

---

Where in report Studio's property pane can I find NoDataHandler?

1 Answers  

---

Can any one tell me cognos training class in chennai? thanks in advance...

5 Answers  

---

3. What was the size of your cube?

1 Answers   IBM,

---

example for generated prompt

1 Answers  

---

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this

2 Answers  

---

What are all the different types of prompt in cognos?

0 Answers  

---