Category Archives: Planning Analytics

TM1 and Excel Dates No Longer in Conflict!

TM1 and Excel can now share the same serial date system by the use of UseExcelSerialDate=T in your tm1s.cfg file. Here is the details on this development in Planning Analytics. This means that day number 1 is 1-Jan-1900 in both systems.

How to Install Planning the Analytics for Excel (PAX) Add-in to Excel

How to install IBM Planning Analytics for Excel (PAX) onto a users PC. Detailed instructions with screenshots.

Errors when Connecting to Planning Analytics for Excel/CAFE

Launching CAFE or Planning Analytics for Excel (PAX) can cause errors if the PC is not configured to conform to IBM’s supported environment. Here we go through how to get it all sorted!

Data Export Tool Review – Flyspeed

Ever needed to create a text file from a data source and you have no tools available to interrogate it? We are doing a cloud Planning Analytics project for a client where they are using an ERP called Finance Plus over a database called Visual Foxpro. Mmmm, I hear you read – why is this relevant for me? Well, Visual Foxpro is a very close relative of dBase – a … Continue Reading

Planning Analytics Supported Environment

Updated April 2018 – with supported environment for Planning Analytics Local v 2.0.4 and Windows Server 2016 We are about to start a new project with a client where they will be using Planning Analytics local (i.e. the new version of on premise TM1). They have asked about the server specifications and what needs to be installed. IBM have a great tool that gives all this information, but it can … Continue Reading

How to Create a Secure Gateway for Planning Analytics

There are a couple of elements that must be established to make the secure gateway work. There are server side and local side requirements. This post deals with what has to be done on the IBM server so you can connect it to your local data. For instructions on establishing the local side of the connection, please see this post. Server Side Configuration In the Welcome Kit from IBM, there is a … Continue Reading

IBM Planning Analytics Review

Last week on the Infocube website we published a review of IBM Planning Analytics, otherwise known as hosted TM1, or TM1 in the Cloud, or SaaS TM1.  We covered things like: What is Planning Analytics Using Perspectives and Guided Exploration with Planning Analytics Visualisations Uploading Data and Security Why would you use Planning Analytics Inclusion of Cognos BI Licencing for Existing TM1 Users Where to from here We think it is … Continue Reading