Exploring TM1 - a Chartertech Company
Search
Close this search box.

Planning Analytics for Excel Connection to TM1

Here we explain how to create a new connection in Planning Analytics for Excel (PAX) to a TM1 model or server.

What is Planning Analytics for Excel (PAX)?

Planning Analytics for Excel is the Excel add-in from IBM that provides access to TM1 cubes. With it you can do ad hoc exploration, create quick reports, create unlimited length reports and highly customised reports. It replaces the old TM1 Perspectives add-in.

Where does PAX Connect to?

PAX connects to the Planning Analytics Workspace (PAW) server (not the TM1 server). The address for this is https://pawserver.domain.local/.

How to Create a Connection in Planning Analytics for Excel to TM1

1. Open Excel.

2. Ensure the Planning Analytics for Excel add-in is active. You should have the IBM Planning Analytics ribbon available to you in Excel. If you do not have the PAX add-in active, please see this post on activating the Planning Analytics for Excel add-in.

3. Click on the PAX ribbon.

4. Click Connect, New Connection

5. In the Add/Edit Connection dialog box enter the following:

a. Select IBM Planning Analytics as the Datasource type.

b. Enter https://pawserver.domain.local/ as the Connection URL

c. Enter whatever you like as the Friendly name.

6. Then click on Test Connection. You should get a success notification like this:

7. Click Save.

You now have a connection established to TM1. You should not need to repeat this exercise and can use this connection to login to TM1 in future.

  • This field is for validation purposes and should be left unchanged.

Post Sections

Related Posts

John Vaughan

John Vaughan

John is a CPA, MBA and has been a Performance Management consultant for over 25 years. He is the founder of ExploringTM1 and highly regarded for his experience combining financial management with corporate planning, reporting and analysis. He lives in Sydney with his wife, two of his three children, their cat, Freckles, a bunch of chooks and some fish. John is a sports nut, who played rugby until he was 40, started playing football at 54 and loves being outdoors.

Leave a Reply

Your email address will not be published. Required fields are marked *

Log In