Interested to Buy Any Domain ? << Click Here >> for more details...
where exactly determinants are used in cognos framework
manager?
- 4 Answers
- 26688 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
what is catalog and types of catalogs in cagnos and which is better?
how you provide security to reports? How you provide security to packages ?
What is drill down and slicing and dicing whats the difference between them?
What is set to be Cognos configuration?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
What is meant by Reportstudio shortcut?
Can we test the report other than manual testing?
Define dimensions?
---------------Tell me about DWH Concepts?
What is catalog and types of catalogs in cagonos and which is better?
What are the message flows?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
What is the use of powerhouse?
