Create views by using natural language

You can now create views in books with the new Data explorer feature using natural language. The Data explorer feature uses generative AI to analyze your query and matches it to the relevant data in TM1 to recommend views. An explanation for the logic behind the recommendation accompanies each recommended view. You can make changes to the view and add it to the book or insert it as-is.

The initial release of Data explorer is available in English only.
Important: The Data explorer feature is part of the Planning Analytics AI assistant add-on, which requires a separate license purchase; it is not included in a standard Planning Analytics Workspace license. To purchase a license, contact your IBM® sales representative or go directly to your IBM account.
Creating views in the Data explorer is a two-part process:
Analyze cube
For Data explorer to recommend views, you need analyzed cubes. Cube analysis takes place in the modeling workbench, which allows AI to review the structure of a cube and understand the data.
Submit query
Once cube analysis is complete, you can go to a book and enter your query in the Data explorer to get recommended views.

Creating views in Data explorer

Follow these steps to run a cube analysis and then create a view in Data explorer:
  1. In the modeling workbench data tree, go to the cube that you want to analyze.
  2. From the cube's menu, click AI operations > Analyze cube and click Analyze.
    Note:
    • You need to have access to CubeAttributes, DimensionAttributes, and the corresponding SubsetAttributes control cubes.
    • You can check the status of a cube analysis by clicking AI operations > Analyze log.
  3. After the cube analysis completes, go to the book where you want to create the view.
  4. Click AI operations and select Data explorer.
  5. Select the database and analyzed cube with the data that you want to use to create a view.
    Note: If you choose Auto-select for the analyzed cube, the most relevant cube is automatically selected to create a view, based on your query.
  6. Enter your query in natural language. For example, you can enter Show me sales performance trends over the last year or Show me 2024 sales of mobile devices in north america.
  7. Click Submit.

A view generates along with an explanation for the recommended view and the cube that is chosen to generate the view. You can add the view to the book in edit mode.

You can also make certain changes to the view such as switch rows and columns, move dimensions to the context area, edit the set, and change levels.

If there are other analyzed cubes with data that matches your query, they are listed next to Alternative cubes. Click an alternative cube to see a recommended view from that cube.

For more information, see Create views with Data explorer using natural language.