Web Dashboards via REST API

Post Reply
jv_oz
Posts: 9
Joined: Fri Oct 13, 2017 12:44 pm
OLAP Product: TM1
Version: PA 2.0.2
Excel Version: 2016 64 bit

Web Dashboards via REST API

Post by jv_oz » Sun Aug 12, 2018 11:20 pm

Hi Everyone,

I want to create a web and phone-based application that uses TM1 as the engine and is presented using schmick browser and app dashboards. I need to have write-back available to the TM1 server.

I get the TM1 side and will use the REST API to get to the data. I am then thinking of using some D3 (or similar) visualisations in the dashboards. I am looking for ideas on how to develop the front end and apps so I have a consistent look and feel, noting the need for write-back. I am happy to buy development tools, but do not want to buy a user based presentation tool.

Any thoughts folks?

Thanks

John

Sighurd
Posts: 30
Joined: Mon Oct 03, 2011 9:18 pm
OLAP Product: TM1
Version: 10.2.2fp6
Excel Version: 2016

Re: Web Dashboards via REST API

Post by Sighurd » Thu Aug 16, 2018 8:37 am

If I understand your idea correctly, then Cubewise thinks it's a great idea, and they developed a thing called 'Canvas'. Of course it is not freely available, so if you create smth similar and free, you'll make a lot of people happy.

jv_oz
Posts: 9
Joined: Fri Oct 13, 2017 12:44 pm
OLAP Product: TM1
Version: PA 2.0.2
Excel Version: 2016 64 bit

Re: Web Dashboards via REST API

Post by jv_oz » Thu Aug 16, 2018 8:53 am

Hello @sighurd, well yes and probably more, no. This will not be an end user tool, it will be coded fixed dashboards as the front end of a web based application.

David Usherwood
Site Admin
Posts: 1330
Joined: Wed May 28, 2008 9:09 am

Re: Web Dashboards via REST API

Post by David Usherwood » Thu Aug 16, 2018 12:01 pm

Why not just use PAW?

jv_oz
Posts: 9
Joined: Fri Oct 13, 2017 12:44 pm
OLAP Product: TM1
Version: PA 2.0.2
Excel Version: 2016 64 bit

Re: Web Dashboards via REST API

Post by jv_oz » Thu Aug 16, 2018 12:12 pm

I thought of that @DavidUsherwood, but PAW won't give the fine granular control I need to create the web pages or apps. Thanks for the thoughts though!

User avatar
tomok
MVP
Posts: 2474
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Web Dashboards via REST API

Post by tomok » Thu Aug 16, 2018 2:57 pm

Since what you will be doing is agnostic as to the data source I'm sure there are plenty of dashboarding toolkits that can deal with data in JSON format. Have you tried Googling that? If you are somewhat ambitious and have some web development experience there is always jQuery and jQueryMobile. Although those aren't specifically for dashboarding there are tons of third party add-ons that do it.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Post Reply