Known Limitations in Version 12.6
For Designer 12.6, the following features are not available with Query on Demand (QoD):
Qod does not support joining of data sources. Joining is however supported in combination with the intelligent cache when disabling QoD.
User defined ranking columns are not supported with combination with QoD.
When using calculated columns in combination with QoD, only the Calculation aggregate type is supported.
Parameterized queries are supported with QoD. However, parameterization is not supported when using the intelligent cache.