Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

not enable users to drilldown

Dear all

can you pls tell me if there is a way to unable users to drilldown for a specific characteristic?



Former Member
Former Member replied

Hi Sancho,

If this a 3.5 BEx environment, you can use VBA in the SAPBEXonRefresh procedure to check the drill down state of the characteristic in question. If the item has been 'drilled down' then you can change that state dynamically to remove it from the report.

Try this VBA code.

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

Dim myRange As Range
Set myRange = Range("B6") 

<b><i>' B6 is the right click cell for your characteristic in question</i></b>

If Run("SAPBEX.XLA!SAPBEXgetDrillState", 0, myRange) <> 0 Then
Run "SAPBEX.XLA!SAPBEXsetDrillState", 0, myRange
End If

End Sub



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question