Category Archives: Perspectives

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

How to Determine the TM1 Perspectives Version Installed

Finding out the version of TM1 Perspectives is easy. TM1 Perspectives is an Excel Addin that gives great functionality for using TM1 information in Excel to create forms and reports that refresh automatically with the latest data from TM1. Here is what you need to do to determine what version of Perspectives you have installed: Navigate to the Program Files/TM1/bin folder. Find the file tm1prc.dll (for Perspectives). Right click on … Continue Reading

This entry was posted in Administration, Perspectives, TM1 Admin and tagged TM1 Perspectives, version. Bookmark the permalink. | Tagged TM1 Perspectives, version | 1 Comment

Connecting to Alternative TM1 Server

If you’re like most of our clients you’ll have both a production and non-production environment for Cognos Express or TM1. It is not real obvious though how you switch servers from, say Production to Development, or Development to Test etc. Well here’s how you can easily change your TM1 login to point to a development, test or production server. Open TM1 Architect or Perspectives If in Perspectives (the Excel add … Continue Reading

This entry was posted in Architect, Perspectives, TM1 Admin. Bookmark the permalink. | Leave a comment