Strategy One support

Strategy One (formerly MicroStrategy ONE) is a BI application for data modeling, visualization, and analytics that enables users to create, share, and access interactive dashboards based on data from various sources. Dataedo helps Strategy One users enhance data understanding and promote better data governance and management practices.

Catalog and Documentation

Main Strategy One visualization objects which are Dashboards (Dossiers), are imported to Dataedo. This allows users to browse their hierarchical structure that consists of Chapters, Pages, Visualizations, Attributes (with their Forms), and Metrics.

Reports and Datasets are imported with their Attributes and Metrics. Dataedo also supports documentation of Strategy One modeling service by importing Logical Tables with their defined Attributes and Facts. Additionally, information about defined Datasources is represented in Dataedo by Linked Sources. Documents and Cards are currently not supported.

Strategy One connector creates automatic data lineage to enable tracking data flows to visualizations created in the app's pages. Internal column-level lineage is created between Dashboards and Reports, Dashboards and Datasets, Dashboards and Logical Tables, Reports to find out the origin of Attributes and Metrics. External column-level lineage is created between Logical Tables and physical tables from the source database if there is one-to-one correspondence between them which allows tracking the source of the data being transmitted to the modeling service.

Other features include:

• running Data Classification to find potentially sensitive data in Strategy One data fields.
• adding and changing descriptions in Dataedo Portal
• linking Business Glossary entries to any documented Strategy One object
• building lookups for logical tables columns

Connecting to Strategy One

Learn how to connect Dataedo to Strategy One here: Connecting to Strategy One

Connector specification

Supported metadata

Dashboards (Dossiers)

	Imported	Editable
Dashboards (Dossiers)-> Dashboards	✅	✅
Description	✅	✅
Created date	✅	❌
Last modified date	✅	❌
Chapters -> Dashboards(as column subtypes)	✅	✅
Pages -> Sheets	✅	✅
Visualizations -> Visualizations	✅	✅
Attributes -> Attributes	✅	✅
Forms -> Fields	✅	✅
Datatype	✅	❌
Metrics -> Measures	✅	✅
Computed formula	✅	❌

Reports

	Imported	Editable
Reports -> Reports	✅	✅
Description	✅	✅
Created date	✅	❌
Last modified date	✅	❌
Attributes -> Attributes	✅	✅
Forms -> Fields	✅	✅
Datatype	✅	❌
Metrics -> Measures	✅	✅
Computed formula	✅	❌

Datasets

	Imported	Editable
Datasets -> Datasets	✅	✅
Description	✅	✅
Created date	✅	❌
Last modified date	✅	❌
Attributes -> Attributes	✅	✅
Forms -> Fields	✅	✅
Datatype	✅	❌
Metrics -> Measures	✅	✅
Computed formula	✅	❌

Logical tables

	Imported	Editable
Logical tables -> Tables	✅	❌
Created date	✅	❌
Last modified date	✅	❌
Attributes -> Attributes	✅	✅
Forms -> Fields	✅	✅
Datatype	✅	❌
Computed formula	✅	❌
Facts -> Columns	✅	✅
Datatype	✅	❌
Computed formula	✅	❌

Datasources

	Imported	Editable
Datasources -> Linked sources	✅	✅
Connection details	✅	❌

caution

Documents and Cards are currently not imported.

Supported features

Feature	Supported
Data profiling	❌
Data classification	✅
Data lineage	✅
Reference data (import lookups)	❌
Importing from DDL	❌
Generating DDL	❌
FK relationship tester	❌

Data Lineage

Destination	Source	Column level
Dashboard	Report	✅
Dashboard	Dataset	✅
Dashboard	Logical table	✅
Report	Logical table	✅
Logical table	Source table	✅

To learn more about automatic data Lineage in Strategy One visit: Strategy One - Automatic data lineage

Known issues and limitations

• Documents and Cards are currently not imported
• Linked sources are not guaranteed to have automatically assigned source documentation
• Column-level lineage is not created for metrics that reference other metrics.
• If the logical table is created from several tables using a custom query, lineage to it will not be created.
• External lineage for datasets is not supported