Troubleshooting
Problem
Dynamic Query has detected that a query references multiple facts, and is attempting to filter data from a fact without projecting data from it.
This results in the error
XQE-PLN-0084 SQL cannot be generated, because the filter condition could not be applied to the following fact stream which does not contain a fact projection
XQE-PLN-0084 SQL cannot be generated, because the filter condition could not be applied to the following fact stream which does not contain a fact projection
Diagnosing The Problem
In the following example
- D1, D2 and SD represent dimensions
- F1 and F2 represent facts
- F1 is related to D1 and SD
- F2 is related to D2 and SD
A query projects data from F1, SD while specifying a filter on D2. Note that D2 is not directly related to F1 and there is no data is requested from F2.
Dynamic Query will not allow this condition, which results in the error condition. Applications using Compatible Query would not have received an errors, when multiple join paths involving fact tables were resolved using the name which sorted first alphabetically.
To avoid the error:
- remove the filter should it not be required
- within Report Studio, edit the layout object to include a reference to the fact table via Data->Properties
Document Location
Worldwide
[{"Type":"none","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl5uAAC","label":"Reporting->Dynamic Query Mode and XQE"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
Was this topic helpful?
Document Information
Modified date:
14 April 2021
UID
ibm16443367