Last week I ask on Twitter if anybody knows a good strategy to get all sources of a SAP HANA Calculation View (CV). I got different answers I want to share with you. One approach is really fascinating.
Does anyone know how I get a list of source tables of a calculation view? Is there any table where this information is stored like the normal #BW rsz tables?— Tobias (@reyemsaibot) September 22, 2020
I got an answer from Georgios who recommended the SYS.OBJECT_DEPENDENCIES. There is also a question in the SAP Community which describes the solution with SYS.OBJECT_DEPENDENCIES. There is also a blog entry on sap.com about this topic. Another way is which Alexey offered via the ACTIVE_OBJECTCROSSREF table, and he also gave me a hind with this post which describes the "SAP HANA Auto-Documentation" the Excel way.
And let me say we have a winner. The SAP HANA Auto-Documentation - Excel Way is a very good solution to solve my issue.
As you can see very cool tool to get all information you need. Thanks to the SAP Community.
You want to know SAP Analysis Office in a perfect detail?
You want to know how to build an Excel Dashboard with your Query in Analysis Office?
You want to know how functions in SAP Analysis Office works?
Then you have to take a look into Analysis Office - The Comprehensive Guide. Either as a video course or as an e-book.