
Hello, everyone
After using so many Calc.Views that call another bunch of Calc.Views, etc. is really difficult to identify the correct origin (table.column/formula) of some field. This was causing some rework to understand all information needed and to correctly check and model the data
To solve that, I developed a really simple way to connect to HANA, get the dependency data and generates a JSON using Python and jQuery:
You can enter a Calculation View name and it will check all its dependencies generating a JSON with this information:
{
<COLUMN NAME>: {
"sourceType": <Shows "DATA_BASE_TABLE" for table columns and "formula" for Formulas>,
"source": <Shows table name for table columns and the Calculation View Node for Formulas>,
"column": <Shows column name for table columns and the formula for Formulas>,
"source": <Shows schema name for table columns and the Calculation View Name for Formulas>
}
}
You can check the code and how to used it at my GitHub: GitHub - rodrigocava/HANACalcViewColumnsOrigin
I hope that it could help others as well :smile:
Best regards to all !!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
17 | |
10 | |
10 | |
7 | |
7 | |
7 | |
6 | |
6 | |
5 | |
4 |