Hi everyone,
We are using Cognos BI and TM1 10.2.2 FP6.
I am looking for two peices of advice please re DQM and Report Studio reports over TM1 cubes:
- How do I tell if a report studio report built over a TM1 cube is using DQM?
- If they are CQM rather than DQM, how do I change reports built over TM1 to use DQM?
Thanks
jv_oz
Quote from: jv_oz on 28 Feb 2017 07:38:36 PM
Hi everyone,
We are using Cognos BI and TM1 10.2.2 FP6.
I am looking for two peices of advice please re DQM and Report Studio reports over TM1 cubes:
- How do I tell if a report studio report built over a TM1 cube is using DQM?
- If they are CQM rather than DQM, how do I change reports built over TM1 to use DQM?
Thanks
jv_oz
Hi,
The controlling factor over whether a report uses CQM or CQM is the package it belongs to. If you go into the properties of a report, you can see what package it is using at the bottom of the page on the General tab.
You can then go and find the package and go into its properties. On the General tab, you will see "Query Mode" towards the bottom of the page - this will either show Dynamic or Compatible.
If you want to change the mode from Compatible to Dynamic, re-publish the package from Framework Manager and check the box that says "Use Dynamic Query Mode" when publishing.
Cheers!
MF.