Tag Archives: Excel
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.
Use Active Forms to create dynamic list reports in Excel using TM1 data, that can be zero suppressed and allow users to expand and contract hierarchies.
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!
One of the most common requests for reports is to generate a list of top 10 for a dimension based on TM1 data. This makes sense considering level of data TM1 works best with; this could cover top 10 consumers, customers or top 30 SKUs at one particular outlet or within a brand. There are several ways to achieve that within TM1, the simplest way to do this within a … Continue Reading
Project Methodology Primarily Applies to: Small to Mid Sized implementations of TM1 (3-8 weeks). It’s a widely established practice when scoping a TM1 project to take the legacy Planning Workbooks (where possible) for prior budgets and planning rounds to use as a starting point for company specific business logic and corporate structures. The advantages of this methodology are obvious: Unless there is a corporate initiative to change the methodology for … Continue Reading