Interview Questions   Tutorials   Discussions   Programs   

Cognos - Where exactly determinants are used in cognos framework manager?

asked mar October 4, 2014 09:57 AM  

Where exactly determinants are used in cognos framework manager?


1 Answers

answered By vishnoiprem   0  

Determinants are a feature of Cognos 8 designed to provide control over granularity in a similar, but not identical means to Dimension Information in Cognos8. Determinants are most closely related to the concept of keys and indexes in the database. There is no concept of hierarchy in determinants, although the order in which they are specified does govern the order in which they are evaluated. A determinant can define the set of database columns (query items) that uniquely identify a set of data or it can identify a set of columns that identify a non-unique set within the data.

Let us understand the determinants in simplest terms.

Company CEO Empl
IBM sham Vishwas
IBM  sham Mritunjay
IBM sham Farrukh

Company Revenue
IBM  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
IBM  sham  500000
IBM  sham  500000
IBM  sham  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.

   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!