Pass the IBM Certified Administrator C2090-623 Questions and answers with ExamsMirror

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.

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

Specify if Configuration Objects and Children are Part of Deployment.

You can specify if configuration objects and their children are included as part of deployment. By default, they are not included.

You can change the default setting using the advanced setting CM.DEPLOYMENTINCLUDECONFIGURATION.

By default, it is set to False (do not include configuration objects in deployments).

To change the default to include configuration objects and their children, set it to True.

References: IBM Cognos Administration Version 10.1.0, Administration and Security Guide, page 384

Question

When testing a JDBC connection to Microsoft SQL Server 2005 / 2008 / 2012 you receive the error XQE-JDB-0004 A problem occurred finding the driver class "com.microsoft.sqlserver.jdbc.SQLServerDriver".

Cause

The JDBC connector is missing or not properly installed for Cognos

Answer

You may need to download the .JAR files from Microsoft download center site:

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en &id=11774

or search for "Microsoft JDBC Driver for SQL Server" via your favorite search engine.

Follow the Microsoft instructions to download and install.

References: http://www-01.ibm.com/support/docview.wss?uid=swg21623909

Enable Accessible Report Output Using System-wide Settings

Accessible reports contain features, such as alternate text, that allow users with disabilities to access report content using assistive technologies, such as screen readers. In IBM Cognos Administration, you can specify system-wide settings for accessible report output that apply to all entries, including reports, jobs, and scheduled entries.

Accessibility settings in the user preferences and report properties can overwrite the system-wide settings in IBM Cognos Administration.

Steps

Start IBM Cognos Connection.

In the upper-right corner, click Launch, IBM Cognos Administration.

On the Configuration tab, click Dispatchers and Services.

From the toolbar in the upper-right corner of the page, click the set properties button .

Click the Settings tab.

Under Category, click Administrator Override.

For the Administrator Override category, next to Accessibility support for reports, in the Value column, click Edit.

In the Accessibility support for reports page, select one of the following options:

References: IBM Cognos Administration Version 10.1.0, Administration and Security Guide, page 189

The method for performing a UDA trace is different in Cognos 10 to previous versions due to the removal of the Cognos Logging Console Program. This is specific to CQM datasources.

Please follow these steps:

Navigate to /configuration

Rename ipfUDAclientconfig.xml.sample it to ipfclientconfig.xml

Wait 30 seconds

Now run any reports that you wish to use the trace on.

After running the reports the trace will generate a file named "UDA_Trace.log" within /logs. The log name and location can be changed by the user by editing the ipfclientconfig.xml file.

Rename ipfclientconfig.xml to ipfUDAclientconfig.xml.sample to turn off the tracing.

This trace records all database activity so should be turned off as soon as the possible.

References: http://www-01.ibm.com/support/docview.wss?uid=swg21620597

The Content Manager service:

Performs object manipulation functions in the content store, such as add, query, update, delete, move, and copy

Performs content store management functions, such as import and export

To make printers available to users when they distribute reports, you can create entries for printers and save them in the IBM Cognos content store.

In IBM Cognos Analytics, when numerous schedules are added or updated, the content store database can lock if the schedules contain invalid data. If you experience this problem, you can set an advanced property that validates schedule properties and disables invalid schedules.

If the emf.schedule.validation.enabled property is set to true, schedule properties such as start date, end date, data types, and user account credentials are validated. Invalid schedules that are encountered are disabled, and details of the disabled schedules are logged in the log files.

The default for this property is false. To enable schedule validation, set the property to true.

References: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cra.doc/t_ug_cra _validate_schedule_props_adding.html

You set access to the secured functions and features by granting execute permissions for them to specified namespaces, users, groups, or roles.

The default conflict resolution rule for deploying the entire content store is replace.

Exceptions to the default conflict resolution rule are listed in the following table:

Object name: SESSION, CACHEOUTPUT, REPORTCACHE, REPORTMETADATACACHE, DEPLOYMENTDETAIL

Conflict Resolution Rule: Keep

References: https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_c ra.10.2.2.doc/c_ruleswhendeployingtheentirecontentstore.html#RulesWhenDeployingtheEntireContentStore