Troubleshooting
Problem
Crosstab returns empty when the report is executed with a content language, that is a having a comma as decimal separator.
Symptom
The expected data is not returned.
Cause
Business Key of the dimension has been using a decimal value.
Environment
Cognos Analytics 11.0.13
Compatible Query Mode
Diagnosing The Problem
Fact Cells are empty, but are expected to return data:
Resolving The Problem
The business key of the member contains a decimal value. For example a complete Member Unique Name is [Namespace].[Dimension].[Hierarchy].[Level]->[all].[5.9] . When the report is executed with German content language, the decimal separator changes to comma, thus the member cannot be found.
General recommendation is to use integer values for business keys.
To solve this situation with decimal values, cast the business key to a character data type in the Framework Manager model, and replace the decimal separator with a static character . (dot) or , (comma).
Also Dynamic Query Mode does not show this behavior.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
04 March 2019
UID
ibm10874578