Page 1 of 1
Open Cube Browser with VBA?
Posted: Thu Oct 22, 2009 9:38 am
by 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)?
Re: Open Cube Browser with VBA?
Posted: Thu Oct 22, 2009 10:13 am
by 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.
Re: Open Cube Browser with VBA?
Posted: Fri Oct 23, 2009 5:22 pm
by 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
Re: Open Cube Browser with VBA?
Posted: Fri Jun 28, 2024 12:08 pm
by 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
Re: Open Cube Browser with VBA?
Posted: Fri Jun 28, 2024 12:57 pm
by 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!
Re: Open Cube Browser with VBA?
Posted: Sun Jun 30, 2024 7:43 am
by Wim Gielis
You could consider the PAfE API to create an Exploration with Excel VBA.
https://ibm.github.io/paxapi/#introduction
Re: Open Cube Browser with VBA?
Posted: Fri Jul 05, 2024 11:02 am
by 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.
Re: Open Cube Browser with VBA?
Posted: Fri Jul 05, 2024 11:13 am
by Wim Gielis
You're welcome, hope it works fine or you.