Create an Exploration View

You can explore data with Exploration Views.

Use Exploration Views to quickly change how you view performance measures, such as revenue or budgeted production costs.

You can compare and manipulate data so that you can better understand relationships between data and the relative importance of individual data items. Whether you want to assess revenue growth or to identify top performers, IBM® Planning Analytics for Microsoft Excel provides the filtering and sorting support you need for exploration and write back.

If you are already comfortable with exploration fundamentals, you may want to refine your Exploration View by using tasks such as manipulating the rows and columns, adding calculations, and sharing the results. For more information, see Nest rows or columns, Add calculated rows and columns, and Publish a workbook to a TM1 Server Application folder. You can also edit data in Exploration Views. For more information, see Edit data.

Note: Worksheets containing an Exploration View can only contain the single Exploration View. Combining other report types in a worksheet containing an Exploration View is not supported.