PH03363: PDS-PPE-0045 THE QUERY DOES NOT CONTAIN A MEASURE FROM SOME REPORTS WHEN USING NEEDZSFORVERYSPARSEPCCUBES

APAR status

• Closed as fixed if next.

Error description

• PDS-PPE-0045 The query does not contain a measure
  

Local fix

•  not use needZSforVerySparsePCcubes parameter
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.1.2                       *
  ****************************************************************
  Configuration Instructions:
  
  To properly enable the optimization, certain files in the
  configuration folder of the installation(s) must be changed as
  follows.
  
  In qfs_config.xml, change
  
  <provider name="ZeroSuppressProvider"
  libraryName="qfsZeroSuppressProvider"/>
  
  to
  
  <provider name="ZeroSuppressProvider"
  libraryName="qfsZeroSuppressProvider">
             <providerDetails>
                 <needZSforVerySparsePCcubes value="true"/>
             </providerDetails>
  </provider>
  
  
  It is also recommended that the ppds_cfg.xml be modified to
  include the following lines:
  
  <!-- ForceFullZeroSuppression is a test setting that is
  disabled/off by default.  When enabled, the full
  zero-suppression request
       (in which zeros, null, divide-by-zero, and overflow values
  are all suppressed) will replace any other zero-suppression
  call.
  -->
  		<ForceFullZeroSuppression value="1"/>
  <!-- -->
  

Problem conclusion

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

Applicable component levels