SSRS and PBRS operating model

The lineage harvester collects SQL Server Reporting Services (SSRS) metadata and sends it to the Collibra Data Lineage service. Collibra processes the metadata and creates new SSRS assets and relations in Data Catalog. You can see them on the asset page overview or visualize them in a diagram or in a technical lineage.

Note

The assets have the same names as their counterparts in SSRS and Power BI Report Server (PBRS). Full names and Names cannot be changed in Data Catalog.
Assets ingested from SSRS and PBRS are called SSRS assets in Data Catalog, except for PBRS reports which are called Power BI Report assets.
Asset types are only created if you have all specific Data Catalog permissions.
All SSRS and PBRS assets are created in the same domain.
Relations that were manually created between SSRS assets or PBRS assets and other assets via a relation type in the SSRS and PBRS operating model, are deleted after synchronizing the metadata.

SSRS and PBRS metadata overview

The following image shows the relations between SSRS asset types and the Power BI Report asset type.

Harvested metadata per asset type

This table shows the harvested SSRS and PBRS metadata for each SSRS asset type and Power BI Report asset type, assuming you have the necessary subscriptions and configurations for a full ingestion. This table also shows the resource ID for each asset type and metadata.

Asset type	Synchronized metadata	Resource ID
SSRS Column Resource ID: 00000000-0000-0000-0000-100000000029	Full name
	Display name
	Description	00000000-0000-0000-0000-000000003114
	Technical Data Type	00000000-0000-0000-0000-000000000219
	BI Data Model contains / is part of BI Data Attribute	00000000-0000-0000-0000-000000007196
	Data Element targets / sources Data Element	00000000-0000-0000-0000-000000007069
	Data Entity contains / is part of Data Attribute	00000000-0000-0000-0000-000000007047
SSRS Data Model Resource ID: 00000000-0000-0000-0000-100000000028	Full name
	Display name
	Certified	00000000-0000-0000-0001-000500000001
	Description	00000000-0000-0000-0000-000000003114
	Document creation date	00000000-0000-0000-0000-000000000260
	Document modification date	00000000-0000-0000-0000-000000000261
	Document size	00000000-0000-0000-0000-000000000259
	Location	00000000-0000-0000-0000-000000000203
	URL	00000000-0000-0000-0000-000000000258
	Visible on server	00000000-0000-0000-0000-000000000265
	BI Data Model contains / is part of BI Data Attribute	00000000-0000-0000-0000-000000007196
	BI Folder contains / contained in Data Asset	00000000-0000-0000-0000-120000000014
	Data Asset is source for / source BI report	00000000-0000-0000-0000-120000000013
	Data Entity is part of / contains Data Model	00000000-0000-0000-0000-000000007046
SSRS Folder Resource ID: 00000000-0000-0000-0000-100000000024	Full name
	Display name
	Description	00000000-0000-0000-0000-000000003114
	Document creation date	00000000-0000-0000-0000-000000000260
	Document modification date	00000000-0000-0000-0000-000000000261
	Location	00000000-0000-0000-0000-000000000203
	URL	00000000-0000-0000-0000-000000000258
	Visible on server	00000000-0000-0000-0000-000000000265
	Business Dimension groups / is grouped into Report	00000000-0000-0000-0000-120000000002
	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
	Server hosts / is hosted in Business Dimension	00000000-0000-0000-0000-120000000000
SSRS KPI Resource ID: 00000000-0000-0000-0000-100000000026	Full name
	Display name
	Certified	00000000-0000-0000-0001-000500000001
	Description	00000000-0000-0000-0000-000000003114
	Document creation date	00000000-0000-0000-0000-000000000260
	Document modification date	00000000-0000-0000-0000-000000000261
	Document size	00000000-0000-0000-0000-000000000259
	Location	00000000-0000-0000-0000-000000000203
	URL	00000000-0000-0000-0000-000000000258
	Visible on server	00000000-0000-0000-0000-000000000265
	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
	Report Attribute contained in / contains Report	00000000-0000-0000-0000-000000007058
	Report related to / impacted by Business Asset	00000000-0000-0000-0000-120000000006
SSRS Parameter Resource ID: 00000000-0000-0000-0000-100000000027	Full name
	Display name
	Description	00000000-0000-0000-0000-000000003114
	Business Asset represents / represented by Data Asset	00000000-0000-0000-0000-000000007038
	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
SSRS Report Resource ID: 00000000-0000-0000-0000-100000000025	Full name
	Display name
	Certified	00000000-0000-0000-0001-000500000001
	Description	00000000-0000-0000-0000-000000003114
	Document creation date	00000000-0000-0000-0000-000000000260
	Document modification date	00000000-0000-0000-0000-000000000261
	Document size	00000000-0000-0000-0000-000000000259
	Location	00000000-0000-0000-0000-000000000203
	URL	00000000-0000-0000-0000-000000000258
	Visible on server	00000000-0000-0000-0000-000000000265
	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
	Report related to / impacted by Business Asset	00000000-0000-0000-0000-120000000006
	Report uses / used in Report	00000000-0000-0000-0000-120000000007
SSRS Server Resource ID: 00000000-0000-0000-0000-100000000023	Full name
	Display name
	Description	00000000-0000-0000-0000-000000003114
	Server hosts / is hosted in Business Dimension	00000000-0000-0000-0000-120000000000
SSRS Table Resource ID: 00000000-0000-0000-0000-100000000030	Full name
	Display name
	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

Example of ingested SSRS and PBRS metadata

The following image shows an example structure after SSRS and PBRS ingestion.

Recommended hierarchy within a domain

You can enable hierarchies for the domain (or domains) in which your SSRS assets were ingested. Doing so makes it easier to understand the relation between your SSRS 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 Multipath.
Start typing and select each of the following relation types:
- Server hosts Business Dimension
- Business Dimension groups Report
- BI Folder contains Data Asset
- Data Set is source for BI Report
- Report contains Report Attribute
- BI Folder contains Data Asset
- BI Data Model contains BI Data Attribute
- 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 an SSRS and PBRS operating model diagram view

You can create a diagram view for SSRS and PBRS to visualize the operating model. Complete the following steps to 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.

Show me the JSON code

Copy code

{
  "nodes": [
	{
      "id": "SSRS Column",
	  "type": {
	    "id": "00000000-0000-0000-0000-100000000029"
	   }
	 },
	 {
	    "id": "SSRS Data Model",
		"type": {
		  "id": "00000000-0000-0000-0000-100000000028"
	    }
	  },
	  {
	    "id": "SSRS Table",
		"type": {
		  "id": "00000000-0000-0000-0000-100000000030"
		 }
	   },
	   {
	     "id": "SSRS KPI",
		 "type": {
		   "id": "00000000-0000-0000-0000-100000000026"
		  }
		},
		{
		  "id": "SSRS Parameter",
		  "type": {
		    "id": "00000000-0000-0000-0000-100000000027"
		  }
		},
		{
		  "id": "SSRS Folder",
		  "type": {
		    "id": "00000000-0000-0000-0000-100000000024"
		  }
		},
		{
		  "id": "Power BI Report",
		  "type": {
		    "id": "00000000-0000-0000-0000-100000000006"
		  }
		},
		{
          "id": "SSRS Report",
		  "type": {
		    "id": "00000000-0000-0000-0000-100000000025"
		  }
		},
		{
		   "id": "SSRS Folder 2",
		   "type": {
		     "id": "00000000-0000-0000-0000-100000000024"
		   }
		 },
		 {
		   "id": "SSRS Server",
		   "type": {
			 "id": "00000000-0000-0000-0000-100000000023"
		   }
		 },
		 {
		   "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"
		   }
		 }
	 ],  
     "edges": [
	   {
	     "from": "SSRS Data Model",
		 "to": "SSRS Column",
		 "label": "",
		 "style": "arrow",
		 "type": {
		   "id": "00000000-0000-0000-0000-000000007196"
		 },
		 "roleDirection": true
		},
		{
		   "from": "SSRS Table",
		   "to": "SSRS Column",
		   "label": "",
		   "style": "arrow",
		   "type": {
		     "id": "00000000-0000-0000-0000-000000007047"
		   },
		   "roleDirection": true
		 },
		 {
		   "from": "SSRS Data Model",
		   "to": "SSRS Table",
		   "label": "",
		   "style": "arrow",
		   "type": {
		     "id": "00000000-0000-0000-0000-000000007046"
		   },
		   "roleDirection": true
		 },
		 {
		   "from": "SSRS Data Model",
		   "to": "SSRS KPI",
		   "label": "",
		   "style": "arrow",
		   "type": {
		     "id": "00000000-0000-0000-0000-120000000013"
		   },
		   "roleDirection": true
		 },
		 {
		   "from": "SSRS KPI",
		   "to": "SSRS Parameter",
		   "label": "",
		   "style": "arrow",
		   "type": {
		     "id": "00000000-0000-0000-0000-120000000014"
		  },
		   "roleDirection": true
		 },
		 {
		   "from": "SSRS Folder",
		   "to": "SSRS Data Model",
		   "label": "",
		   "style": "arrow",
		   "type": {
		     "id": "00000000-0000-0000-0000-120000000014"
		   },
		   "roleDirection": true
		 },
		 {
		   "from": "SSRS Folder",
		   "to": "Power BI Report",
		   "label": "",
		   "style": "boxing",
		   "type": {
		     "id": "00000000-0000-0000-0000-120000000002"
		   },
		   "roleDirection": true
		 },
		 {
		   "from": "SSRS Folder",
		   "to": "SSRS Report",
		   "label": "",
		   "style": "boxing",
		   "type": {
		     "id": "00000000-0000-0000-0000-120000000002"
		   },
		   "roleDirection": true
		 },
		 {
		   "from": "SSRS Folder",
		   "to": "SSRS KPI",
		   "label": "",
		   "style": "boxing",
		   "type": {
		     "id": "00000000-0000-0000-0000-120000000004"
		   },
		   "roleDirection": true
		 },
		 {
		   "from": "SSRS Server",
		   "to": "SSRS Folder 2",
		   "label": "",
		   "style": "boxing",
		   "type": {
		     "id": "00000000-0000-0000-0000-120000000000"
		   },
		   "roleDirection": false
		 },
		 {
		   "from": "SSRS Folder 2",
		   "to": "SSRS Folder",
		   "label": "",
		   "style": "boxing",
		   "type": {
		     "id": "00000000-0000-0000-0000-120000000001"
		   },
		   "roleDirection": true
		 },
		 {
		   "from": "SSRS Folder",
		   "to": "SSRS Server",
		   "label": "",
		   "style": "boxed",
		   "type": {
		     "id": "00000000-0000-0000-0000-120000000000"
		   },
		   "roleDirection": false
		 },
		 {
		   "from": "SSRS Report",
	       "to": "SSRS Data Model",
		   "label": "",
		   "style": "arrow",
		   "type": {
		   "id": "00000000-0000-0000-0000-120000000013"
		   },
		   "roleDirection": false
		 },
		 {
		   "from": "SSRS Column",
		   "to": "Column",
		   "label": "",
		   "style": "arrow",
		   "type": {
		     "id": "00000000-0000-0000-0000-000000007069"
		   },
		   "roleDirection": false
		 },
		 {
		   "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
		  }
		],
		"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
		  }
		}
      }