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