SAP HANA Calculation Views Hierarchy Graph
At our current development we used a lot of Calc.Views that call another bunch of Calc.Views, etc. This was causing some rework to understand all the dependencies to build Analytic Privileges or to check all the tables that needed.
To solve that, I developed a really simple way to connect to HANA, get the dependency data and generates a graph using Python and D3.js:
The red lines and dots represent Views and the green ones represent Tables.
You can check the code and how to used it at my GitHub: https://github.com/rodrigocava/HANAcalcViewHierarchy
I hope that it could help others as well 🙂
Best regards to all !!