APAR status
Closed with unknown close code.
Error description
Measures in the analysis appear as "--" in Analysis Studio. It appears that the issue happens with the following conditions. 1. Aggregation rule of the measure is set to Last in FM. 2. Dimension is expanded in the analysis. 3. Inserting the dimension being expanded in the analysis into the Context filter area. See the attached testcase for more detail. (Environment) C84 GA + FP1 -- reproduced.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh * * Pack 1 * ****************************************************************
Problem conclusion
Temporary fix
Comments
While we realize this shortcoming, this behavior is intended to ensure the validity of result. Current design doesn't allow u s to correctly compute teh summary in such scenarios. The behavi or observed is described in Report Studio user guide (ug_rpstd.p df) in Appendix A: Troubleshooting - Error Characters (--) Appea r in Reports. The following snippet describes the behavior: Error Characters (--) Appear in Reports When you run a report, you see two dash (--) characters in your report instead of values. These characters may appear if you use an OLAP data sources othe r than PowerCube and Microsoft SQL Server 2005 Analysis Services (SSAS), and you apply aggregat ion to calculations and measures that use rollups other than Sum (Total), Maximum, Minimum, First , Last, and Count. All other types of rollup either fail or return error cells, whi ch typically display as two dash characters (--). This problem occurs in, but is not limited to, the following: - footers - aggregate function - summary filters and detail filters that use a summary - detail, summary, and context filters that select more than one member of a hierarchy that is used elsewhere on the report If you are working with a SSAS 2005 data source, these character s may also appear in summary cells if you use an OR filter in the summary. To avoid this prob lem, do not use OR filters in summaries.
APAR Information
APAR number
PK89801
Reported component name
COG8 BI ANALY S
Reported component ID
5724W12AS
Reported release
840
Status
CLOSED URX
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-06-25
Closed date
2013-06-13
Last modified date
2013-06-13
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
RA21 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWL","label":"Analysis Studio v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"840","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
13 June 2013