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.
- 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.
MicroStrategy metadata overview
The following image shows the relations between MicroStrategy asset types.
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.
- Object Templates
- System Objects
- Version Update History
| Asset type | Harvested MicroStrategy metadata in Data Catalog |
Resource ID |
|---|---|---|
|
MicroStrategy Data Attribute Resource ID: 00000000-0000-0000-0000-100000000047 |
Description
|
00000000-0000-0000-0000-000000003114
|
|
Technical Data Type |
00000000-0000-0000-0000-000000000219 |
|
|
Data Element targets / sources Data Element |
00000000-0000-0000-0000-000000007069 |
|
|
Data Entity contains / is part of Data Attribute |
00000000-0000-0000-0000-000000007047 |
|
|
Data Attribute used in / uses Report |
00000000-0000-0000-0000-120000000021 |
|
|
MicroStrategy Data Entity Resource ID: 00000000-0000-0000-0000-100000000048 |
Description |
00000000-0000-0000-0000-000000003114 |
|
Data Entity contains / is part of Data Attribute |
00000000-0000-0000-0000-000000007047 |
|
|
Data Entity is part of / contains Data Model |
00000000-0000-0000-0000-000000007046 |
|
|
Data Asset is source for / source BI Report |
00000000-0000-0000-0000-120000000013 |
|
|
MicroStrategy Data Model Resource ID: 00000000-0000-0000-0000-100000000046 Note If the data model is embedded in the project, Collibra Data Lineage automatically creates a dummy data model. |
Description |
00000000-0000-0000-0000-000000003114
|
| BI Folder contains / contained in Data Asset | 00000000-0000-0000-0000-120000000014 | |
|
Data Model contains / is part of Data Entity |
00000000-0000-0000-0000-000000007046 |
|
|
MicroStrategy Document Resource ID: 00000000-0000-0000-0000-100000000049 |
Description |
00000000-0000-0000-0000-000000003114 |
|
Certified |
00000000-0000-0000-0001-000500000001 | |
|
Owner in source |
00000000-0000-0000-0000-200000000001 | |
|
URL Note You can specify the platform on which you run MicroStrategy, in your lineage harvester configuration file, to ensure the correct URL. |
00000000-0000-0000-0000-000000000258 | |
|
Business Dimension groups / is grouped into Report |
00000000-0000-0000-0000-120000000002 | |
|
BI Report contains / contained in BI Data Model |
00000000-0000-0000-0000-120000000015 | |
|
MicroStrategy Dossier Resource ID: 00000000-0000-0000-0000-100000000043 |
Description |
00000000-0000-0000-0000-000000003114 |
|
Certified |
00000000-0000-0000-0001-000500000001 | |
|
Owner in Source |
00000000-0000-0000-0000-200000000001 | |
|
Business Dimension groups / is grouped into Report |
00000000-0000-0000-0000-120000000002 | |
|
Report uses / used in Report |
00000000-0000-0000-0000-120000000007 | |
|
MicroStrategy Folder Resource ID: 00000000-0000-0000-0000-100000000042 |
Description |
00000000-0000-0000-0000-000000003114 |
|
BI Folder assembles / is assembled in BI Folder |
00000000-0000-0000-0000-120000000001 | |
|
Business Dimension groups / is grouped into Report |
00000000-0000-0000-0000-120000000002 | |
|
BI Folder contains / contained in Data Asset |
00000000-0000-0000-0000-120000000014 |
|
|
MicroStrategy Project Resource ID: 00000000-0000-0000-0000-100000000041 |
Description |
00000000-0000-0000-0000-000000003114 |
|
BI Folder assembles / is assembled in BI Folder |
00000000-0000-0000-0000-120000000001 | |
|
Server hosts / is hosted in Business Dimension |
00000000-0000-0000-0000-120000000000 | |
|
MicroStrategy Report Resource ID: 00000000-0000-0000-0000-100000000044 |
Description |
00000000-0000-0000-0000-000000003114 |
|
Certified |
00000000-0000-0000-0001-000500000001 | |
|
URL |
00000000-0000-0000-0000-000000000258 | |
|
Owner in Source |
00000000-0000-0000-0000-200000000001 | |
|
Report groups / is grouped into Report |
00000000-0000-0000-0000-120000000004 | |
|
Business Dimension groups / is grouped into Report |
00000000-0000-0000-0000-120000000002 | |
|
Data Asset is source for / source BI Report |
00000000-0000-0000-0000-120000000013 |
|
|
MicroStrategy Server Resource ID: 00000000-0000-0000-0000-100000000040 |
Server hosts / is hosted in Business Dimension |
00000000-0000-0000-0000-120000000000 |
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 an asset page.
-
In the tab pane, click
Diagram.
The diagram appears in the default diagram view. - Click
to add a new view. - Click the Text tab, to switch to the diagram view text editor.
- Click Show me the JSON code below this procedure, to expand the code.
- Click
in the top-right of the expanded code, to copy the code.
The code is copied to your clipboard. - Paste the code in diagram view text editor.
- Click Save.
- Edit the name and description of the diagram view, to suit your needs.
{
"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 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": false,
"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
}
}
}