I would like to be able to run a "lineage/dependency" report in Sisense. Something that will tell me for all the cube/live data sources: - Data source name - Type (cube/live) - Dates of the data...
Looks like much of this might be available already via the API:
- Get the list of cubes (live and elasticube)
- For each one, get the datasets in that cube
- For each dataset, get the /datasets/id/tables and the metadata about each table
- Output the combination to a CSV file someplace, and make a Usage Analytics "dependency report" on top of it
So just need to wrap all this up in some automated process and expose it in the Sisense product. 🙂