Tag 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.

This entry was posted in Planning Analytics, TM1 Admin, tm1s.cfg and tagged Dates, Excel, Planning Analytics, UseExcelSerialDate. Bookmark the permalink. | Tagged Dates, Excel, Planning Analytics, UseExcelSerialDate | Leave a comment

How to Install Planning Analytics for Excel (PAx)

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).

This entry was posted in Excel, Planning Analytics, Planning Analytics Excel and tagged Excel, Excel Addin, Planning Analytics. Bookmark the permalink. | Tagged Excel, Excel Addin, Planning Analytics | Leave a comment

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!

This entry was posted in Errors, Excel, Planning Analytics and tagged Café, Errors, Excel, Excel Addin, PAX, Planning Analytics. Bookmark the permalink. | Tagged Café, Errors, Excel, Excel Addin, PAX, Planning Analytics | 1 Comment

Planning Analytics Supported Environment

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 unwieldy. This post lists the minimum server requirements for Planning Analytics Local. So … Continue Reading

This entry was posted in Installation, Planning Analytics and tagged Installation, Planning Analytics, Server Configuration. Bookmark the permalink. | Tagged Installation, Planning Analytics, Server Configuration | Leave a comment

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

This entry was posted in IBM Cognos TM1, Planning Analytics and tagged IBM Cognos TM1, Planning Analytics. Bookmark the permalink. | Tagged IBM Cognos TM1, Planning Analytics | Leave a comment