Interested to Buy Any Domain ? << Click Here >> for more details...
where exactly determinants are used in cognos framework
manager?
- 4 Answers
- 26903 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 difference between page break and section report? What is main advantage datawarehousing over oracle?
What is model filter?
WHAT ARE THE DISTNICT VARIABLES?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
Define datastores in cognos?
------------------What is Inline Query?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
what is the difference between list report and crosstab report?
What do you mean by Drill down and Drill Up?
What are all the components of Report Studio?
--------------Diff b/w ODS and OLAP?
how you provide security to reports? How you provide security to packages ?
How can create users and permissions in cognos?
What is the use of powerplay web viewer in cognos?
what are the special features in cognos reportnet?
