Category Archives: Planning Analytics
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 IBM Planning Analytics for Excel (PAX) or Cognos Analysis for Excel (CAFE) onto a client computer and connect to an IBM Cloud version of Planning Analytics (TM1).
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!
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
Updated April 2018 – with supported environment for Planning Analytics Local v 2.0.4. 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 be very large and … Continue Reading
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
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