Answer Posted / sajj

Let us understand the determinants in simplest terms.

Company CEO Empl
-----------------------------------------------------
Ennov Vijay Vishwas
Ennov Vijay Mritunjay
Ennov Vijay Farrukh


Company Revenue
---------------------------------------
Ennov 500000
Carrot 400000

When above 2 tables are joined on Company field and you
bring following items in the query Company,CEO, Revenue. The
the following will be the output

Company CEO Revenue
-------------------------------------------------
Ennov Vijay 500000
Ennov Vijay 500000
Ennov Vijay 500000

You got three rows because Ennova had three employees, here
cognos was not able to understand that granulirity of both
these tables was different. You have to defined it
explicitely and end product of this is called DETERMINANTS.

Here in the first table you have to define 2 determinants
CEO and Company and and check the check box of group by. Now
when you run the query in cognos you will find that
repeation is not there.

What do you understand by ‘ibm predictive maintenance and quality’?

990

---

write a query to display the departments with no employee?

1968

---

Can you define transformer?

948

---

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

1987

---

What are the advantages of cognos?

975

---

What do you mean by drill across?

1144

---

9. What was the most complex type of report you dealt with?

2204

---

Write types of folders present in cognos?

1069

---

What do you understand by user class in cognos?

950

---

how to explain health care project and which reports we can create in health care doain?

6799

---

what is model and say about process how to create model and how to test model?

1057

---

Diff b/w Crossproduct and Outerjoin?

2277

---

-----------With out using DrillThrough how to do Reports?

2043

---

What are the themes in a data warehouse?

1033

---

What do you mean by query studio?

940

---