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

[Boas]

Hi everyone,

since Wims respond is some time ago, I was wondering if there are new possibilities regarding the original question, especially in the PA world.

We would like to open a cube view in the cube viewer via VBA macro.

Sadly, Drill-processes seem not to be the solution:
https://tm1forum.com/viewtopic.php?p=36927#p36927
viewtopic.php?t=6076

[Boas]

Hi everyone,

there came something to my mind again: The Workspace User Interface API.

By this, you could at least show a saved cube view in the internet browser:
https://ibm.github.io/planninganalytics ... g-a-widget

Though, you have to handle all the authentification stuff and you leave the Excel environment. So I still welcome other solutions/approaches.

Best regards and thanks in advance!

[Wim Gielis]

You could consider the PAfE API to create an Exploration with Excel VBA.
https://ibm.github.io/paxapi/#introduction

[Boas]

Hi Wim,

oh, great! That's a good hint! Thanks a lot! This should make it possible to accomplish what I have in mind.

[Wim Gielis]

You're welcome, hope it works fine or you.