VBA to Drill Down to a Level in Smartview

[tbiven78]

Good Afternoon,

Any help would be appreciated as I'm at a loss with resources and time. I need VBA code to drill down to the lowest level in a Smartview template I've set up. This could be as simple as double clicking the cell automatically, which triggers a drill down or perhaps some code I'm unaware of that drills down on a particular field. The purpose of doing this is to have an easily updated template that can be somewhat interactive depending on other selections in the workbook. The code I have is as follows(Keep in mind this only updates but does not drill down):

Keep in mind I have my Hyperion Declaration in the Module.Anyone who has dealt with Smartview realizes why I turn Calcs off before updating.


Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
sts = HypRetrieve("Table")
Application.Calculate
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True


End Sub


Any and All help is greatly appreciated.

Thanks,

Tim