on 07-12-2017 5:43 AM
Hi All.
I need a table name which stores all objects name viz. list of all Attributes views, Analytical Views, Calculation views.
Like, in ABAP we have a standard table TADIR which stores all program name.
And also, need to find what all HANA database procedures are available from some table.
Hi Amit,
select * from "_SYS_BI"."BIMC_CUBES" or BIMC_PROPERTIES will provide the list of all the AV, ANV, CV (cons - all the column names are listed)
The above select statement serves your requirement... It provides list of all Calculation view Names...
Below SAP link provides SAP HANA database views and its purpose...
Thanks & Regards,
Sardar..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you would have invested some time to check the online documentation for SAP HANA you would have found following:
Regards,
Florian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for reply Florian.
I have try to find out with your way but, still the question remains same.
If I create attribute view AT_CUSTOMER, then this name (AT_CUSTOMER) may get stored in some table or view. Then how to find out that table/view name in HANA studio to get above view name (AT_CUSTOMER).
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.