Configuring Dynamic Query Mode - IBM Cognos

For a package to use Dynamic Query Mode, you need to make configuration changes. As with Compatible Query Mode, prior to a data source connection and before a package can be created, you need to install the appropriate database client software.

Creating a connection in IBM Cognos Administration

The first step in enabling Dynamic Query Mode connectivity, after installing the database client software, is to create a data source connection to the OLAP database. The connection can be used later when creating the IBM Cognos Framework Manager model and package.

For the purpose of this example, we use the Great Outdoors sample database, IBM Cognos TM1, that comes with the IBM Cognos Business Intelligence (BI) version 10 samples package.

To create a connection:

  1. Open IBM Cognos Administration by clicking Launch IBM Cognos Administration.
  2. Launch IBM Cognos Administration

    Launch IBM Cognos Administration

  3. Click the Configuration tab.
  4. In the Data Source Connections section, click New Data Source.
  5. Specify the data source name, and click Next. Optionally, you can also specify a description and tooltip for this entry.
  6. Choose IBM Cognos TM1 as the as data source type, and click Next.
  7. Specify the IBM Cognos TM1 connection string details, such as Administration host and server name, and complete the required credentials. Click Test the connection to verify the current configuration. Note that the result page now shows a successful state for both Compatible Query Mode and Dynamic Query Mode,
  8. Connection test
    Connection test

  9. Return to the page where you entered the connection string details, and click Finish to end the wizard.

Creating a package in IBM Cognos Framework Manager

After you create the connection to the OLAP database server, you can create an IBM Cognos Framework Manager model and import cubes to publish to IBM Cognos Connection as a package,

Using multiple data sources: With IBM Cognos Framework Manager, you can include and mix multiple data sources in a package. However, when using Dynamic Query Mode, all data sources that are referenced in the package must be supported by the query mode. Otherwise, the publish will not succeed.

Creating an IBM Cognos Framework Manager project and package to use with Dynamic Query Mode is similar to creating those for Compatible Query Mode. At the end of the publishing wizard, you need to specify to use Dynamic Query Mode. To create a new project and publish the default package using the Dynamic Query Mode, follow these steps:

  1. Open IBM Cognos Framework Manager, and click the Create a new project link.
  2. Give the project a name, and click OK.
  3. IBM Cognos Framework Manager presents a list of supported metadata sources from which you can choose. Choose Data Sources, and click Next
  4. Metadata source
    Metadata source

  5. Choose the data source that you created in, “Creating a connection in IBM Cognos Administration” and click Next.
  6. Choose the plan_Report cube, and click Next to continue.
  7. Continue until you reach the Metadata Wizard - Finish window, At this point, IBM Cognos Framework Manager has detected that no additional modeling is required and suggests that a package is created for publishing. Verify that the “Create default a package” option is selected, and click Finish.
  8. Create a default package
    Create a default package

  9. Give the package a name, and click Yes on the subsequent prompt to launch the package Publish wizard.
  10. Click Next until you reach the Options page of the Publish wizard. Then, select the “Use Dynamic Query Mode” option, and click Publish
  11. Use Dynamic Query Mode
    Use Dynamic Query Mode

  12. If the package is published, the final window of the publishing wizard displays. Click Finish.
  13. After the package is published and available in IBM Cognos Connection, click the package’s properties icon to verify that the query mode is in use
  14. Package properties
    Package properties

Transitioning to Dynamic Query Mode using

IBM Cognos Lifecycle Manager

IBM Cognos Lifecycle Manager assists you and enables you to be successful in the critical process of verifying upgrades from IBM Cognos ReportNet, previous versions of IBM Cognos 8, or IBM Cognos BI version 10 to IBM Cognos BI version 10. It provides a proven practice upgrade process where you execute and compare report results from two different IBM Cognos releases to let you identify upgrade issues quickly.

With the introduction of Dynamic Query Mode, IBM Cognos Lifecycle Manager also provides the possibility to verify and compare reports using this query mode.

If you take these two features into consideration, IBM Cognos Lifecycle Manager is also a great tool to identify any issues with the transition of your current IBM Cognos version 10 packages and reports, based on Compatible Query Mode, onto Dynamic Query Mode. An additional advantage to this approach is that you are not affecting any packages and reports that users currently access.

You can enable IBM Cognos Lifecycle Manager the Dynamic Query Mode on either a global project level or on a individual package basis.

To enable the use of the Dynamic Query Mode on all packages in an IBM Cognos Lifecycle Manager project, click Settings Configure, and navigate to the Preferences

IBM Cognos Lifecycle Manager project settings

IBM Cognos Lifecycle Manager project settings

In the Dynamic Query Mode Options section, notice two drop-down lists where you can enable Dynamic Query Mode, one for the source environment and one for the target environment. You can now choose one of the following options:

  • The Default option instructs IBM Cognos Lifecycle Manager to validate or execute reports and packages using the query mode that is specified on the individual package.
  • The DQM Disabled option instructs IBM Cognos Lifecycle Manager to validate or execute all reports and packages in this project using Compatible Query Mode.
  • The DQM Enabled option instructs IBM Cognos Lifecycle Manager to validate or execute all reports and packages in this project using Dynamic Query Mode.If you select the Default option, you can specify the query mode on the package views individually,
  • Specify query mode
    Specify query mode

In the Options column, the DQM in bold means that Dynamic Query Mode engine is enabled on this package. Double-clicking DQM disables the use of the new query mode and the DQM is no longer bold.

Testing note: Attempt testing against Dynamic Query Mode only if all data sources that are included in the package are supported by this query mode. Validating and executing packages that contain unsupported data sources will fail.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

IBM Cognos Topics