APAR status
Closed as program error.
Error description
In Query Studio, when a calculation is created based on another query studio calculation, it is adding a total() to the already summarized calculation.?For example:?% Elapsed = Days Elapsed/Days of Event??Actual Trade Spend/% Elapsed = (Actual Trade Spend/Days Elapsed) * Days of Event??And?Estimated Trade Spend - (Actual Trade Spend/% Elapsed) = Estimated Trade Spend - ((Actual Trade Spend/Days Elapsed) * Days of Event)??Except in Query Studio?Estimated Trade Spend - (Actual Trade Spend/% Elapsed) = Estimated Trade Spend - Total(((Actual Trade Spend/Days Elapsed) * Days of Event)) ??Report Studio doesn't have this problem. If I create the same calculation in Report Studio using query items directly from the package like in Query Studio, it does not add total() function. Query Studio and Report Studio should be consistent.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos 8 Business Intelligence 8.4.1 Fix Pack * * 2 * * or Upgrade to IBM Cognos Business Intelligence 10.2 Refresh * * Pack 1 * ****************************************************************
Problem conclusion
Code Fix
Temporary fix
Comments
APAR Information
APAR number
PM28910
Reported component name
COG8 BI QUERY S
Reported component ID
5724W12QS
Reported release
841
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-12-14
Closed date
2013-04-26
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
Fixed component name
COG8 BI QUERY S
Fixed component ID
5724W12QS
Applicable component levels
R841 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWV","label":"Query Studio v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"841","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
11 June 2013