Working with Data

The Get Data intent allows you to request data for multiple members in a single utterance. You can also view information in a table format and expand the members to view the details with ease. Additionally, with the Pivot intent you can add or remove dimensions and change the structure of the table.

Scenario for Working with Get Data

Here is an example of how you can retrieve information when you work with get data.

1. Enter get data. The assistant displays the options for the current POV.
   
   
   
   
2. If you want to view information for multiple members such as January, February, and March, enter what is the Net Income Basic data for Jan, Feb, and Mar.
   
   
   
   
3. If you want to change a member of an account with multiple members in the same table, enter get data for Cash Flow from Operating Activities and Net Income Basic.
   
   
   
   
4. To expand a member to view the details, click Expand Members.
   
   
   
   
5. To change the columns or rows of the members, enter I want to pivot the grid.
   
   
   
   
6. If you want to add dimensions from POV to table, enter I want to pivot the Currency to column.
   
   
   
   
7. If you want to change the dimension from column to row or vice versa, enter I want to pivot Account to row.
   
   
   
   
8. If you want to remove a dimension, enter I want to pivot Period to POV.
   
   
   
   
9. If you want to reset the table, click Reset Data Grid.