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)
Show Cube in Excel interface
-
EP_explorer
- Regular Participant
- Posts: 202
- Joined: Sat Dec 04, 2010 2:35 pm
- OLAP Product: PAL
- Version: 2.0.9
- Excel Version: 2016
-
Marcus Scherer
- Community Contributor
- Posts: 126
- Joined: Sun Jun 29, 2008 9:33 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
- Location: Karlsruhe
Re: Show Cube in Excel interface
Well, Excel looks like Excel.
Did you try In Spreadsheet Browser as an Alternative?
Did you try In Spreadsheet Browser as an Alternative?
-
lotsaram
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Show Cube in Excel interface
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...
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...