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