If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

DQM over TM1 Cubes

Started by jv_oz, 28 Feb 2017 07:38:36 PM

Previous topic - Next topic

jv_oz

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

MFGF

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.
Meep!