Interested to Buy Any Domain ? << Click Here >> for more details...
where exactly determinants are used in cognos framework
manager?
- 4 Answers
- 26749 Views
- Satyam, I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
Can you define snapshot?
What is difference between content store and content manager?
what is log in cognos?
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?
whats the difference between previous version of cognos and cognos 8 BI?
What are the advantages of shortcuts?
Explain what is the main advantage of impromptu over cognos reportnet?
What is a Datastore in Cognos?
How the Bursting happens in same report and how to Print the bursting Report?
What are the components used in web tier?
What is the importance of having monitor service in cognos?
What are shortcuts? Where it can be used? What are the advantages?
What is a Framework manager?
What are the components of report net?
What are the types of studio present in Cognos?
