Page 1 of 1
Show Cube in Excel interface
Posted: Sat Mar 31, 2012 9:15 am
by EP_explorer
Is it possible to create such thing.
In Perspective user clicks on button in Excel file and TM1 shows him a Cube View which has a form like presented in Architect or Perspective (I don't like Excel view formed by DBRW)
Re: Show Cube in Excel interface
Posted: Sat Mar 31, 2012 10:23 am
by Marcus Scherer
Well, Excel looks like Excel.
Did you try In Spreadsheet Browser as an Alternative?
Re: Show Cube in Excel interface
Posted: Sun Apr 01, 2012 9:19 pm
by lotsaram
As far as I'm aware although you can call server explorer from Excel via code there is no programatic interface to call a cube view (why, your guess as good as mine. I have wished for the ability to call a view and have it take focus many times). - Other than using SendKeys and due to differing security users might have and their own private views, then that route would be unpredictable to say the least, not something I would ever bother trying.
I guess you could embed an EV ActiveX control on a form and when loading the form pass in the datasource, database and view. That all certainly seems possible. whether it is worth the effort though...