PM79665: COGNOS 10.1. BI TM1 - CALCULATIONS DO NOT SHOW UP IN BI REPORTS WHEN SET SLICERS ARE USED.

APAR status

• Closed with unknown close code.

Error description

• The customer's return design includes two or more set based
  (multi-valued) slicer elements. These reports return error
  results for rule based consolidations.  Normally a
  calculatedMember(s) would be introduced to an authored report to
  represent multi-valued subsets (data slices) to ensure that the
  expected aggregation results are available to Cognos BI.
  Typically the calculatedMember takes the form: member( total (
  currentMeasure within set #promptMany.....  Attempting to
  introduce this calculatedMember in Cognos 10.1 (and FP1) on a
  DQM based package returns the error:  XQE-PLN-0017: The query is
  not supported: It contains a slicer on a query-defined
  calculation.  The customer has developed their project landscape
  against DQM based packages.  Cognos 10.1.1 and 10.2 do not
  return this error and correctly return aggregated values (where
  a calc member is introduced to the report)  The customer
  requires an urgent product update to enable the calculatedMember
  to be planned against a DQM based TM1 package.  A CQM based
  package will plan the report successfully where the report
  contains calculateMembers.  Due to the existing shared Cognos
  10.1 environment, the customer is not able to schedule and
  upgrade of their Cognos 10.1 environment.
  

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

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