SSRS-PBRS operating model

Overview and diagram view

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.

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.

Asset type	Synchronized metadata	Resource ID
SSRS Column Public ID: SsrsColumn	Full name
	Display name
	Description	Description
	Technical Data Type	TechnicalDataType
	BI Data Model contains / is part of BI Data Attribute	BIDataModelContainsBIDataAttribute
	Data Element targets / sources Data Element	DataElementTargetsDataElement
	Data Entity contains / is part of Data Attribute	DataEntityContainsDataAttribute
SSRS Data Model Public ID: SsrsDataModel	Full name
	Display name
	Certified	Certified
	Description	Description
	Document creation date	DocumentCreationDate
	Document modification date	DocumentModificationDate
	Document size	DocumentSize
	Location	Location
	URL	Url
	Visible on server	VisibleOnServer
	BI Data Model contains / is part of BI Data Attribute	BIDataModelContainsBIDataAttribute
	BI Folder contains / contained in Data Asset	BIFolderContainsDataAsset
	Data Asset is source for / sources BI report	DataAssetIsSourceForBIReport
	Data Entity is part of / contains Data Model	DataEntityIsPartOfDataModel
SSRS Folder Public ID: SsrsFolder	Full name
	Display name
	Description	Description
	Document creation date	DocumentCreationDate
	Document modification date	DocumentModificationDate
	Location	Location
	URL	Url
	Visible on server	VisibleOnServer
	Business Dimension groups / is grouped into Report	BusinessDimensionGroupsReport
	BI Folder assembles / is assembled in BI Folder	BIFolderAssemblesBIFolder
	BI Folder contains / contained in Data Asset	BIFolderContainsDataAsset
	Server hosts / is hosted in Business Dimension	ServerHostsBusinessDimension
SSRS KPI Public ID: SsrsKpi	Full name
	Display name
	Certified	Certified
	Description	Description
	Document creation date	DocumentCreationDate
	Document modification date	DocumentModificationDate
	Document size	DocumentSize
	Location	Location
	URL	Url
	Visible on server	VisibleOnServer
	Business Dimension groups / is grouped into Report	BusinessDimensionGroupsReport
	Data Asset is source for / sources BI Report	DataAssetIsSourceForBIReport
	Report Attribute contained in / contains Report	ReportAttributeContainedInReport
	Report related to / impacted by Business Asset	ReportRelatedToBusinessAsset
SSRS Parameter Public ID: SsrsParameter	Full name
	Display name
	Description	Description
	Business Asset represents / represented by Data Asset	BusinessAssetRepresentsDataAsset
	Report Attribute contained in / contains Report	ReportAttributeContainedInReport
	Report Attribute sourced from / is source of Data Attribute	ReportAttributeSourcedFromDataAttribute
SSRS Report Public ID: SsrsReport	Full name
	Display name
	Certified	Certified
	Description	Description
	Document creation date	DocumentCreationDate
	Document modification date	DocumentModificationDate
	Document size	DocumentSize
	Location	Location
	URL	Url
	Visible on server	VisibleOnServer
	Business Dimension groups / is grouped into Report	BusinessDimensionGroupsReport
	Data Asset is source for / sources BI Report	DataAssetIsSourceForBIReport
	Report related to / impacted by Business Asset	ReportRelatedToBusinessAsset
	Report uses / used in Report	ReportUsesReport
SSRS Server Public ID: SsrsServer	Full name
	Display name
	Description	Description
	Server hosts / is hosted in Business Dimension	ServerHostsBusinessDimension
SSRS Table Public ID: SsrsTable	Full name
	Display name
	Description	Description
	Data Entity contains / is part of Data Attribute	DataEntityContainsDataAttribute
	Data Entity is part of / contains Data Model	DataEntityIsPartOfDataModel

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 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 Asset 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 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

Copy

{
    "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 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": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000002"
            },
            "roleDirection": true
        },
        {
            "from": "SSRS Folder",
            "to": "SSRS Report",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000002"
            },
            "roleDirection": true
        },
        {
            "from": "SSRS Folder",
            "to": "SSRS KPI",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000004"
            },
            "roleDirection": true
        },
        {
            "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
        },
        {
            "from": "SSRS Server",
            "to": "SSRS Folder",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000000"
            },
            "roleDirection": true
        },
        {
            "from": "SSRS Folder",
            "to": "SSRS Folder",
            "label": "",
            "style": "arrow",
            "type": {
                "id": "00000000-0000-0000-0000-120000000001"
            },
            "roleDirection": true
        }
    ],
    "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
        }
    }
}