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 number
PM79665
Reported component name
COG REPORT STUD
Reported component ID
5724W12RS
Reported release
A10
Status
CLOSED URX
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-12-21
Closed date
2013-06-11
Last modified date
2013-06-11
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":"SSCHNWW","label":"Report Authoring v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A10","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
11 June 2013