Dimension level name

[RolfN]

Hi.

Is it possible to detect a dimension level within OWC?
Take the Store dimension in Foodmart 2000 as an example.
I have the dimension as rows and I want to trigger a Reporting Services
report when the user clicks on a member in the Store Name level.
If the user clicks in any other level nothing should happen.
I have figured out how to get the member using this code:

Sub PivotTable1_Click()
If TypeName(PivotTable1.Selection(0).Caption) = “PivotRowMembers†then
msgBox(PivotTable1.Selection(0).Caption)
End If
End Sub

But how can I get the clicked dimension level name?
Any suggestions will be appreciated.

Regards/Rolf