Excel Reports

Excel Reports
johnv

How to Take a Snapshot in Planning Analytics for Excel

Here is how to create a snapshot of a TM1 report in Planning Analytics for Excel – PAX. This essentially does a copy, paste special, values on the TM1 formulae only, leaving all your Excel formulae untouched. It is very useful for creating a version of a TM1 report that is disconnected from the underlying TM1 data.

Read More »
Administration
johnv

How to Use Excel Dates as Serial Dates in TM1

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.

Read More »
DBRW Example
Dynamic Reports
johnv

DBRW TM1 Excel Syntax and Use

Using DBRW with TM1 in both Perspectives and Planning Analytics for Excel based reports to display the contents of a specific intersection of a TM1 cube.

Read More »
Dynamic Reports
Ben Hill

TM1 Perspectives Excel-based Report Methods

Here is another minor extract from TM1 Tutorials.com training material. We talk through the common sustainable reporting methodologies within TM1 Perspectives for Microsoft Excel. These being: Perspectives Reports This isn’t

Read More »

Log In