C2090-623 Exam Dumps : IBM Cognos Analytics Administrator V1

Explanaton:

Compatible query mode

To run reports that use the compatible query mode, you must use 32-bit data source client libraries and configure the report server to be 32-bit. The compatible query mode uses native client and ODBC connections to communicate with data sources.

If the data source is 64-bit, ensure that you use the 32-bit client libraries to connect to the data source to use the compatibility query mode.

Problem(Abstract): Datasource connections not listed in Data server by default

Symptom: We can see the datasource in the Admin console but not in the list of data servers.

Cause: This is default behavior.

Resolving the problem

Go to the Administrative Console -> Configuration -> Set properties -> Connections tab.

On the bottom, you will see "Data source capabilities"

Inside that, check the box which says "Allow web-based modeling"

Once you check this, the datasource would be present as data server.

References:

OLAP style queries, like those against SAP BW, Oracle Essbase and IBM Cubing Services type data sources, will go to the OLAP query planner.

References: The IBM Cognos 10 Dynamic Query Cookbook (2010), page 7