Advanced Dataset Builder to Find Hidden Entities and Relationships in Sentinel Visualizer

Advanced Dataset Builder Wizard

The Advanced Dataset Builder is a Wizard that helps you find the data you want based on how entities and relationships are linked to each other (or not), and specific criteria for entities and/or relationships. It is a powerful way to pinpoint hidden relationships among your entities. It is launched from the Search menu or from the Dataset Builder. Depending on your selections, it has up to four pages.

All Data Selection Advanced Dataset Builder

Initial Options

The Wizard offers three sets of options to select and display the data you want from your database.

Filter Options

Specify whether you want to filter for specific entities and/or relationships.

Display Options

Specify the requirements between the entities and relationships that pass the filter. For Relationships passing the filter, Add Associated Entity adds back the entities excluded by the Entity Filter.

Result Options

Preview the results in lists or skip that step and display them on the Visualizer.

Select the Data

In addition to filtering entities and relationships for their specific characteristics, choose how they are related or not related to each other. Depending on your choices, a different set of data is retrieved. The Wizard displays examples of the 15 available combinations:

Option 1: All Data

Get all the data without filters. Includes linked and unlinked entities.

Option 2: Only Linked Entities

Get all the entities that are linked to other entities. Entities without relationships are excluded.

Option 3: Only Unlinked Entities

Get all the entities that are not linked to other entities. Entities with relationships are excluded.

Option 4: Filter Entities

Filter entities (next Wizard page) to select the entities you want. Includes linked and unlinked entities.

Option 5: Filter for Linked Entities

Filter entities (next Wizard page) to select the entities you want that are linked to other entities.

Option 6: Filter for Unlinked Entities

Filter entities (next Wizard page) to select the entities you want that are not linked to other entities.

Option 7: Filter Relationships

Filter relationships (next Wizard page) to select the relationships you want. Includes linked and unlinked entities.

Option 8: Filter Relationships for Linked Entities

Filter relationships (next Wizard page) to select the relationships you want for entities linked to other entities.

Option 9: Filter Relationships for Unlinked Entities

Filter relationships (next Wizard page) to select the relationships you want, then show entities not linked to other entities.

Option 10: Filter Entities and Relationships

Filter entities and Relationships (next two Wizard pages) to show all entities and relationships passing each filter.

Option 11: Filter Entities and Relationships then Add Associated Entities

Filter entities and relationships (next two Wizard pages). For relationships passing the filter, include its entities even if it is excluded by the entity filter.

Option 12: Filter Entities and Relationships for Entities with Relationships

Filter entities and relationships (next two Wizard pages) to only include entities with relationships that pass the relationship filter

Filter Entities and Relationships with Associated Entities

Option 13: Filter Entities and Relationships for Entities with Relationships, the Add Associated Entities

Filter entities and relationships (next two Wizard pages) to only include entities with relationships. For relationships passing the filter, include its entities even if it is excluded by the entity filter.

Option 14: Filter Entities and Relationships for Linked Entities

Filter entities and relationships (next two Wizard pages) for linked entities.

Option 15: Filter Entities and Relationships for Unlinked Entities

Filter entities and relationships, and display entities that are not linked to other entities after the filter is applied.

Entity Filter

If Filter Entities is selected, the Entity Filter page appears. Many options appear to select the entities you want based on their type and many other fields.

Entity Filter: General Tab

Specify entity name, types, values, and ranges for numeric and date fields. The [Retrieve Ranges] button fills the minimum and maximum values for the numeric and date values. A quick way to understand the range of values across all your entities.

Entity Filter: Metadata / Lookups Tab

Select entity metadata and other lookup values.
Up to 3 metadata values can be searched using AND or OR logic.

Relationship Filter

If Filter Relationships is selected, the Relationship Filter page appears. Many options appear to select the relationships you want based on their type and many other fields.

Relationship Filter: General Tab

Specify entities, relationship types, values, and ranges for numeric and date fields. The [Retrieve Ranges] button fills the minimum and maximum values for the numeric and date values. A quick way to understand the range of values across all your relationships.

Relationship Filter: Metadata / Lookups Tab

Select relationship metadata and other lookup values.
Up to 3 metadata values can be searched using AND or OR logic.

Preview Results

The Results Preview lists each entity and relationship that passed the Wizard with options to send them to Visualizer, view them in detail, export to Excel, and more.

If Document Contents were searched, the documents containing the search text are listed on its tab.

Send to Visualizer Diagram

The Visualizer diagram displays your results in a Link Chart showing the links between your entities and relationships. A variety of options are available to add more data and perform analysis.

Example of color gradients on entities and relationships based on their relative values.

Link Analysis Details

Advanced Dataset Builder