Flowchart linking to TM1 Cube View or TM1 Web

Post Reply
hardstep
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:

Flowchart linking to TM1 Cube View or TM1 Web

Post 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
lotsaram
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

Post 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).
hardstep
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

Post 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
lotsaram
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

Post by lotsaram »

The "Developing Custom Web Applications with the URL API" section of the developers manual should be adequate.
hardstep
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

Post 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
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Flowchart linking to TM1 Cube View or TM1 Web

Post 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.
Robin Mackenzie
Post Reply