PK89801: When aggregation rules of measure is set to Last, measures in the analysis appear as "--" in Analysis Studio

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 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