SAP Knowledge Base Article - Preview

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


SAP BusinessObjects Enterprise XI 3.1


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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.