Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

  • Close [x]

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

developerWorks Community:

  • Close [x]

IBM Business Analytics Proven Practices: Solving an IBM Cognos 10.2 PowerCube Package Attribute and Measure Translation Issue

Product(s): IBM Cognos 10; Area of Interest: Infrastructure

Business Analytics Proven Practices Team, Business Analytics Proven Practices Team, IBM
Business Analytics Proven Practices Team

Summary:  The purpose of this document is to outline the scenario in which IBM Cognos Business Intelligence(BI) reports fail after being deployed to IBM Cognos 10.2.X BI. The document will also provide the steps required to fix any report errors that are caused by this particular scenario.

View more content in this series

Date:  12 Dec 2012
Level:  Advanced PDF:  A4 and Letter (148 KB | 6 pages)Get Adobe® Reader®

Activity:  2966 views
Comments:  

Introduction

Purpose of this Document

The purpose of this document is to outline the scenario in which IBM Cognos Business Intelligence (BI) reports fail after being deployed to IBM Cognos BI 10.2.x. The document will also provide the steps required to fix any report errors that are caused by this particular scenario.

Applicability

The scenario definition and fix description outlined in this document only apply to IBM Cognos BI Report Studio, Query Studio, Power Play10 Studio and Analysis Studio reports which use an IBM Cognos PowerCube as a data source that has been deployed to IBM Cognos BI 10.2.x. In addition, the IBM Cognos BI 10.2.x product language has to be set to Swedish, Spanish, Russian, Czech, French, Traditional Chinese or Dutch.

Caveats

This document assumes that the IBM Cognos BI content has been backed up using a tried and tested method prior to any attempt to run the IBM Cognos Dynamic Report Specification updater utility.


Scenario Presentation

After successfully deploying content into IBM Cognos BI 10.2.x, reports that used to run now present the user with a QE-DEF-0030 Expression parsing error message alongside the QE-DEF-0359 The query contains a reference to at least one object <ObjectName> that does not exist message.


Am I Really Running into this Attribute or Measure Translation Issue?

The following section provides a checklist outlining all the conditions that cause reports to fail due to this scenario.

  • Reports fail with the QE-DEF-0030 and QE-DEF-0359 error.
  • Reports that fail have been deployed to IBM Cognos BI 10.2.x.
  • Report that fail use a package against an IBM Cognos PowerCube as a data source.
  • The IBM Cognos BI 10.2.x product language is set to Swedish, Spanish, Russian, Czech, French, Traditional Chinese or Dutch.

Determining the Presence of the QE-DEF-0030 and QE-DEF-0359 Error

The error message will present itself to the user’s screen in addition to being written into the cogserver.log file located within the <install_dir>\logs directory.

Determining if the Report was Deployed into IBM Cognos BI 10.2.x

In order to determine whether or not the report in question has been deployed into IBM Cognos BI 10.2.x:

  1. Open the report using IBM Cognos Report Studio.
  2. From the Tools menu, select Copy Report to Clipboard.
  3. Open a text editor such as Notepad or vi and paste the report specification.
  4. Within the report specification search for the text RSU-SPC-0093. If the text is found, the report in question was deployed into IBM Cognos BI 10.2.x.

Determining the Package and Data Source of a Report

In order to determine the package that a report is using:

  1. Locate the report in question within the IBM Cognos Connection portal.
  2. Click on the Properties icon of the report to display the Set properties screen.
  3. Within the Set properties screen, on the bottom left hand side, locate the Package: section to get the name of the package being used by the report.
  4. Locate the package being used by the report in question within the IBM Cognos Connection portal.
  5. Click on the More… link for the package in question to display the Perform an action screen.
  6. Within the Perform an action screen, click on the View the package data sources... link to display the data source associated to the package in question.
  7. From IBM Cognos Administration, click the Configuration tab, locate the data source on the Data Source Connections screen, click on the data source name and then click on the Set properties button. Click the Connection tab and ensure the Type: field is set to IBM Cognos PowerCube.

Determining the Product Language

In order to determine the product language setting for the user reporting the problem:

  1. Have the user login to the IBM Cognos Connection portal.
  2. Within the IBM Cognos Connection portal, have the user select the My Preferences link from My Area Options dropdown to display the Set preferences screen.
  3. In the Set preferences screen, the product language is specified in the Product language: field within the Regional options section.

Fixing the Translation Issue

Only if all four of the conditions discussed in the previous section are present can the scenario be fixed using the following steps.

  1. Ensure that a current, tried and proven backup exists of the IBM Cognos BI 10.2.x content. It is important that a backup exists as the fix uses the IBM Cognos Dynamic Report Specification Updater utility to perform a mass change on the affected report specifications within the IBM Cognos Content store.
  2. Download the IBM Cognos Dynamic Report Specification Updater (DRU) 10.x Utility using the following link: https://www-304.ibm.com/support/docview.wss?uid=swg24021248
  3. Follow the installation instructions for the DRU, being sure to update the batch file to point to the appropriate Java Runtime Environment (JRE).
  4. After the JRE update to the batch file, launch the DRU utility by double clicking the batch file.
  5. Once the presented with the initial DRU screen you can familiarize yourself with the utility by clicking the Help button to bring up the user’s guide. After reviewing the DRU user’s guide, connect to your IBM Cognos BI environment by un-checking the Anonymous check box and supplying the correct IBM Cognos BI dispatcher URI, username, password and namespace before clicking the Connect button at the top right of the window.
  6. Once a successful connection has been established, the Content Folder pane located in the left middle of the window screen will display the IBM Cognos BI content.
  7. Within the Transformations pane, use the Load button to browse to the transformation file specific to the product language being used. The following table describes the attached transformation file and what product language they should apply to.

    Product LanguageTransformation File Name
    SwedishSwedish.xml
    SpanishSpanish.xml
    RussianRussian.xml
    CzechCzech.xml
    FrenchFrench.xml
    Traditional ChineseTraditionalChinese.xml
    DutchDutch.xml


  8. Once the desired transformation has been loaded, the Selected Transformations & Order of Execution pane will display the transformation details.
  9. Within the Content Folder pane, select the objects to which the transformation is to be applied.
  10. Within the Execution pane, click on the Search button to search the previously selected object scope for transformation matches. When the search completes, the number of matches found will be displayed in the Log Output pane.
  11. If the number of matches is greater than zero, use the desired Execution settings to apply the changes to the matched report specifications. Be sure to review the DRU documentation on the functionality of the Execution settings.


Download

NameSizeDownload method
Solving_an_IBM_Cognos_10.2_PowerCube_Package_Attribute_and_Measure_Translation_Issue.zip3KBFTP

Information about download methods


About the author

Business Analytics Proven Practices Team

Report abuse help

Report abuse

Thank you. This entry has been flagged for moderator attention.


Report abuse help

Report abuse

Report abuse submission failed. Please try again later.


developerWorks: Sign in


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

Choose your display name

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


Rate this article

Comments

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=851438
ArticleTitle=IBM Business Analytics Proven Practices: Solving an IBM Cognos 10.2 PowerCube Package Attribute and Measure Translation Issue
publish-date=12122012