Product:
Cognos BI 10.2.1
Windows 2008 R2 server
Oracle 11 database
Symptom:
When you try to change a Framework Manager model from Compatible Query Mode to Dynamic Query Mode you get a message:
Message:
BMT-IMP-0017 You cannot enable Dynamic Query Mode. The model contains data source(s) of unsupported type(s).
Possible Solution:
The data source inside the Framework Manager package does not have the properties for Schema or Interface set. This is needed in DQM.
Open the model in Framework Manager, and go to data sources.
In the properties tab check that you have the database schema at Schema line and expand the Type to check that the Interface is set (for example can be “OR”).