1483336 - No results returned when drill down on BW hierarchies with “Use Query drill” option checked

• When drill down on a dimension with BW hierarchies, if the "use the query drill" option is checked, no data will be returned
• If uncheck the "use the query drill" option, drill down works properly and correct data returned.
• The drill down filter automatically added to the query is using the value displayed in the report, which usually the "text" value used by the dimension. But if you try to filter on this dimension, you will see the LOVs of this dimension are the "key" values of the dimension instead of the "text" values.
• The issue might only happen to some dimensions.

• BOE 3.1 FP2.3
• SAP BW 7.01 with SP5

Use the Query Drill, Drill down, Hierarchy , KBA , BI-RA-WBI , Web Intelligence , Problem