Introduction to the Analyzer
This chapter introduces the DeepSee Analyzer. It discusses the following topics:
Be sure to consult the online InterSystems Supported Platforms document for this release for information on system requirements for DeepSee.
You can access the Analyzer from the InterSystems launcher or from the DeepSee User Portal; for information on the Portal, see the DeepSee End User Guide.
The Analyzer enables you to create pivot tables, which display aggregated data. Each pivot table is based upon a subject area or a cube. (In the Analyzer, the terms subject area and cube are equivalent to each other; this book uses the term subject area.) When you access the Analyzer, you must choose the subject area to work with. The Analyzer then displays the elements defined in that subject area, which you drag and drop to create pivot tables.
Pivot tables are central to InterSystems DeepSee; they select and aggregate data. The following figure shows an example pivot table that shows the number of patients and the average allergy count per patient, grouped by age and gender.
A level is used to group the source data. A level has members. Each member, in turn, corresponds to a specific set of records in the source data. For example, the
Age Grouplevel has the members
Genderlevel has the members
A measure is a value displayed in the body of the pivot table; it is based on values in the source data. For a given context, a measure aggregates the values for all applicable source records and represents them with a single value. For example, the measure
Patient Countis the number of patients, and the measure
Avg Allergy Countis the average number of allergies per patient.
The preceding example shows a preview of a pivot table within the Analyzer, which provides a large set of tools for modifying the pivot table, exporting to Microsoft Excel, toggling to a chart format, and so on.
To access the Analyzer:
Click the InterSystems Launcher and then click Management Portal.Depending on your security, you may be prompted to log in with a Caché username and password.
Switch to the appropriate namespace as follows:
Click the namespace.
Select DeepSee > Analyzer.If you see the messageSelect a Subject Area to Display, do the following:
Click the Change button or click the Select Subject Area link.
Click the name of the subject area.
Or, you can access the Analyzer from the DeepSee User Portal, as follows:
Click Menu > Analyzer.
Click the < button at the left side of the User Portal, click Add, and then click Add Pivot.
Click the name of a pivot table in the User Portal. This opens that pivot table in edit mode, within the Analyzer.
To access the Mini Analyzer, you must first display a suitable dashboard. Not all dashboards provide access to the Mini Analyzer.
If a dashboard displays the Mini Analyzer button in a widget, click that button, and the system then opens the current pivot table in the Mini Analyzer.
The Mini Analyzer includes only the options that let you make local changes to the pivot table as displayed in this widget. The changes do not affect other widgets, other dashboards, or other users.
This section provides an orientation to the areas of 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.
DeepSee — This link accesses other DeepSee tools.
Analyzer — This link redisplays the Analyzer. This is useful if there have been changes to the definition of the subject area.
Switch — This link (next to the namespace name) lets you switch to another Caché 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 DeepSee automatically executes the pivot table.
actions — This drop-down list lets you perform actions. This is included only if the cube defines actions. Note that when you invoke actions this way, DeepSee supports only a subset of the only client-side commands; other client-side commands are ignored. For details, see the DeepSee Implementation Guide.
The title below Menu displays the name of the currently selected subject area (which is
HoleFoods Salesin this case) 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.
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:
This area lists the contents of the subject area that you are currently viewing. The next chapter discusses this area in more detail.
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 button 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.
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 resize this area. To do so, drag the horizontal divider on the bottom edge of this area. You can also resize the four boxes shown in this area; to do so, drag the divider between boxes.
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:
The Cells number displays the number of cells that are currently selected (or the total number of cells on the page if there is no selection). The Total number 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 that you can use to page through the results.
You can resize this area. To do so, drag the horizontal divider on the top edge of this area.
The Mini Analyzer is similar to the full Analyzer but has two key differences:
The Mini Analyzer does not provide options that enable you to create a new pivot table.That is, you can only make changes to the currently displayed pivot table.
The changes are visible only to yourself. Other users are unaffected.
For information on accessing the Mini Analyzer, see the previous topic.
To display an existing pivot table, do either of the following:
Click Open, expand folders as needed, select a pivot table, and click OK.
Select Pivots in the Model Contents area. Then expand folders as needed and select a pivot table.
In most cases, DeepSee immediately runs the query defined by the pivot table and then displays the results. If the Auto-execute option is off, however, DeepSee does not do so. In such cases, click the Refresh button in the Pivot Builder area. DeepSee then runs the query and displays the table.
To exit the Analyzer and return to the User Portal, click Home. Any unsaved changes are discarded.
To exit the Mini Analyzer and return to the dashboard from which you started, click either OK or Cancel. The OK option saves your changes, and the Cancel option discards them. Or click Reset to remove any changes created in the Mini Analyzer, and then click OK.
When you create a pivot table in the Analyzer, its definition is visible in the Studio Workspace window, within the Other folder. For example:
A pivot table definition is not a class definition but can be copied and pasted into a special container class if needed; this container class can contain multiple pivot tables and other items. For details, see “Packaging DeepSee Elements into Classes” in the DeepSee Implementation Guide.