PI65708: DIFFERENT SQL GENERATED FOR DYNAMIC CUBE REPORT BETWEEN HTML ANDEXCEL 2007

APAR status

• Closed as suggestion for future release.

Error description

• When running a crosstab report with many calculations, the
  generated SQL between HTML and Excel 2007 is different. Excel is
  generating 13 queries, whereas HTML is generating 29 queries,
  resulting in a faster performance for Excel 2007 outputs.
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• The report when runs as HTML works as designed and returned the
  expected numbers of SQLs.
  
  When a report was run and saved as HTML, by default, it is
  expected from the report to perform drill-up/-down,
  drill-through and other interactive actions once the report was
  saved and opened in Report Viewer.
  The interactivity of the HTML report causes that the additional
  properties were created in the requests which may cause slower
  return of the report results.
  
  When the user does not require the HTML interactivity in the
  saved report, by disabling the selection-based interactivity
  feature the report will run faster and in this case will create
  the same number of SQLs as when the same report was run as Excel
  2007 (or PDF).
  To disable the HTML interactivity, the option "Enable
  selection-based interactivity" should be checked-out in
  Properties for the Report (or in Advanced options). For detail
  please check the section "Disable Selection-based Interactivity"
  (Page 95) in the document:
  http://data.ucop.edu/files/documents/cognos-connection-10.2.2.pd
  f
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PI64179

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels