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

Started by KevinJacquier, 29 Aug 2019 09:46:11 AM

Previous topic - Next topic

KevinJacquier

I can not get determinants to work in Cognos  Framework Manager 11.1

I have set two determinants on a query subject. One is set as Unique and the Other is set as Group by.   When I test it,  the generated sql for the one set to group by does not do anything.  IN other words,  the query is not grouped before it joins to the associated Fact table.   In essense,  its no different than a similar query's sql that uses the unique determinate,  thus defeating the purpose.    Is anyone else using determinants in FM 11.1 and having issues?

MFGF

Quote from: KevinJacquier on 29 Aug 2019 09:46:11 AM
I can not get determinants to work in Cognos  Framework Manager 11.1

I have set two determinants on a query subject. One is set as Unique and the Other is set as Group by.   When I test it,  the generated sql for the one set to group by does not do anything.  IN other words,  the query is not grouped before it joins to the associated Fact table.   In essense,  its no different than a similar query's sql that uses the unique determinate,  thus defeating the purpose.    Is anyone else using determinants in FM 11.1 and having issues?

Hi,

Probably a silly question, but in what order are the determinants defined in the query subject? They are evaluated one at a time from the first to the last, so if your unique determinant is first, it will always be used (as a unique determinant applies to all attributes).

Sorry if this is something you already knew - but I mention it as it's something I have done in the past and learned from the hard way :)

MF.
Meep!