PI06629: HOW TO ELIMINATE THE DISTINCT QUERY AND USE ONLY A GROUP BY

APAR status

• Closed as program error.

Error description

• When using count distinct and tuple in DMR with different fields
  for _businessKey and _memberCaption, how can you eliminate the
  distinct query and use only the group by???This issue was
  reported as APAR#PM97014 but rejected as design intent
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Fix Pack 2  *
  *                                                              *
  * Additional Configuration:                                    *
  *                                                              *
  * To enable it the following configuration flag                *
  * (useMinAggregateForLevelAttributes ) has to be added to the  *
  * 'MDOperationProvider' configuration section in the           *
  * qfs_config.xml file.                                         *
  *                                                              *
  * <provider name="MDOperationProvider"                         *
  * libraryName="qfsMDOperationProvider" serviceProvider="true"> *
  *     <providerDetails>                                        *
  *         . . .                                                *
  *         <useMinAggregateForLevelAttributes value="true"/>    *
  *     </providerDetails>                                       *
  * </provider>                                                  *
  *                                                              *
  *                                                              *
  * NOTE: The "SQL generation for level attributes" model        *
  * governor has to be set to "Minimum". or upgrade to IBM       *
  * Cognos Business Intelligence 10.2.1 Fix Pack 3               *
  ****************************************************************
  

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

  COG WRKSPC ADV

• Fixed component ID

  5724W12BA

Applicable component levels

• RA20 PSN

     UP