METADATA-Dataset Dependencies

Type: Informer Metadata

Reveal Datasets and Ad Hoc Queries that are dependent on other Datasets or Datasources.

METADATA-Dataset Dependencies Downloads

Reveal Datasets and Ad Hoc Queries that are dependent on other Datasets or Datasources.

Bundle (TGZ): METADATA-Dataset Dependencies
Definition JSON: metadata-dataset-dependencies.json

Summary

This report is dependent upon the METADATA-Reports-Dataset Ids Names for the Dependent Dataset name.

This report is very useful in finding all of the report and datasets that use the "Fields from another Dataset" or "Fields from another Datasource". This information can help you understand the dependencies that your reports and datasets require.

The report creates links to the reports/datasets and the dataset dependencies. However, to get these links to work properly you will need to update a single link in a Powerscript. Open the report and edit the Create hyperlinks Powerscript and update the

baseURL = "https://devbi.navigahub.com/" to your base url baseURL = "https://xxxbi.navigahub.com/"

Full Powerscript

baseURL = "https://devbi.navigahub.com/"
if ($record['type'] === "Ad Hoc Report") {
    $record.LinkToReport = `<a target="_blank" href="${baseURL}reports/q/${$record['id']}">${baseURL}reports/q/${$record['id']}</a>`
} else {
    $record.LinkToReport = `<a target="_blank" href="${baseURL}datasets/${$record['id']}">${baseURL}datasets/${$record['id']}</a>`
}

$record.dependentDatasetLink = ""

if ($record['joinedDatasetIds'] && $record['joinedDatasetIds'].length > 0)  {
	$record.dependentDatasetLink = `<a target="_blank" href="${baseURL}datasets/${$record['joinedDatasetIds']}">${baseURL}datasets/${$record['joinedDatasetIds']}</a>`    
}

Description

Reads the Informer PostgreSQL database for information to reveal Datasets and Ad Hoc Queries that are dependent on other Datasets or Datasources. These dependencies are in the Flow steps of the source Dataset or Ad Hoc Report.
ONLY Datasets and Ad Hoc Reports that have dependencies will show up in this report. This report is itself dependent upon the "METADATA-Reports-Dataset Ids Names".

Fields

Label	Alias	Type	Hidden	Description
Num Of Dependent Datasources	numOfDependentDatasources	double		Number of dependent Datasources that the source query is dependent upon.
Num Of Dependent Datasets	numOfDependentDatasets	double		Number of dependent Datasets that the source query is dependent upon.
Type	type	keyword_text		Dataset or Ad Hoc Report
Name	name	keyword_text		The Dataset Name that the source query is dependent upon. Each source query can have more than one dependency. This is the information pulled from the "METADATA-Reports-Dataset Ids Names" joined dataset.
Id	id	keyword_text		Source Dataset or Ad Hoc Query UUID.
Link To Report	LinkToReport	keyword_text		Clickable link to the source Dataset or Ad Hoc Report.
Dependent Dataset Id	joinedDatasetIds	keyword_text		The Dataset UUID that the source query is dependent upon. Each source query can have more than one dependency.
Dependent Dataset Name	dependentDatasetName	keyword_text		The Dataset Name that the source query is dependent upon. Each source query can have more than one dependency. This is the information pulled from the "METADATA-Reports-Dataset Ids Names" joined dataset.
Dependent Dataset Link	dependentDatasetLink	keyword_text		Clickable link to the dependent Dataset.
Dependent Datasource Names	dependentDatasourceNames	keyword_text		Dependent Datasource Name
Flow	flow	object		Array of Flow steps. Each flow step in the array is stored as an Object.