PM26768: SELECT VALUE FILTER PROMPT IN BUSINESS INSIGHT MAY NOT DISPLAY ALL VALUES

APAR status

• Closed as program error.

Error description

• If a relational database column is set up such that its first
  5000 or so records are one value, the next 5000 are another, and
  so on, then after importing this column into Business Insight
  and then dragging in a Select Value Filter, the "Use only the
  following values:" area of the filter's Properties isn't
  populated with all the different values from the column.??If a
  similar select a value prompt is used in Query Studio or Report
  Studio, then all the different values from the column are
  displayed and selectable.??From reviewing the generated SQL, the
  Business Insight prompt sends a "select" statement to populate
  the selectable values, while the QS/RS value prompts send a
  "select distinct" statement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.1 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

  COG BUS INSIGHT

• Fixed component ID

  5724W12BI

Applicable component levels

• RA11 PSN

     UP