COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Framework Manager => Topic started by: KevinJacquier on 29 Aug 2019 09:46:11 AM

Title: Determinants not WOrking
Post by: 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?
Title: Re: Determinants not WOrking
Post by: MFGF on 29 Aug 2019 10:20:08 AM
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.