MicroStrategy operating model

Overview and diagram view

When you integrate MicroStrategy, Collibra Data Lineage creates new MicroStrategy assets and relations in Data Catalog. You can see them on the asset page overview or visualize them in a diagram.

Note

The assets have the same names as their corresponding data objects in MicroStrategy.
Asset types are only created if you have all specific MicroStrategy and Data Catalog permissions.
All MicroStrategy assets are created in the same domain.
Relations that were manually created between MicroStrategy assets and other assets via a relation type in the MicroStrategy operating model, are deleted after synchronizing the MicroStrategy metadata.

The following image shows the relations between MicroStrategy asset types.

Note Currently, relations cannot be created:

Between MicroStrategy Documents and MicroStrategy Dossiers.
Between MicroStrategy Documents and MicroStrategy Reports.

Harvested metadata per asset type

This table shows the harvested MicroStrategy metadata for assets of each MicroStrategy asset type, assuming you have the necessary subscriptions and configurations for a full ingestion.

Important To access MicroStrategy data, you have to use the In-memory Dataset connection method in MicroStrategy, not the Live Connect connection method. If the data is not stored in memory, the MicroStrategy APIs can't access it.

Note The following folders in MicroStrategy are not included in the ingestion:

Object Templates
System Objects
Version Update History

Asset type	Harvested MicroStrategy metadata in Data Catalog	Public ID
MicroStrategy Data Attribute Public ID: MicroStrategyDataAttribute	Description	Description
	Source Type	SourceType
	Technical Data Type	TechnicalDataType
	Data Element targets / sources Data Element	DataElementTargetsDataElement
	Data Entity contains / is part of Data Attribute	DataEntityContainsDataAttribute
	Data Attribute used in / uses Report	ReportUsesDataAttribute
MicroStrategy Data Entity Public ID: MicroStrategyDataEntity	Description	Description
	Source Type	SourceType
	Data Entity contains / is part of Data Attribute	DataEntityContainsDataAttribute
	Data Entity is part of / contains Data Model	DataEntityIsPartOfDataModel
	Data Asset is source for / sources BI Report	DataAssetIsSourceForBIReport
MicroStrategy Data Model Public ID: MicroStrategyDataModel Note If the data model is embedded in the project, the data model inherits the name of the project.	Description	Description
	Certified	Certified
	Owner in source The only harvested metadata are email addresses.	OwnerInSource
	Source Type	SourceType
	BI Folder contains / contained in Data Asset	BIFolderContainsDataAsset
	Data Asset is source for / source BI Report	DataAssetIsSourceForBIReport
	Data Model contains / is part of Data Entity	DataEntityIsPartOfDataModel
MicroStrategy Document Public ID: MicroStrategyDocument	Description	Description
	Certified	Certified
	Owner in source The only harvested metadata are email addresses.	OwnerInSource
	URL Note You can specify the platform on which you run MicroStrategy, in your lineage harvester configuration file, to ensure the correct URL.	Url
	Business Dimension groups / is grouped into Report	BusinessDimensionGroupsReport
	BI Report contains / contained in BI Data Model	BIReportContainsBIDataModel
MicroStrategy Dossier Public ID: MicroStrategyDossier	Description	Description
	Certified	Certified
	Owner in source The only harvested metadata are email addresses.	OwnerInSource
	Business Dimension groups / is grouped into Report	BusinessDimensionGroupsReport
	Report groups / is grouped into Report	ReportGroupsReport
	Report uses / used in Report	ReportUsesReport
	BI Report source / is source for Data Asset	DataAssetIsSourceForBIReport
MicroStrategy Folder Public ID: MicroStrategyFolder	Description	Description
	BI Folder assembles / is assembled in BI Folder	BIFolderAssemblesBIFolder
	Business Dimension groups / is grouped into Report	BusinessDimensionGroupsReport
	BI Folder contains / contained in Data Asset	BIFolderContainsDataAsset
MicroStrategy Project Public ID: MicroStrategyProject	Description	Description
	BI Folder assembles / is assembled in BI Folder	BIFolderAssemblesBIFolder
	Server hosts / is hosted in Business Dimension	ServerHostsBusinessDimension
MicroStrategy Report Public ID: MicroStrategyReport	Description	Description
	Certified	Certified
	URL	Url
	Owner in source The only harvested metadata are email addresses.	OwnerInSource
	Report groups / is grouped into Report	ReportGroupsReport
	Business Dimension groups / is grouped into Report	BusinessDimensionGroupsReport
	Data Asset is source for / sources BI Report	DataAssetIsSourceForBIReport
MicroStrategy Server Public ID: MicroStrategyServer	Server hosts / is hosted in Business Dimension	ServerHostsBusinessDimension

Recommended hierarchy within a domain

You can enable hierarchies for the domain in which your MicroStrategy assets are ingested. Doing so makes it easier to understand the relation between your MicroStrategy assets, when viewing the assets on the domain page.

Follow these steps to enable and configure the recommended hierarchy.

Steps

Open the domain page of the relevant BI Catalog domain.
On the content toolbar, click .
The Configure Hierarchy dialog box appears.
Select Enable Hierarchy.
Select Single path.
Start typing and select each of the following relation types:
- Server hosts Business Dimension
- BI Folder assembles BI Folder
- Business Dimension groups Report
- BI Report source Data Asset
- BI Folder contains Data Asset
- Data Model contains Data Entity
- Data Entity contains Data Attribute
Click Apply.

Note

In an asset view, if any asset is deleted, for example via synchronization or manual deletion, the view is recreated and the hierarchy is lost. In this case, you can again enable and configure the recommended hierarchy.
When viewing the hierarchy for a community or domain, if the parent of a node that is in the community or domain belongs to a different community or domain, that node is not shown in the hierarchy.

Create a MicroStrategy operating model diagram view

You can create a MicroStrategy-specific diagram view, to visualize the operating model. The following procedure provides instruction on how to quickly create a new diagram view by copying and pasting the JSON code in the diagram view text editor.

Steps

Open the asset page.
Click the Diagram tab.
The diagram is shown in the default diagram view.
Click to add a new view.
Select the Text option below the diagram view name.
The diagram view text editor is shown.
Copy the code from the Show JSON code section below and paste it in the diagram view text editor.
Click Save.
Edit the name and description of the diagram view as needed.

Show JSON code

{
    "nodes": [
        {
            "id": "MicroStrategy Report",
            "type": {
                "id": "00000000-0000-0000-0000-100000000044"
            }
        },
        {
            "id": "MicroStrategy Data Attribute",
            "type": {
                "id": "00000000-0000-0000-0000-100000000047"
            },
            "editorSettings": {
                "edgePropsExpanded": true
            }
        },
        {
            "id": "BI Folder",
            "type": {
                "id": "00000000-0000-0000-0000-090000000002"
            },
            "display": "expanded"
        },
        {
            "id": "MicroStrategy Dossier",
            "type": {
                "id": "00000000-0000-0000-0000-100000000043"
            }
        },
        {
            "id": "MicroStrategy Document",
            "type": {
                "id": "00000000-0000-0000-0000-100000000049"
            }
        },
        {
            "id": "BI Report Attribute",
            "type": {
                "id": "00000000-0000-0000-0000-090000000004"
            }
        },
        {
            "id": "BI Data Entity",
            "type": {
                "id": "00000000-0000-0000-0000-090000000007"
            }
        },
        {
            "id": "BI Data Model",
            "type": {
                "id": "00000000-0000-0000-0000-090000000008"
            }
        },
        {
            "id": "Column",
            "type": {
                "id": "00000000-0000-0000-0000-000000031008"
            }
        },
        {
            "id": "Table",
            "type": {
                "id": "00000000-0000-0000-0000-000000031007"
            }
        },
        {
            "id": "Schema",
            "type": {
                "id": "00000000-0000-0000-0001-000400000002"
            }
        },
        {
            "id": "Database",
            "type": {
                "id": "00000000-0000-0000-0000-000000031006"
            }
        },
        {
            "id": "Business Term",
            "type": {
                "id": "00000000-0000-0000-0000-000000011001"
            }
        }
    ],
    "edges": [
        {
            "from": "MicroStrategy Report",
            "to": "MicroStrategy Data Attribute",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000021"
            },
            "roleDirection": true
        },
        {
            "from": "BI Folder",
            "to": "MicroStrategy Report",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000002"
            },
            "roleDirection": true
        },
        {
            "from": "BI Folder",
            "to": "BI Folder",
            "label": "",
            "style": "boxing",
            "type": {
                "id": "00000000-0000-0000-0000-120000000001"
            },
            "roleDirection": true
        },
        {
            "from": "BI Folder",
            "to": "MicroStrategy Dossier",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000002"
            },
            "roleDirection": true
        },
        {
            "from": "BI Folder",
            "to": "MicroStrategy Document",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000002"
            },
            "roleDirection": true
        },
        {
            "from": "MicroStrategy Dossier",
            "to": "BI Report Attribute",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-000000007058"
            },
            "roleDirection": false
        },
        {
            "from": "MicroStrategy Document",
            "to": "BI Report Attribute",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-000000007058"
            },
            "roleDirection": false
        },
        {
            "from": "BI Report Attribute",
            "to": "MicroStrategy Data Attribute",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000010"
            },
            "roleDirection": true
        },
        {
            "from": "BI Data Entity",
            "to": "MicroStrategy Data Attribute",
            "label": "",
            "style": "boxing",
            "type": {
                "id": "00000000-0000-0000-0000-000000007047"
            },
            "roleDirection": true
        },
        {
            "from": "BI Data Model",
            "to": "BI Data Entity",
            "label": "",
            "style": "boxing",
            "type": {
                "id": "00000000-0000-0000-0000-000000007046"
            },
            "roleDirection": false
        },
        {
            "from": "MicroStrategy Report",
            "to": "MicroStrategy Report",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000013"
            },
            "roleDirection": false
        },
        {
            "from": "MicroStrategy Report",
            "to": "BI Data Model",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000013"
            },
            "roleDirection": false
        },
        {
            "from": "MicroStrategy Document",
            "to": "BI Data Model",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000013"
            },
            "roleDirection": false
        },
        {
            "from": "MicroStrategy Dossier",
            "to": "BI Data Model",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000013"
            },
            "roleDirection": false
        },
        {
            "from": "MicroStrategy Dossier",
            "to": "MicroStrategy Report",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000004"
            },
            "roleDirection": true
        },
        {
            "from": "MicroStrategy Data Attribute",
            "to": "Column",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-000000007069"
            },
            "roleDirection": false
        },
        {
            "from": "MicroStrategy Dossier",
            "to": "BI Data Model",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000015"
            },
            "roleDirection": true
        },
        {
            "from": "MicroStrategy Document",
            "to": "BI Data Model",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000015"
            },
            "roleDirection": true
        },
        {
            "from": "MicroStrategy Report",
            "to": "BI Data Model",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000015"
            },
            "roleDirection": true
        },
        {
            "from": "MicroStrategy Report",
            "to": "BI Data Entity",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-000000007038"
            },
            "roleDirection": true
        },
        {
            "from": "Column",
            "to": "Table",
            "label": "",
            "style": "boxed",
            "type": {
                "id": "00000000-0000-0000-0000-000000007042"
            },
            "roleDirection": true
        },
        {
            "from": "Table",
            "to": "Schema",
            "label": "",
            "style": "boxed",
            "type": {
                "id": "00000000-0000-0000-0000-000000007043"
            },
            "roleDirection": false
        },
        {
            "from": "Schema",
            "to": "Database",
            "label": "",
            "style": "boxed",
            "type": {
                "id": "00000000-0000-0000-0000-000000007024"
            },
            "roleDirection": false
        },
        {
            "from": "MicroStrategy Report",
            "to": "Business Term",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-000000007021"
            },
            "roleDirection": false
        },
        {
            "from": "MicroStrategy Report",
            "to": "BI Data Entity",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000013"
            },
            "roleDirection": false
        }
    ],
    "showOverview": false,
    "enableFilters": true,
    "showLabels": true,
    "showFields": true,
    "showLegend": true,
    "showPreview": true,
    "visitStrategy": "directed",
    "layout": "HierarchyLeftRight",
    "maxNodeLabelLength": 50,
    "maxEdgeLabelLength": 30,
    "layoutOptions": {
        "compactGroups": false,
        "componentArrangementPolicy": "topmost",
        "edgeBends": true,
        "edgeBundling": true,
        "edgeToEdgeDistance": 5,
        "minimumLayerDistance": "auto",
        "nodeToEdgeDistance": 5,
        "orthogonalRouting": true,
        "preciseNodeHeightCalculation": true,
        "recursiveGroupLayering": true,
        "separateLayers": true,
        "webWorkers": true,
        "nodePlacer": {
            "barycenterMode": true,
            "breakLongSegments": true,
            "groupCompactionStrategy": "none",
            "nodeCompaction": false,
            "straightenEdges": true
        }
    }
}