Hi All,
Would you please explain what are Determinants? What is their use and when are they used??
Thanks in Advance,
Sam
There are numerous discussions on cognoise about determinants, so a search will yield a wealth of information.
The very short answer would be that determinants control the behavior of the query generation in case of multi-fact/multigrain scenarios
IBM FM manual has a good section on it
What is a Determinant?
http://www-01.ibm.com/support/docview.wss?uid=swg21339768
FM Guide: Determinants
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_fm.8.4.0.doc/ug_fm_id4674specify_determinants.html
For aggregation purposes should each query subject have a determinant that uniquely identifies the data aka the primary key? This determinate would have a check mark on both uniquely identifies and group by. Then the data should aggregate correctly for all columns that need to be aggregated? Of course this would only be when defined in the documentation under "When to Use Determinants".
Quote from: cognos_guy_ on 19 Mar 2012 01:58:30 PM
For aggregation purposes should each query subject have a determinant that uniquely identifies the data aka the primary key? This determinate would have a check mark on both uniquely identifies and group by. Then the data should aggregate correctly for all columns that need to be aggregated? Of course this would only be when defined in the documentation under "When to Use Determinants".
In the dimension query subject, you would uniquely identify the column which is at the lowest level of granularity (based on the fact table). This would be the only uniquely identified column in that query subject. The other query items would be set to "group by" because they do not uniquely identify the rows in the fact.
in other words, all query items, other than lowest level granularity, will be group by while lowest level granularity would be uniquely identified
Thanks all..that was helpfull :)...