APAR status
Closed as documentation error.
Error description
Query Optimization Advanced Property on Dashboard Canvas is not Documented Anywhere
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * CA users * **************************************************************** * PROBLEM DESCRIPTION: * * * * Query optimization advanced property on dashboard canvas is * * not documented anywhere. * * * * As per SLACK discussion here: * * https://ibm-analytics.slack.com/archives/C09FGKZEU/p16545911 * * 68451289 * * * * There was a new toggle option in the advanced properties * * introduced in 11.2.0 * * * * This on/off setting can be found within 11.2 within the * * Dashboard Advanced Properties, alongside the Data Cache * * setting, and, Color Consistency. The documentation should be * * updated to include what this new feature actually does. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
That's fine, I transcribed an excerpt from the presentation: "Here is what I have gathered In a nutshell regarding dashboard improvements in 11.2. and how query optimization functions. There have been improvements to consolidate so fewer queries are sent to the query engine. Benefits - Total number of SQL queries dispatched to underlying data sources will be fewer because now there will be queries pulling in measures (for example through one query vs separate queries per measure). Some other benefits is that's less request traffic to the query engine, less churning of the query result cache, as well so there are several net benefits that flow through. There is a toggle box in the dashboard where you can turn this feature on or off, in order to compare the efficacy of said optimization." FYI - The customer has initiated closure of the case, so think we are good for now. They are happy with the explanation above.
Temporary fix
Comments
APAR Information
APAR number
PH47063
Reported component name
COGNOS ANALYTIC
Reported component ID
5724W12XX
Reported release
B10
Status
CLOSED DOC
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-06-07
Closed date
2022-06-17
Last modified date
2022-06-17
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
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"Cognos Analytics"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B10"}]
Document Information
Modified date:
18 June 2022