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...
dougnewton Since this is from 2024, I'm not sure if you're still in the Sisense-sphere, but I wanted to jump in regardless.
Totally hear you on this! It makes complete sense that this type of report/data should just be built natively and available in Sisense.
While we can’t speak for the product team’s roadmap, this is something we've heard a lot from other Sisense customers. Change impact is tricky, and knowing what will actually break before you touch something in the database is really valuable.
We built the Asset Auditor to address exactly what you're describing. It covers all live and Elasticube data models (not unbuilt, though) and surfaces the connection details, database and schema names, and the tables and columns being referenced.
From there, you can trace dependencies all the way through to the dashboards and widgets consuming that data, so if a table structure changes, you know exactly what's at risk before anything breaks. We also surface existing errors that are related to missing data models or missing tables/columns, so that you can get them cleaned up. And that is just the start!
Here is an example of one of the (many) widgets the Asset Auditor provides.
We supply a set of dedicated Sisense dashboards, so that you can also create additional dashboards/charts for whatever you need. No scripting or manual API work needed to keep it current. And we're always here to help!
Feel free to reach out in the Community, or here if this is of interest to you, and we'll be happy to get you set up with a demo and a free trial!
Mia from QBeeQ, a Sisense Gold Implementation Partner