MicroStrategy operating model

The harvester collects MicroStrategy metadata and sends it to the Collibra Data Lineage service. Collibra processes the metadata and 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 counterparts in MicroStrategy. You cannot edit Full names and Names in Data Catalog.
  • 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.

Asset type Harvested MicroStrategy metadata in Data Catalog

Resource ID

 MicroStrategy Column

Resource ID: 00000000-0000-0000-0000-100000000047

 Description 00000000-0000-0000-0000-000000003114
BI Data Model contains / is part of BI Data Attribute 00000000-0000-0000-0000-000000007196

Report Attribute sourced from / is source of Data Attribute

 00000000-0000-0000-0000-120000000010

MicroStrategy Data Model

Resource ID: 00000000-0000-0000-0000-100000000046

Certified (not available yet)

 00000000-0000-0000-0001-000500000001

Description

 00000000-0000-0000-0000-000000003114
BI Data Model contains / is part of BI Data Attribute 00000000-0000-0000-0000-000000007196

MicroStrategy Dossier

Resource ID: 00000000-0000-0000-0000-100000000043

Certified (not available yet)

 00000000-0000-0000-0001-000500000001
Description 00000000-0000-0000-0000-000000003114
Business Dimension groups / is grouped into Report 00000000-0000-0000-0000-120000000002
Report Attribute contained in / contains Report 00000000-0000-0000-0000-000000007058
Report groups / is grouped into Report 00000000-0000-0000-0000-120000000004

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
BI Folder contains / contained in Data Asset 00000000-0000-0000-0000-120000000014

Business Dimension groups / is grouped into Report

 00000000-0000-0000-0000-120000000002

MicroStrategy Project

Resource ID: 00000000-0000-0000-0000-100000000041

Description

 00000000-0000-0000-0000-000000003114

Document creation date

 00000000-0000-0000-0000-000000000260
Document modification date 00000000-0000-0000-0000-000000000261
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

Certified (not available yet)

 00000000-0000-0000-0001-000500000001

Description

 00000000-0000-0000-0000-000000003114
Business Dimension groups / is grouped into Report 00000000-0000-0000-0000-120000000002

Report Attribute contained in / contains Report

 00000000-0000-0000-0000-000000007058

Report groups / is grouped into Report

 00000000-0000-0000-0000-120000000004

MicroStrategy Report Attribute

Resource ID: 00000000-0000-0000-0000-100000000045

Description

00000000-0000-0000-0000-000000003114

Role in Report

 00000000-0000-0000-0000-000000000266
BI Folder contains / contained in Data Asset 00000000-0000-0000-0000-120000000014
Report Attribute contained in / contains Report 00000000-0000-0000-0000-000000007058
Report Attribute sourced from / is source of Data Attribute 00000000-0000-0000-0000-120000000010

MicroStrategy Server

Resource ID: 00000000-0000-0000-0000-100000000040

Description

 00000000-0000-0000-0000-000000003114
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

  1. Open an asset page.
  2. In the tab pane, click Diagram.
    The diagram appears in the default diagram view.
  3. Click to add a new view.
  4. Click the Text tab, to switch to the diagram view text editor.
  5. Click Show me the JSON code below this procedure, to expand the code.
  6. Click Copy code in the top-right of the expanded code, to copy the code.
    The code is copied to your clipboard.
  7. Paste the code in diagram view text editor.
  8. Click Save.
  9. Edit the name and description of the diagram view, to suit your needs.

Copy code 

{
  "nodes": [
    {
      "id": "MicroStrategy Dossier",
      "type": {
        "id": "00000000-0000-0000-0000-100000000043"
      }
    },
    {
      "id": "MicroStrategy Report",
      "type": {
        "id": "00000000-0000-0000-0000-100000000044"
      }
    },
    {
      "id": "MicroStrategy Column",
      "type": {
        "id": "00000000-0000-0000-0000-100000000047"
      }
    },
    {
      "id": "MicroStrategy Data Model",
      "type": {
        "id": "00000000-0000-0000-0000-100000000046"
      }
    },
    {
      "id": "MicroStrategy Folder",
      "type": {
        "id": "00000000-0000-0000-0000-100000000042"
      },
      "display": "expanded",
      "layoutRegion": "flow"
    },
    {
      "id": "MicroStrategy Project",
      "type": {
        "id": "00000000-0000-0000-0000-100000000041"
      }
    },
    {
      "id": "MicroStrategy Server",
      "type": {
        "id": "00000000-0000-0000-0000-100000000040"
      }
    },
    {
      "id": "MicroStrategy Report Attribute",
      "type": {
        "id": "00000000-0000-0000-0000-100000000045"
      }
    }
  ],
  "edges": [
    {
      "from": "MicroStrategy Dossier",
      "to": "MicroStrategy Report",
      "label": "",
      "style": "arrow",
      "type": {
        "id": "00000000-0000-0000-0000-120000000004"
      },
      "roleDirection": true
    },
    {
      "from": "MicroStrategy Data Model",
      "to": "MicroStrategy Column",
      "label": "",
      "style": "boxing",
      "type": {
        "id": "00000000-0000-0000-0000-000000007196"
      },
      "roleDirection": true
    },
    {
      "from": "MicroStrategy Folder",
      "to": "MicroStrategy Dossier",
      "label": "",
      "style": "boxing",
      "type": {
        "id": "00000000-0000-0000-0000-120000000002"
      },
      "roleDirection": true
    },
    {
      "from": "MicroStrategy Report",
      "to": "MicroStrategy Column",
      "label": "",
      "style": "arrow",
      "type": {
        "id": "00000000-0000-0000-0000-120000000021"
      },
      "roleDirection": true
    },
    {
      "from": "MicroStrategy Project",
      "to": "MicroStrategy Folder",
      "label": "",
      "style": "boxing",
      "type": {
        "id": "00000000-0000-0000-0000-120000000001"
      },
      "roleDirection": false
    },
    {
      "from": "MicroStrategy Server",
      "to": "MicroStrategy Project",
      "label": "",
      "style": "boxing",
      "type": {
        "id": "00000000-0000-0000-0000-120000000000"
      },
      "roleDirection": true
    },
    {
      "from": "MicroStrategy Column",
      "to": "MicroStrategy Report Attribute",
      "label": "",
      "style": "arrow",
      "type": {
        "id": "00000000-0000-0000-0000-120000000010"
      },
      "roleDirection": false
    },
    {
      "from": "MicroStrategy Report",
      "to": "MicroStrategy Report Attribute",
      "label": "",
      "style": "boxing",
      "type": {
        "id": "00000000-0000-0000-0000-000000007058"
      },
      "roleDirection": false
    },
    {
      "from": "MicroStrategy Dossier",
      "to": "MicroStrategy Report Attribute",
      "label": "",
      "style": "arrow",
      "type": {
        "id": "00000000-0000-0000-0000-000000007058"
      },
      "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
    }
  }
}