Hi All
Apologies if this question has been asked in the past...but hopefully someone might be able to help...
I am trying to build an excel or powerpoint flowchart representation of my TM1 model and I want to be able to click on a part of this flowchart
and open up the dimension list, rule editor or cube view.
Couple of questions...
1. Is anyone aware of a technique that will do this ?.
2. Is there a way to get a direct URL from TM1Web to a specific cube ?.
Thanks
Nick
Flowchart linking to TM1 Cube View or TM1 Web
-
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Flowchart linking to TM1 Cube View or TM1 Web
You can get to a specific cube view via the TM1 web URL API, just look it up it is not that difficult (it helps if you haven't used spaces in any object names).
There is no programatic or hyperlinked way to get to the rule editor, specific spot in server explorer tree or a specific cube view in perspectives/architect (other than using sendkeys).
There is no programatic or hyperlinked way to get to the rule editor, specific spot in server explorer tree or a specific cube view in perspectives/architect (other than using sendkeys).
-
- Posts: 53
- Joined: Tue Jul 28, 2009 7:26 pm
- OLAP Product: TM1, EP, Powerplay, C8/C10
- Version: 10.2
- Excel Version: 2013
- Location: London
- Contact:
Re: Flowchart linking to TM1 Cube View or TM1 Web
Thanks Lotsofram !!!.
Looks like the URL is of the format:
http://server/TM1Web/TM1WebMain.aspx?ac ... $$VIEWNAME
e.g.
http://localhost/TM1Web/TM1WebMain.aspx ... s$$Default
Struggling to find any decent documentation on the TM1 Web URL API....any pointers ???
Cheers
Nick
Looks like the URL is of the format:
http://server/TM1Web/TM1WebMain.aspx?ac ... $$VIEWNAME
e.g.
http://localhost/TM1Web/TM1WebMain.aspx ... s$$Default
Struggling to find any decent documentation on the TM1 Web URL API....any pointers ???
Cheers
Nick
-
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Flowchart linking to TM1 Cube View or TM1 Web
The "Developing Custom Web Applications with the URL API" section of the developers manual should be adequate.
-
- Posts: 53
- Joined: Tue Jul 28, 2009 7:26 pm
- OLAP Product: TM1, EP, Powerplay, C8/C10
- Version: 10.2
- Excel Version: 2013
- Location: London
- Contact:
Re: Flowchart linking to TM1 Cube View or TM1 Web
Thanks !...
http://publib.boulder.ibm.com/infocente ... witht.html
Just to be completely sure...there is no URL API to get me a list or contents of dimensions is there ?.
(Wishful thinking !)
Cheers
Nick
http://publib.boulder.ibm.com/infocente ... witht.html
Just to be completely sure...there is no URL API to get me a list or contents of dimensions is there ?.
(Wishful thinking !)
Cheers
Nick
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: Flowchart linking to TM1 Cube View or TM1 Web
Possibly. You can put a load of dimensions up in an application folder and then retrieve the contents of the folders as XML (see the section in the doco Lotsaram pointed you to: Using the Navigation Tree Object in XML Mode). Then, maybe you could do something with that information client side ?Just to be completely sure...there is no URL API to get me a list or contents of dimensions is there ?.
(Wishful thinking !)
On the other hand, TM1 Web is pretty flexible, you could have a 'report' with a list of dimensions that is just called by an Action Button in 'hyperlink' mode, or even just use plain old Excel hyperlinks.
Robin Mackenzie