Determinants in Framework Manager

[sameena]

Hi All,
     Would you please explain what are Determinants? What is their use and when are they used??

Thanks in Advance,
Sam

[blom0344]

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

[dssd]

IBM FM manual has a good section on it

[Grim]

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

[cschnu]

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".

[Arsenal]

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

[sameena]

Thanks all..that was helpfull :)...