How to get started TM1 Web programming

Post Reply
iansdigby
Community Contributor
Posts: 109
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10 + Plan An
Excel Version: All
Location: Isle of Wight, UK

How to get started TM1 Web programming

Post by iansdigby »

Hello esteemed TM1 programmers.

I see that TM1 Web has a URL API that I am guessing would let me create dashboards etc.
Not being a web programmer at all, my question is - how to get started?
What I would really be grateful for is an ultra-simple idiot's guide in a few lines that tells me what the basic mechanism is.

For instance if i were telling someone how to start VBA programming I would say.
1. Open Excel
2. Go Alt-F11 to enter the editor
3. Write some code
4. Save it as an add-in
5. Load the add-in

All help very much appreciated.

Ian
"the earth is but one country, and mankind its citizens" - Baha'u'llah
User avatar
Harvey
Community Contributor
Posts: 236
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: PA, TM1, CX, Palo
Version: TM1 8.3 onwards
Excel Version: 2003 onwards
Contact:

Re: How to get started TM1 Web programming

Post by Harvey »

The URL API in TM1Web is really just a way to open views and websheets with certain title element selections and parameters. You could create a dashboard (perhaps using iframes) this way, and it's pretty simple so long as you don't want to customize much.

Of course you'd need to learn html, but that's pretty basic and there are plenty of tools in existence to help you out.

If you want serious customization, you can use ASP.NET and the TM1 API, or other web technologies like PHP. If you're not a web programmer, you'd need to spend a lot of time learning, or just hire someone to help you out.
Take your TM1 experience to the next level - TM1Innovators.net
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: How to get started TM1 Web programming

Post by rmackenzie »

iansdigby wrote:I see that TM1 Web has a URL API that I am guessing would let me create dashboards etc.
Not being a web programmer at all, my question is - how to get started?
1. Open Notepad
2. Save a new file called test.html. This can be in My Documents or pretty much anywhere is fine.
3. Copy in this code

Code: Select all

<html>
 <head>
  <title>Robin's Test Page</title>
 </head>
 <body>
  <iframe id="example_frame"
          name="example_frame"
          width=800
          height=800
          src="http://YOUR_SERVER_NAME/TM1Web/TM1WebMain.aspx?action=OpenObject&type=Cubeviewer&value=YOUR_CUBE_NAME$$YOUR_CUBE_VIEW">
  </iframe>
 </body>
</html>
4. Replace YOUR_SERVER_NAME with the name of the machine running TM1 Web, YOUR_CUBE_NAME and YOUR_CUBE_VIEW with the name of the cube and the view you want to browse.
5. Save the file
6. From Windows Explorer, double-click to open the page
7. The page should open in Internet Explorer (or whatever your default browser is)
8. You'll probably get a small pop-up asking you to log-in to TM1
9. Now you're doing TM1 web programming!

More information:
TM1 URL API
HTML and other web stuff
Robin Mackenzie
iansdigby
Community Contributor
Posts: 109
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10 + Plan An
Excel Version: All
Location: Isle of Wight, UK

Re: How to get started TM1 Web programming

Post by iansdigby »

To rmackenzie,

Thank you profusely for this most helpful guide - at the risk of being boring, this is just what's lacking in the development world: basic training that gives a simple but satisfying result. Now I can get going and figure the rest out for myself!

Thanks again,

Ian
"the earth is but one country, and mankind its citizens" - Baha'u'llah
Post Reply