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:
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:
Create a default package
Use Dynamic Query Mode
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
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:
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.
IBM Cognos Related Interview Questions
|Microstrategy Interview Questions||IBM Cognos Interview Questions|
|IBM DB2 Interview Questions||Data Warehousing Interview Questions|
|SQL Interview Questions||IBM Cloud Computing Infrastructure Architect V1 Interview Questions|
|Framework7 Interview Questions||IBM BPM Interview Questions|
|IBM Cognos TM1 Interview Questions||Cognos ReportNet (CRN) Interview Questions|
|Structured Query Report (SQR) Interview Questions||IBM DataPower Interview Questions|
Ibm Cognos Tutorial
Introduction To Ibm Cognos Business Intelligence
Overview Of The Ibm Cognos Business Intelligence Architecture
Business Scenario And Personas Used In This
Create Reporting Packages With Ibm Cognos Framework Manager
Business Intelligence Simplified: An Overview
Individual And Collaborative User Experience
Self Service Interface For Business Users
Actionable Analytics Everywhere
Enterprise Ready Performance And Scalability
Ibm Cognos System Administration
Integrating Ibm Cognos Bi With Ibm Cognos Business Analytics Solutions
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.