When you have 100 reports.... When you have a lot of dimention.... When you have thousands of entities,
If you need to query the entire system, to understand:
- where does the data come from?
- which entities are read?
- which "job" is launched?
- Is the call manual or timed?
- Entity XXX, which Factables or Dimention do you populate?
- Is Tabular? Is PowerQuery? Is OLAP? is ODATA?
I created three different visualizations:
- By Report > FACT/DIMENTION/ENTITIES
- By Hierarchy Job-Model-Report > FACT/DIMENTION/ENTITIES
- By Entities >> FACT/DIMENTION/JOB/REPORT
eyJrIjoiYjY2MDhjMDgtM2I1Yi00MjBjLWJlZTYtMjMxMzc0MjJjNmNmIiwidCI6ImM0ZjRkNWVjLTRkZWQtNGUzMi1iMTQ5LTNlYmIxMThiNzlkZSIsImMiOjl9
