PH29315: LOWER LEVEL COLUMN DEPENDENCIES IN DATA MODULES WHEN JOINING MULTIPLE DATA SOURCES CAUSE ERROR IN DASHBOARDS

APAR status

• Closed as program error.

Error description

• When a data module uses multiple data sources, in this case a
  Data Set for the fact table, an uploaded file for the Products
  table, and a Data Server for the Time table. When column
  dependencies are defined for Products and Time and a dashboard
  is created where tables for Products and Time are used to filter
  fact-based widgets on the dashboard, you receive the following
  error when trying to filter: Query Service internal error has
  occurred, please see the log for details. This seems to only
  occur when the fact-based widget has a column that is at a lower
  level of granularity than the column dependency on which the
  relationship join is based. In this case, adding Product to the
  widget when the filter widget is based on Product Type (which is
  the level joined to the fact table) causes the error.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.1.7 Fix Pack 2            *
  ****************************************************************
  

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 DASHBOARDS

• Fixed component ID

  5724W12DB

Applicable component levels