PM28910: QUERY STUDIO SHOWS INCORRECT RESULTS WHEN CREATING A CALCULATION BASED ON ANOTHER QUERY STUDIO CALCULATION

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