Author Topic: Determinants in Framework Manager  (Read 5108 times)

Offline Sam85

  • Full Member
  • ***
  • Join Date: Dec 2011
  • Posts: 22
  • Forum Citizenship: +0/-0
Determinants in Framework Manager
« on: 13 Mar 2012 01:39:39 am »
Hi All,
     Would you please explain what are Determinants? What is their use and when are they used??

Thanks in Advance,
Sam

Offline blom0344

  • Teamleader data processing
  • Global Moderator
  • Statesman
  • *****
  • Join Date: Feb 2007
  • Posts: 2,407
  • Forum Citizenship: +101/-2
  • have to let the first nerd go..
    • MRDM
Re: Determinants in Framework Manager
« Reply #1 on: 13 Mar 2012 02:23:35 am »
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
Oracle9i/11g,DB2/AS400/Busobj 6.5/Powercenter7/Cognos8/10 /
SSIS 2005 / SQL SERVER 2008 /SDDM 3.3   /   Pentaho 4.4.0 Data Integrator / SSAS 2008 / PostgreSQL 9

Offline asdf

  • Community Leader
  • *****
  • Join Date: Apr 2011
  • Posts: 158
  • Forum Citizenship: +1/-1
Re: Determinants in Framework Manager
« Reply #2 on: 15 Mar 2012 02:11:38 am »
IBM FM manual has a good section on it

Offline Grim

  • Honorary Master of IBM Links
  • Statesman
  • ******
  • Join Date: Nov 2011
  • Posts: 687
  • Forum Citizenship: +56/-7
"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)

Offline cognos_guy_

  • Community Leader
  • *****
  • Join Date: Mar 2009
  • Posts: 104
  • Forum Citizenship: +2/-0
Re: Determinants in Framework Manager
« Reply #4 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".
« Last Edit: 19 Mar 2012 02:30:05 pm by cognos_guy_ »

Offline Arsenal

  • Statesman
  • ******
  • Join Date: Feb 2007
  • Posts: 384
  • Forum Citizenship: +18/-1
Re: Determinants in Framework Manager
« Reply #5 on: 19 Mar 2012 02:44:14 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

Offline Sam85

  • Full Member
  • ***
  • Join Date: Dec 2011
  • Posts: 22
  • Forum Citizenship: +0/-0
Re: Determinants in Framework Manager
« Reply #6 on: 07 Oct 2012 06:58:30 am »
Thanks all..that was helpfull :)...

 



         
Twittear