PM43631: DRILL-THROUGH ON DATE DIMENSION LEVEL NOT PASSING DATE RANGE WHEN MORE THAN 150 CATEGORIES ARE PRESENT

APAR status

• Closed as suggestion for future release.

Error description

• Client has created a date dimension in their cube that contains
  a non-time alternate drill-down level. This level contains 6
  different categories of day ranges. This level is based on a
  text field created in Framework Manager.   The problem is
  occurring when users attempt to drill-through on the "> 150
  Days" category. When drilling on any of the other categories in
  this level, a date range is passed as expected.  When "> 150
  Days" is drilled on, however, only the category label is
  passed.. When we look at this category and children in
  Transformer, I don't see anything out of the ordinary--only
  valid dates are children.
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• Due to the number of members in the largest bucket, the filter p
  redicate is too large to be handled via a drill through.  The re
  commendation is to either create additional buckets to further r
  educe the number of members in the greatest bucket, or use alter
  nate filter contraints to limit the number of dates past 150 to
  something a little more manageable.
  

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