Search found 98 matches

by nick_leeson
Thu Oct 26, 2017 3:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1runti on Planning Analytics
Replies: 1
Views: 318

tm1runti on Planning Analytics

Hi All, Hi All, I am getting an error when I am trying to run tm1runti.exe from a Server with a Product Version of 10.2.20700.44 to connect to TM1 Product Version 11.1.00000.30. The error is a generic error one below (TM1 API Error) SystemServerNotFound Server connection failed However when I run sa...
by nick_leeson
Thu Dec 10, 2015 4:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to customize TM1
Replies: 8
Views: 1248

Re: How to customize TM1

For TM1 Web this can be achieved quite easily but changing the various files ( css , png ) etc that contain the splash page. Against the recommendation of IBM (although no official technote that I am aware of ) and our team one of our clients wanted something really cool and was aware of the risks a...
by nick_leeson
Tue Nov 03, 2015 5:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Insight 2015
Replies: 12
Views: 2465

Insight 2015

Hi All,

A very well written summary from Yuri on Insight 2015 http://ykud.com/blog/ibm/insight-2015-recap

Any other feedback

Cheerio
by nick_leeson
Fri Oct 02, 2015 1:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos TM1 as data source in Microsft BI
Replies: 5
Views: 2067

Re: Cognos TM1 as data source in Microsft BI

Power Query natively supports Odata V4 Payload which is the format you will get if you enable REST API on TM1 10.2.2 hence I would rather go down that path. https://support.office.com/en-us/article/What-s-new-in-Power-Query-936b2fca-4168-41ad-bbbd-7b83856b6776?ui=en-US&rs=en-US&ad=US&Ocid=Excel_Soci...
by nick_leeson
Tue Sep 15, 2015 10:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 10.2.2 Fix Pack 4 - Temporary Objects in TI
Replies: 25
Views: 5226

Re: 10.2.2 Fix Pack 4 - Temporary Objects in TI

As of TM1 10.2.2 Fix Pack 4, the SubsetCreate, SubsetCreateByMDX, and ViewCreate TurboIntegrator functions can all create temporary objects. There is no locking associated with a temporary subset or view, as these objects are never saved. This can result in improved performance, because there is no...
by nick_leeson
Mon Sep 14, 2015 1:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help With Cognos TM1 + SAP HANA on AIX
Replies: 9
Views: 1993

Re: Help With Cognos TM1 + SAP HANA on AIX

As was rightly pointed out HDBODBC32 is the SAP HANA ODBC driver and can be setup just like an ordinary ODBC driver. You will need to install the driver on the TM1 Server and pop in the details as you would for any ordinary ODBC driver. If you can connect to the HANA DB then you should be be able co...
by nick_leeson
Fri Sep 11, 2015 12:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help With Cognos TM1 + SAP HANA on AIX
Replies: 9
Views: 1993

Re: Help With Cognos TM1 + SAP HANA on AIX

How are you connecting to HANA from TM1 via ODBC ? or via the the standard ODBC. What is your SQL ? Is it a calculation view ? The larger question is why not go with a more integrated solution for Budgeting and Forecasting if you are already on HANA. :roll: IMHO The way S4/HANA is coming along , I w...
by nick_leeson
Wed Aug 26, 2015 2:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Future of TM1 UIs and APIs (Was TM1 C++ API issue)
Replies: 14
Views: 2990

Re: Future of TM1 APIs (Was TM1 C++ API issue)

There is mention that even the JAVA API which I suspect will not be supported in the next release. https://www.ibm.com/developerworks/comm ... dab0&ps=25


Sorry to hijack this thread OP.
by nick_leeson
Tue Aug 25, 2015 11:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Future of TM1 UIs and APIs (Was TM1 C++ API issue)
Replies: 14
Views: 2990

Future of TM1 UIs and APIs (Was TM1 C++ API issue)

Admin note: Split from this thread . Although not official but there is a statement made by an IBM representative on the web that states that going forward TM1 API will not be supported from the next major release. https://www.ibm.com/developerworks/community/forums/html/topic?id=7309f46c-6ecb-4220...
by nick_leeson
Thu Jun 11, 2015 3:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 web crashes and needs to be restarted
Replies: 13
Views: 5101

Re: TM1 web crashes and needs to be restarted

Log files in TM1Web are located here dir\\webapps\tm1web\WEB-INF\logs. using these logs you could point out the last websheet that was the cause of the crash or the last last slice which tipped the server over.

Good luck !!
by nick_leeson
Thu Jun 04, 2015 1:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 IRR Calc
Replies: 12
Views: 4095

Re: TM1 IRR Calc

Hi, As another option (and in my mind a superior one) we now use java to calculate our IRRs. We trialed these rule rules and a cube/TI combination option and the java results are 100% accurate to excel, and blisteringly fast, compared to other alternatives So, we now have a TI process that generate...
by nick_leeson
Thu May 28, 2015 10:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Turbo Integrator Preview Function
Replies: 8
Views: 1934

Re: Turbo Integrator Preview Function

What about the "Use Unicode" setting in your TI process ?
Is it enabled or disabled ? Also
http://www.tm1forum.com/viewtopic.php?f=3&t=1668&p=8758

This might give you a pointers .
by nick_leeson
Tue May 19, 2015 5:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API is great!
Replies: 9
Views: 5942

Re: TM1 REST API is great!

Sounds very useful, do you have any link to the documentation on this? I only have the IBM page which contains the "classic" API but nothing on REST api and a google search is to broad. Rest API is a great step forward but if you are after EOD , EOM reporting i.e. NO write back with just dashboard ...
by nick_leeson
Wed Feb 25, 2015 5:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Customize Login Page
Replies: 7
Views: 2320

Re: Customize Login Page

Peter I am not sure if this needs to be that complicated. In 10.2. the IBM TM1 Web landing page is called swoosh.png and is located in install_dir\\webapps\tm1web\images\login You can create your own background page suit your purposes but before that speak to IBM make sure the copyright information ...
by nick_leeson
Fri Feb 06, 2015 11:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Custom Diagram URL
Replies: 5
Views: 1947

Re: Custom Diagram URL

Metric's and custom diagram's can be imported into Cognos Insight, I suppose you can import the custom diagram above an image containing a URL which you can send back using Cognos Insight.
The challenge is to make this dynamic.
by nick_leeson
Wed Jan 21, 2015 12:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API ( Any early adopters )
Replies: 52
Views: 20496

Re: TM1 REST API ( Any early adopters )

Have a read through this https://developer.chrome.com/extensions/xhr but I am still confused whether using session id will be enough for you to get REST API working.

Best of luck.
by nick_leeson
Tue Jan 20, 2015 1:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Through XMLA
Replies: 2
Views: 1132

Re: TM1 Through XMLA

Yep with Microstrategy and never again I would advise anybody to do it. IMHO Too Slow and not worth the effort.
by nick_leeson
Tue Jan 20, 2015 1:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API ( Any early adopters )
Replies: 52
Views: 20496

Re: TM1 REST API ( Any early adopters )

I thought your original plan was to use REST API when and what led you down to use websheets in iframe which is probably more trouble than its worth not that REST API is any better. Ever thought of creating a json file and then using jquery / kendo / d3 visualization . Not real time but depending on...
by nick_leeson
Fri Aug 29, 2014 12:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automation of Currency data from the open source into TM1
Replies: 5
Views: 2136

Re: Automation of Currency data from the open source into TM

I am sure there is plenty of ways to skin this cat but from the top of my head !! Option 1 1) Use Powershell to call a Web Service and then load the CSV into TM1. http://blogs.technet.com/b/heyscriptingguy/archive/2009/11/17/hey-scripting-guy-november-17-2009.aspx 2) Fetch Website data into Excel us...
by nick_leeson
Tue Aug 26, 2014 11:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 SDK JavaExtensions ( Any early adopters )
Replies: 9
Views: 4024

Re: TM1 SDK JavaExtensions ( Any early adopters )

Been playing around with REST API and I am nearly there so watch this space.