[col span__sm=”12″]


  1. What are the interfaces in PAx and how does it relate to Perspectives
  2. How to log onto the TM1 Server via PAx
  3. How to analyse Cubes
  4. How to find reports created in the Application folder
  5. How to use the set (subset) editor

[divider align=”center” width=”500px”]

To get your knowledge endorsed on PAx by Cubewise EDU, enrol in our training courses here.

Screenshots are based on Excel 2016 + IBM Planning Analytics 2.0.6 / TM1 Server 11.4

[divider align=”center” width=”500px”]

[scroll_to title=”What are the interfaces in PAx and how does it relate to Perspectives” link=”interfacemapping”]


What are the interfaces in PAx and how does it relate to Perspectives

PAx contains the same reports provided in Perspectives, as shown in the mapping table below. Not only has the name changed, the interface have changed too. For instance, with the Cube Viewer, there are two interfaces that are similar in PAx. An ‘out of Excel’ interface called the Viewer and one in Excel called Exploration. Both can be used to analyse a Cube. Despite these differences, if a Sliced report was created in Perspectives, it will still work as a Custom Report in PAx. The same also applies to reports that utilise Active Forms.

Quick Report is the newest addition to PAx. Use this type of Excel report to quickly analyse multiple cubes and enhance the report by adding formulas and formatting.

[ux_image id=”19551″]




[col span__sm=”12″]

[divider align=”center” width=”500px”]


[scroll_to title=”How to log onto the TM1 Server via PAx” link=”log”]

How to log onto the TM1 Server via PAx

Excel is the interface for PAx to query the TM1 Server. Here are the steps to add PAx into Excel.

Open Microsoft Excel → select a ‘blank workbook’ → select the ‘IBM Planning Analytics’ ribbon

[ux_image id=”19473″]

If the ribbon ‘IBM Planning Analytics’ does not appear go to ‘File’ → ‘Options’

[ux_image id=”19481″]

[ux_image id=”19485″]

Customize Ribbon → turn on ‘Developer’ → OK

[ux_image id=”19489″]

Go to the ‘Developer’ tab → select ‘COM Add-Ins’ → turn on ‘IBM Framework for Office’ → OK

[ux_image id=”19493″]

Now we are ready to set up our connection to the TM1 Server. From the IBM Planning Analytics ribbon, select ‘Options’

[ux_image id=”19497″]

Select ‘IBM’ in the navigation pane

[ux_image id=”19501″]

Select ‘add’ to create the TM1 connection.

[ux_image id=”19505″]

Choose the datasource type ‘IBM Planning Analytics’ → for the Connection URL, enter the details to the TM1 Server (http://<TM1 Server>:<port number>) → enter a friendly name for the connection → Click ‘Test connection’ → Click ‘Save’

[ux_image id=”19509″]

Once the connection is saved → click on ‘OK’

[ux_image id=”19513″]

Let’s connect to the TM1 Server. Click ‘Connect’ → Select the friendly connection name → select the TM1 Server

[ux_image id=”19518″]

Enter the username and password to access the TM1 Server

[ux_image id=”19523″]


[divider align=”center” width=”500px”]


[scroll_to title=”How to analyse Cubes” link=”analysecubes”]

How to analyse Cubes

Exploration is one of the quickest way to analyse a Cube.

From the task pane find the Cube you want to analyse → right-click on the View → select ‘Exploration’ → select ‘On this sheet’

[ux_image id=”19557″]

In Exploration, dimensions can be stacked and pivoted in the Work Area based on these areas:
1. Row
2. Column
3. Title

[ux_image id=”19565″]

For example, to analyse the Account dimension by Year, all that needs to be done is move the ‘Year’ dimension over to the Row area.

[ux_image id=”19569″]

To save the view so it can be accessed again, click on the ‘save’ button.

[ux_image id=”19573″]

Enter a name for the view and choose if this is for the public (administrators can only do this) or private for yourself.

[ux_image id=”19577″]


[divider align=”center” width=”500px”]


[scroll_to title=”How to find reports created in the Application folder” link=”application”]

How to find reports created in the Application folder

All Excel reports created in Perspectives that have been stored under the Application folder are automatically available in PAx. Here are the steps to find the Application folder.

Go to IBM Planning Analytics → Open

[ux_image id=”19529″]

Double-click on the TM1 Server

[ux_image id=”19533″]

The Application folder is located here.

[ux_image id=”19537″]


[divider align=”center” width=”500px”]


[scroll_to title=”How to use the set (subset) editor” link=”set”]

How to use the set (subset) editor

The Set is the same as Subset in Perspectives. The Set is used to find and return elements to the view. Here is an overview on the Set layout.

[ux_image id=”19582″]

As an example on how to use the Set, let’s find and return all employees under Engineering.

Use the search bar to find the ‘Engineering’ element.

[ux_image id=”19586″]

Right-click on ‘Engineering’ → select ‘Insert member with leaf nodes’

[ux_image id=”19590″]

The ‘Current Set’ pane now contains all leaf elements under ‘Engineering’. To save the Set for future reference, use the ‘save’ button. If you want to return this Set back to the view, select ‘Apply and close’.

[ux_image id=”19594″]


[divider align=”center” width=”500px”]


If you want to learn more about how to use PAx as an end-user, we offer two training courses to upskill your knowledge. Head here to find out more (link).