Home  /  Application Development: Analytics Options  /  Using the Analyzer  /  Working with Pivot Tables

Using the Analyzer
Working with Pivot Tables
[Back]  [Next] 
InterSystems: The power behind what matters   

This chapter discusses how to work with pivot tables. It discusses the following topics:
Also see Accessing the Samples Shown in This Book,” in the first chapter.
Opening a Saved Pivot Table
To open a saved pivot table:
  1. Click Open. Or click Menu > Open.
    The system displays a dialog box, which shows names of folders and of pivot tables that are not in any folders.
  2. Optionally click the name of a folder.
    The dialog box then shows the contents of that folder.
    Repeat as necessary if your folders are nested.
  3. Click the name of the pivot table you want to open.
  4. Click Go.
The system closes the dialog box and then displays the selected pivot table in the Analyzer.
In most cases, the underlying query is executed automatically. If it is not, click the Refresh button . See the next topic.
Disabling and Enabling Auto-Execution
By default, when you make any change to the pivot table, the Analyzer re-executes the query and redisplays the results. You can disable this auto-execution. To do so, clear the Auto-execute option on the toolbar.
Later, to enable auto-execution, select the Auto-execute option.
If you disable auto-execution and save the pivot table, that change is saved as part of the pivot table definition and affects the behavior of any dashboards that use the pivot table. Therefore, you should be careful to make this change and save it only if you do not want the pivot table to run automatically in dashboards. Be sure to include a refresh control in any widget that displays this pivot table.
Canceling a Running Query
While the Analyzer is executing a query, you can cancel it. To do so, click the Cancel Query button .
Exporting Data to Microsoft Excel
You can export data to Microsoft Excel from a pivot table widget, but not from other types of widgets. To do so, click the Export to Excel button in the widget.
The system then generates an Excel file that contains all the data currently displayed in the widget. The file has the name %DeepSee.UI.MDXExcel.zen.xls, %DeepSee.UI.MDXExcel.zen-1.xls, or similar. Your browser then does one of the following, depending on your operating system, the configured file types on your machine, your browser, and your browser settings:
When you export to Excel, note that it is not possible to export more than 250000 rows. Also, if the cube is based on a data connector that uses an external table, there is a limit of 1000 rows in the listing.
If no numeric formatting is specified, any numbers are formatted as integers by default. (The actual values are available in Excel, and you can change the formatting as needed to display them appropriately). If numeric formatting is specified in the model or in the pivot table definition, that formatting is used in Excel.
Printing a Pivot Table
To print a pivot table from the Analyzer, click the Print button . The system generates a .pdf file and opens it in your default browser. You can then use options in the browser to print the file or to download it, for printing later.
Note that if you download the file, the browser saves the file to the default download directory for that browser; there is no mechanism to specify a different location.
Also see Specifying the Print Settings,” earlier in this book.
Requirements for Printing
When a user invokes the Print option, InterSystems IRIS™ uses Java to call out to a third-party PDF rendering tool. This means that Java (or specifically JRE, Java Runtime Executable) is required on the user’s machine. For information on the requirements, see the appendix Configuring InterSystems IRIS for PDF Output.”
Sending Email
You can send email that contains a link to the pivot table, if your system is configured for this. To do so:
  1. Open a pivot table that contains the data about which you want to send a message.
  2. If this option is not present, then your system is not configured to support email.
  3. The system then does one of the following:
Displaying the Pivot Table as a Chart
By default, the Analyzer displays the results in table format. You can use the buttons in the upper left to switch to other formats.
To display the results as a chart, click the Display As Chart button . For example:
To display the results as a table and chart, click the Display As Table and Chart button . For example:
To display the results as a table, click the Display As Table button .
If you click the Chart Options button , the Analyzer displays the following page:
Here you can do the following:
For information on the chart types, see Available Chart Types in the chapter Adding Chart Widgets in Creating Dashboards.
Deleting a Pivot Table
To delete a pivot table in the Analyzer, click Delete.
When you delete a pivot table, the system moves it into a folder named $TRASH. Or, if the pivot table is already in a folder, then $TRASH/ is prepended to the folder name. In either case, the pivot table is no longer visible in the web-based interfaces.