Reports based on PowerCubes will generate an error and not run successfully using Cognos Business Intelligence 10.1.1 (applies only to certain languages).

Flash (Alert)


Abstract

A problem has been identified where reports that are based on PowerCubes will not run successfully in Cognos Business Intelligence 10.1.1. This problem affects French, Danish, Dutch, Norwegian, Swedish, Spanish, Russian, Czech, and Traditional Chinese customers that use PowerCubes. The error(s) will occur when attempting to run the report in Report Studio, Query Studio, Analysis Studio, Business Insight, Business Insight Advanced, and Business Intelligence for Excel.


Content

Each time the query engine connects to a PowerCube it dynamically generates a set of metadata based on the cube contents.

This metadata is as set of strings such as [Cube].[Dimension].[Member].

These strings are stored in reports in the form, above.

The Query engine generates localized metadata strings as necessary. One of the [ ] qualifiers in the string is the name of the measures folder. For example. we might see a string such as [Cube].[Measures].[Revenue]

In the languages listed above, the measure folder name used in Cognos BI 8.X 10.1.0 was "Measure_Default" (translated to the appropriate language). In the other languages the measure folder name is "Measures". In Cognos BI 10.1.1 the folder was named Measures in all languages for consistency. This situation also affects:

ROOTCATEGORY
CURRENCY_CAPTION
MEASURES_CAPTION
SHORT_NAME_SUFFIX
LONG_NAME_SUFFIX


Two APARs have been logged for this issue:

PM51487 - Differences in Spanish translations for "Short name"

PM51788 - Default measure name for PowerCubes is incomplete for Dutch content languages and results in QE-DEF-0030, QE-DEF-0359 errors

An interim fix is now available on Fix Central that will resolve this problem in existing IBM Cognos BI 10.1.1 installations. For new installations or upgrades, download IBM Cognos BI 10.1.1 from Passport Advantage or FCT as appropriate.

While every attempt has been made to provide guidance on the known issues 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 set up MyNotifications for Alerts to enable you to automatically receive updates to this Alert. As well, it is recommended that you subscribe to APARs PM51487 and PM51788 to enable notification of updates to the APAR. Alternatively, please periodically check this Alert for updates.


Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos Business Intelligence

Software version:

10.1.1

Operating system(s):

AIX, HP Itanium, HP-UX, Linux, Solaris, Windows

Reference #:

1573959

Modified date:

2011-12-20

Translate my page

Machine Translation

Content navigation