Open Cube Browser with VBA?

[mitch23]

Does anyone know if there is a way to open up a cube browser with VBA (and ideally with a specified layout and subsets present)?

[lotsaram]

You could programatically insert an in spreadsheet browser view control and set the cubename and viewname properties but AFAIK programatically opening the Perspectives cube browser itself is not possible but it would be good to be wrong on this one as it would be a handy rabbit to pull out of the hat from time to time.

[Wim Gielis]

Hi

It's possible, but not the safest code. You can use SendKeys in VBA. Adjust

Code: Select all

Sub Open_SE()

Application.Run "TM1StartOrionWithAutomation"

'wait for Server Explorer to open
Application.Wait Now + TimeValue("00:00:05")
'expand Applications
SendKeys "{RIGHT}{RIGHT}{RIGHT}{RIGHT}{RIGHT}"
'jump to cubes and expand
SendKeys "{C}{RIGHT}"
End Sub

Source: http://www.bihints.com/book/export/html/2

Wim