not enable users to drilldown
can you pls tell me if there is a way to unable users to drilldown for a specific characteristic?
Larry Hampton replied
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