If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Determinants in FM

Started by phoenixfire, 15 Oct 2007 06:18:47 PM

Previous topic - Next topic

phoenixfire

Hi ...
can someone explain what are determinants in Framework manager?
Do they affect the joins when the package is published to Report Studio?
Are they present in both cognos 8 and report net?
Thank u

praveennb

#1
next time please search this forum before posting

there are better examples than the once i have given below if u search this forum for Determinants.

determinants are new to cognos 8, they are mainly used to tell cognos on what level the fields should be grouped, and which
fileds are unique in a query, this in turn helps preventing double counts. also query performance will be increased.

yes they do effect the joins.

A simple example is a join from a Time dimension  to a fact table with
joins coming from the time dimension on day level, month level and year level.

here you will need to set the determinats
for
year level as grouped
month level as grouped
day level as unique key

hope this helps