Date Function in TM1: Syntax and Use

The Date Function in TM1 converts a serial date from a number to a string. For example Date(13947 , 1); will return the string ‘1998-03-09’.

This entry was posted in Rule Functions, TI Functions and tagged Date. Bookmark the permalink. | Tagged Date | Leave a comment

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 Create a List Report using a TM1 Active Form

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.

This entry was posted in Active Forms, Excel, Perspectives and tagged Active Form, Excel, Perspectives, TM1 Perspectives. Bookmark the permalink. | Tagged Active Form, Excel, Perspectives, TM1 Perspectives | Leave a comment

Changing Element Order in a TM1 Dimension

How to set the order of elements in a dimension in TM1, either manually via the Dimension Editor, automatically via TM1 Server Explorer or within a Turbo Integrator process – and why you should be very careful when using it!

This entry was posted in Elements and tagged Dimension Editor, Dimension Maintenance, dimension order, DimensionSortOrder, Element. Bookmark the permalink. | Tagged Dimension Editor, Dimension Maintenance, dimension order, DimensionSortOrder, Element | Leave a comment

Setting Dimension Order for a TM1 Cube

Dimension order within cubes in TM1 is important not only for performance, but also for usability. When should you set the order for usability and when for performance? And how do you optimise the dimension order for performance? All these questions and more are addressed in this post from ExploringTM1.

This entry was posted in Cognos BI, Cubes, Dimensions, Performance and tagged Cognos BI, dimension order, dimensions, perfomance, TM1 Performance. Bookmark the permalink. | Tagged Cognos BI, dimension order, dimensions, perfomance, TM1 Performance | Leave a comment

TM1 Training and Planning Analytics Training: All the Options

What are the options for TM1 training? Who are the providers for training in TM1? Do I have to sit in classrooms? Is there virtual training available for TM1? Can I get TM1 coaching? All these questions are answered in this explanation of how the TM1 training market works.

This entry was posted in Training, Training Material and tagged Planning Analytics Training, TM1 Training, Training. Bookmark the permalink. | Tagged Planning Analytics Training, TM1 Training, Training | 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

Foreign Exchange (FX) Translation in TM1

Simple foreign exchange translation method for use in TM1. Convert multiple currencies to multiple currencies easily using a simple FX rates cube and lookup of a cost centre or entity.

This entry was posted in Rule Examples and tagged currencies, foreign exchange, fx. Bookmark the permalink. | Tagged currencies, foreign exchange, fx | 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

Date and Time Functions in TM1 10.2

Manipulating dates and times in TM1 has always been horrible. Here we discuss the time manipulation methods available from TM1 v10.2 onwards. These include NewDateFormatter, FormatDate and ParseDate. With them you can even change time from one time zone to another.

This entry was posted in TI Functions, TM1 10.2 and tagged FormatDate, NewDateFormatter, ParseDate, Time, Turbo Integrator. Bookmark the permalink. | Tagged FormatDate, NewDateFormatter, ParseDate, Time, Turbo Integrator | Leave a comment