Cognos Dynamic Query Mode

[raj.kanag.s]

Guys,
        We have Teradata as our DB Server.

When I try to publish a package, I was getting an error :

            "QFS-ERR-0141 This report service is configured as 64-bit and only supports packages published with the dynamic query mode"


Is there any harm if I check the "Dynamic Query Mode" before I publish the package?

My understanding is the DQM is applicable only for Netezza and other Essbase sources but not for relational databases.

Thanks,
Raj

[siyad]

I would suggest to create a data source to the Teradata database with the DMR option activated and make sure that the connection works. You need a type 4 JDBC driver for the DMR when you use relational model and the following link helps you to configure and test this

http://www.ibm.com/developerworks/data/library/cognos/infrastructure/cognos_specific/page529.html?ca=drs-

Best of luck

[MFGF]

My understanding is the DQM is applicable only for Netezza and other Essbase sources but not for relational databases.

Hi Raj,

Not true. DQM is available against a number of relational data sources, including Teradata. See the conformance page here:

http://www-01.ibm.com/support/docview.wss?uid=swg27027080#dqm

You have two choices - either publish your package with DQM enabled (after making sure you have the relevant jdbc files), or switch your Report Service to 32-bit mode.

Cheers!

MF.

[tjohnson3050]

I would just add to check your Cognos Version

DQM Relational support grew from 10.1 to 10.1.1

10.1 only supported Netezza for DQM relational Sources:
http://www-01.ibm.com/support/docview.wss?uid=swg27019126

10.1.1 Introduced support for Oracle, SQL Server, DB2 and Terradata as DQM Relational Data Sources:
http://www-01.ibm.com/support/docview.wss?uid=swg27021368

[cognostechie]

Raj -

Be careful. DQM is not fully fixed yet. Last time I used it on 10.1.1 in Jan 2013 against Netezza DB, lot of cognos functions falied to work, especially the ones related to Date Dimension. I had to publish the package without DQM and then it worked.

DQM definately works when your model is very simple and you push all the logic to the database, which is what lot of modelers do.

[bdbits]

Maybe this varies with your database/source. We have published our first full DQM package on 10.1.1 going against a SQL Server 2008 R2 database. It is undergoing user testing now. It's not yet overly complex as it is this department's initial warehouse - more to come - but as far as I know, so far we have not had more than a handful of issues traceable to DQM.

We'll be migrating to 10.2 in a few months, so hopefully if there are bugs we just have not seen yet, 10.2 will knock them dead before they have a chance to creep in. :)

[MFGF]

I have seen a couple of "odd" things with DQM against TM1 sources, but so far nothing unduly worrying going against SQL Server. Like you, I'd hope that IBM will have mopped up most of the issues in 10.2 or 10.2.1

Cheers!

MF.

[cognostechie]

Different people have different experiences because everybody's models are not the same. Like I said, it works fine if you don't have lot of cognos functions in the model. Try using _add_days, _add_months, day_of_week etc and then it fails, otherwise it works.