An administrator is checking the current activities and recognizes one activity with several successful
tasks with two still running. The administrator cancels this activity.
Where will this activity be shown?
Note: Users can access Current Activities, Past Activities, Upcoming Activities and Schedules on the
Status tab in IBM Cognos Administration to monitor the server activities and manage schedules.
An administrator needs to setup security for a newly installed environment.
Which of the following is a valid step?
You may not want all users that exist in an authentication source to have access to IBM Cognos
software. To secure IBM Cognos software, configure the product so that only users who belong to a
specific group or role in your authentication source, or in the Cognos namespace, are allowed access.
We recommend using the Cognos namespace because it contains preconfigured groups and roles
that help you to secure IBM Cognos software quickly. One of the preconfigured groups is Everyone.
By default, the group Everyone belongs to several built-in groups and roles in the Cognos
If you decide to use the Cognos namespace, you must remove the Everyone group from all built-in
groups and roles and replace it with groups, roles, or users authorized to access IBM Cognos
References: IBM Cognos Administration Version 10.1.0, Administration and Security Guide, page 64
In a multi-server environment, an administrator wants to ensure that items in the Content Manager
Cache service are re-validated every thirty seconds.
Which option would accomplish this?
ValidatorTimetoLive determines how long data objects remain in the cache. After the Validator timer
expires objects are considered Invalid and have to be fetched from Cm again. Value is in ms, and
default is 900000.
References: https://www.slideshare.net/barnaby1502/cognos-technical-super-session-2012, page 11
An administrator has configured authentication.
Which statement is true for users logging on to the application?
How to adjust the session timeout in Cognos Analytics
A high user load and interactive reporting system on a distributed installation is throwing timeout
How is this resolved?
Increase Asynchronous Timeout in High User Load Environments.
If you have a high user load (over 165 users) and interactive reports are running continuously in a
distributed installation, you may want to increase the asynchronous timeout setting to avoid getting
error messages. The default is 30000.
To resolve this problem, increase the wait timeout.
Which statement is true when working with datasource credentials?
When running report user is prompted to enter the signon but the check box " Remember my user
ID and password when connecting to this data source is not displayed .
User has no signon saved in his profile
Diagnosing the problem
Check the user capabilities and persmissions
Resolving the problem
Cognos Administrator must grant user/group execute permissions for the Manage own data source
An administrator wants to describe the internal architecture and request flow for a Query service of
an executed DQM report.
How is this done?
The SQL engine obtains data directly from the RDBMS Adapter. The Query Execution Engine updates
the secure Data Cache with dimensional data for future reuse.
Note: A report specification is an executable definition of a report, including query and layout rules,
which can be combined with data to produce a report output.
IBM Cognos Analytics is installed on a non-Windows platform. An administrator receives the
following error after setting up a datasource connection:
XQE-DS-0014 Unable to logon to the data source. An unexpected error from the JDBC driver
java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.8 is not
supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
What should the administrator do to rectify this problem?
Based on the error message that is displayed, it is likely that the JDBC driver is unable to read the
correct .jar file. When performing an update of the JDBC driver to receive the new .jar file, the
original .jar file is still likely to be stored in the same location as it contains the same file path that is
held in the installer of the software.
Ensure that JDBC drivers are in the correct location. For the IBM Cognos Analytics, the JDBC drivers
must be copied to the install_location\drivers directory.
An administrator is tuning the Caching services to improve Dynamic cube report performance. At the
same time, there is a need to control the memory usage and Clear Cache.
How is this done?
To avoid using outdated data that might be stored in the cache, you can clear the cache. You might
want to clear the cache manually if your data source metadata changes infrequently or if you want to
clear the cache in between automatically scheduled cache clearing. When you clear the cache using
the following steps, it clears everything in the cache.
1. Start IBM Cognos Connection.
2. In the upper-right corner, click Launch, IBM Cognos Administration.
3. On the Configuration tab, click Query Service Caching.
4. Select the server groups for cache clearing.
5. Click Clear cache.The status of the Clear cache command is displayed.If a cache is being used by
one or more pending reports or queries, it is internally flagged as stale by this command and is
automatically cleared as soon as this usage completes.
6. Click Close.
References: IBM Cognos Administration Version 10.1.0, Administration and Security Guide, page 253
The folder AP has reports that can retain output for 12 months. The administrator needs to remove
report output that is at least 30 days old from the Content Store, and archive it to an external
repository while keeping up to 12 months of run history.
How can this be accomplished without losing any output or run history?
Administrators use the retention rule update task to specify the number of reports, queries,
analyses, and document objects to keep in the content store. You can specify how long to keep the
history and output versions in the content store. Anything that is older than the date you specify is
deleted from the content store.
Run this task only after creating and running the content archival task. If you run it before, content
that was not marked for archival is permanently deleted from the content store.