Orientation to the Analyzer and Mini Analyzer

Orientation to the Analyzer and Mini Analyzer

This section provides an orientation to the Analyzer and Mini Analyzer. First, consider the upper part of the Analyzer page (which is not included in the Mini Analyzer):

The key options here are as follows:

• Menu — This drop-down menu provides options to open and save pivot tables.

• Home — This link accesses the User Portal.

• Analytics — This link accesses other Analytics tools.

• Analyzer — This link redisplays the Analyzer. This is useful if there have been changes to the definition of the subject area.

• Namespace — The displayed namespace name is a link that lets you switch to another InterSystems IRIS namespace.

• View — These buttons switch the pivot table display to a chart format or to a table-and-chart format.

• New — This button lets you create a new pivot table.

• Open, Save, and Save As — These buttons let you open and save pivot tables.

• Delete — This button lets you delete the current pivot table.

• Auto-execute — This check box lets you control whether the system automatically executes the pivot table.

• Preview Mode — This check box enables Preview Mode. If Preview Mode is enabled, any sets involved in a CROSSJOIN are truncated using the HEAD function. If truncation occurs, a preview pivot table is displayed in the Analyzer. You can use the Show All button to display full results without affecting the Preview Mode setting.

The upper left corner displays the name of the currently selected subject area (in this case, DemoMDX) or the pivot table that you currently editing, if any.

The rest of the page is visible in both the Analyzer and the Mini Analyzer. The following subsections discuss the Model Contents pane, the Pivot Builder area, and the Pivot Preview area. The final subsection discusses how the Mini Analyzer is different from the full Analyzer.

Model Contents Pane

Both the Analyzer and the Mini Analyzer include the Model Contents pane on the left. This area lists the contents of the subject area that you are currently viewing:

See Getting Familiar with a Subject Area for more detail.

Tip:

During development, you may find it necessary to reload the model if you have made changes in the Architect or Studio. To reload the model, click the Refresh button in this area. Note that this does not rerun the pivot table; it affects only the model as shown in this area.

You can resize this area. To do so, drag the vertical divider on the right edge of this area.

Pivot Builder Area

To the right of the Model Contents pane, both the Analyzer and the Mini Analyzer include the Pivot Builder area, where you define a pivot table:

You can vertically resize this area. To do so, drag the horizontal divider on the bottom edge of this area. You can also horizontally resize each of the boxes; to do so, drag the dividers between boxes.

Pivot Preview Area

Both the Analyzer and the Mini Analyzer include the Pivot Preview area, which displays a preview of the actual pivot table:

The bottom area looks like this:

Cells displays the number of cells currently selected (or the total number of cells on the page if there is no selection). Total displays the total value of all the selected cells (or of all the cells on the page if there is no selection).

If there is too much data to display on the screen, the lower right corner displays buttons for paging through the results.

You can resize this area. To do so, drag the horizontal divider on the top edge of this area.