Page 1 of 1
Flowchart linking to TM1 Cube View or TM1 Web
Posted: Sat Jun 18, 2011 10:12 am
by hardstep
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
Re: Flowchart linking to TM1 Cube View or TM1 Web
Posted: Sat Jun 18, 2011 1:55 pm
by lotsaram
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).
Re: Flowchart linking to TM1 Cube View or TM1 Web
Posted: Sat Jun 18, 2011 2:25 pm
by hardstep
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
Re: Flowchart linking to TM1 Cube View or TM1 Web
Posted: Tue Jun 21, 2011 12:55 am
by lotsaram
The "Developing Custom Web Applications with the URL API" section of the developers manual should be adequate.
Re: Flowchart linking to TM1 Cube View or TM1 Web
Posted: Tue Jun 21, 2011 7:41 am
by hardstep
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
Re: Flowchart linking to TM1 Cube View or TM1 Web
Posted: Tue Jun 21, 2011 11:19 am
by rmackenzie
Just to be completely sure...there is no URL API to get me a list or contents of dimensions is there ?.
(Wishful thinking !)
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 ?
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.