Skip to main content

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

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

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

Content navigation