DeepSee Cube Integration (Deprecated Form)
This appendix describes how to use older, deprecated form of integration between iKnow and DeepSee cubes. It discusses the following topics:
This section provides an overview of the older, deprecated form of integration between iKnow and DeepSee cubes.
DeepSee is an analytics engine and reporting platform that is built into Caché in the same way that iKnow is. The primary purpose of DeepSee is to enable you to create interactive dashboards that you can embed on Zen pages or that users can access via the DeepSee User Portal (which is intended for all end users, not just end users of DeepSee).
A DeepSee cube
is a data model that enables you to create DeepSee queries by drag and drop actions. The queries are known as pivot tables
. You create pivot tables so that you can display them on DeepSee dashboards. When the dashboard is displayed, the query is executed.
Each cube is based on a source table. You build a cube, and this process generates a fact table
that has the same number of records as the source table (or possibly fewer if the model skips some records deliberately). The queries use the fact table rather than the source table. DeepSee provides multiple complementary mechanisms to keep the fact table synchronized with the source table.
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.
Using this example as a reference, let us discuss the key terms in DeepSee cubes:
is used to group the records. In this case, we are grouping patients. Each record in the source table corresponds to one patient, as does each record in the fact table.
is a value displayed in the body of the pivot table. It is based on values ultimately taken from the source data. For a given context, a measure aggregates the values for all applicable records and represents them with a single value (typically by summing them).
A cube can also define detail listings
, whose purpose is to display lowest-level data associated with the current context. To access a listing, you select one or more cells and click the Listing button (not shown in the previous picture). DeepSee then displays a table that lists selected fields for all the records used in the current context.
The iKnow/cube integration makes the following assumption: there is a single iKnow source associated with each record of the cube’s source class. That is, the cube serves as additional information about the iKnow sources. (Phrased differently, the iKnow sources contain additional information associated with each record of the cube’s source class.)
The goal is to be able to use DeepSee and iKnow filters interchangeably where possible.
You can use utility methods to do the following tasks:
This section assumes that the cube is defined and has been built. The cube does not need to be modified or rebuilt.
Before you can generate iKnow source metadata fields for a cube:
Load the iKnow sources.
When you do so, make sure that the external ID of each source can be readily associated with a specific record of the source class of the cube.
If you are using a file lister, you might make sure that the file names match the patient identifiers.
If you are using an SQL lister, you might make sure that the IDs of the records match the patient identifiers.
Make sure that the source class of the cube includes a property whose value is the external ID of the corresponding iKnow source.
For example, this class could include a calculated property whose value follows the naming convention established in the preceding step.
Property DocumentId As %String [ Calculated ];
Method DocumentIdGet() As %String
ClassMethod GenerateMDFieldsFromDSDims(domainId As %Integer,
cubeClassName As %String,
ByRef levels = 1,
extIdProperty = "",
killExistingMDFields As %Boolean = 0) As %Status
If you also create iKnow KPIs
in this domain, then you can use DeepSee filters in the KPI, provided that the KPI and the cube are both associated with the same iKnow domain.
To use this mechanism:
This release provides a preliminary version of a utility that generates DeepSee cubes from iKnow engine results. The generated cubes enable you to view entities, entity occurrences, and match results grouped in various ways. With a DeepSee cube, you can perform analysis and exploration via drag and drop actions in the DeepSee Analyzer.
You can use these DeepSee cubes in the same way that you use other DeepSee cubes; you can explore them in the Analyzer, create pivot tables, and add those pivot tables to DeepSee dashboards.
This section describes how to generate and (briefly) how to use DeepSee cubes, given an iKnow domain. It discusses the following topics:
If you can achieve a required result through an existing iKnow query, use that query rather than trying to create an equivalent query with the generated cubes. The iKnow queries are optimized to use internal and precalculated indices and are faster as a consequence.
buildCubes=0) as %Status
is the integer ID of an iKnow domain.
is the package in which to place the generated classes.
The phrase build a cube
refers to the process of populating the structures that the cube uses. This process makes it possible to use the cube.
This section briefly introduces the Analyzer and the generated cubes. To access the Analyzer and display one of these cubes:
Click the Change button
Click the cube name.
For example, the entity occurrence cube provides information about the occurrence of entities in the source documents. The name of this cube ends with EntityOccurrences
. When you view this cube, the left area of the page displays its contents, as follows:
This cube defines one measure, Count
, which counts entity occurrences. This measure is used by default.
This dimension enables you to categorize entity occurrences by entity type. If you expand this folder and the Entity Type
folder within it, the system displays the following:
This dimension enables you to categorize entity occurrences by the source document to which they belong. If you expand this folder, the system displays the following:
If you expand the SourceID
folder, the system displays something like this, depending on your data:
This dimension enables you to categorize entity occurrences by entity value. If you expand this folder and the top-level folders in it, the system displays the following:
If you expand the Entity
folder, the system displays something like this, depending on your data:
The right area of the page looks like this:
The area at the bottom is a simple pivot table. It displays the total value for Count
. In this example, there are 7118 entity occurrences in the domain.
The area above that enables you to create pivot tables. You can drag and drop items from the left to this area, and the system automatically modifies the pivot table. For example, if you drag Entity
(the inner Entity
folder) to the Rows
box, the system displays the following:
This pivot table shows both relations and concepts because we have not applied any filtering. To filter the pivot table to show only concepts:
This immediately updates the display.
Now you might see something like this:
cube defines a detail listing. To access it, select one or more cells and click the Listing button
. (In this example, we click the cell for ancient viruses
.) The system then displays something like the following:
After you process more sources for this iKnow domain, it is not necessary to regenerate the classes but it is necessary to rebuild the DeepSee cubes. It is also necessary to rebuild the cubes in a specific order:
Rebuild the sources cube, which is the cube whose name ends in Sources
Rebuild the other cubes, in any order.
To rebuild a cube, open it in the Architect and click Rebuild
© 1997-2019 InterSystems Corporation, Cambridge, MA