IBM Support

Drill-through from an OLAP data source, in IBM Cognos Mobile, can result in incorrect results

Flash (Alert)


Performing a drill-through from an OLAP source will generate incorrect output when viewed in a Mobile environment.


The issue has been logged as APAR PM51268 and exists in IBM Cognos Mobile version 10.1.0 and 10.1.1. To prevent the data integrity issue from occurring, it is strongly recommended that you upgrade to Cognos Mobile 10.1.1 Fix Pack 1. This Fix Pack has removed the ability to drill through from OLAP to relational in a Mobile environment. The functionality will be reintroduced at a later date once there is a permanent solution.
A Drill-through from an OLAP source which was created and working successfully in the Web environment will have issues in on a Mobile device. If the report author intended the drill capability to filter the target result by the selected criteria in the source report then the filter condition in the target report will fail to resolve and a target report with no match on the filter will occur. This results in an empty report. If the filter is to setup to return all values except for a specific one(s), then the report will return all data. For example, if the filter is setup to select a City value equal to "New York" an empty report will be returned. If the filter is setup to select all City values except "New York", a report with all data, including New York will be returned.

The contents of this Alert is based on the best-available information as of the date of its publication. While every attempt has been made to provide guidance on the known issue at the time of publication, the Alert may not describe all of the circumstances under which the issue described above may occur, and may not provide a resolution for every occurrence of the issue. We continue to work to provide a comprehensive solution. We encourage you to use MyNotifications to set up notifications for Alerts to enable you to automatically receive updates to this Alert. As well, it is recommended that you subscribe to APAR PM51268 to enable notification of updates to the APAR. Alternatively, please periodically check this Alert for updates.

Document information

More support for: Cognos Mobile

Software version: 10.1, 10.1.1

Operating system(s): AIX, BlackBerry OS, HP-UX, Linux, Solaris, Symbian OS, Windows, iOS

Reference #: 1570446

Modified date: 2014-07-18