cancel
Showing results for 
Search instead for 
Did you mean: 

system table name to get metadata of a calculation view in HANA

Former Member
0 Kudos

Hello

I have created a graphical calculation view,which is running sucessfully.

Example :-

table1, table2 -- > join_1 ( table1.id =table2.id) --> projection_1 -> Aggregation -- > Output.

At 'projection_1' , I have renamed few columns ( given user friendly name )

Example : - Table1.EmpNo renamed to EmployeeNumber.

            Table2.DeptNo renamed to DepartmentNumber.

My question is :- 

which system view ,can give me the entire list of the all attributes/measures of that calculation view?

Note :- I have check M_CE_CALCVIEW_DEPENDENCIES,M_CE_CALCSCENARIOS views , but didn't get the results which I am looking for. 

Also checked CS_VIEW_COLUMNS view but that is  for Attribute and Analytic view.

Regards

Sayan

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member185165
Active Participant
0 Kudos

Hi Sayan,

Use the following CE function to get the list of fields from calculation view.

CE_CALC_VIEW


Regards,

Vijay

Former Member
0 Kudos

Vijay,

Thank you for your reply.

But CE_CALC_VIEW would not solve my purpose.

Let me put my questing in this way : -


I am looking for a table name which will return the Metadata(like field names and table names) of  the given Calculation view ( like CS_VIEW_COLUMNS for Attribute and Analytic view) ?

former_member185165
Active Participant
0 Kudos

Hi Sayan,

Please refer to the following help document link. Check on VIEW_COLUMNS and TABLE_COLUMNS.

https://help.sap.com/saphelp_hanaplatform/helpdata/en/20/cbb10c75191014b47ba845bfe499fe/content.htm?...

Regards,

Vijay

Former Member
0 Kudos

Thank you Vijay for sharing the link. The view name is "_SYS_BI"."BIMC_DIMENSIONS" , which I wan looking for.

Former Member
0 Kudos

Is there also a way to find out - not only the column names - but the data types?

Former Member
0 Kudos

Use the table "_SYS_BI"."BIMC_PROPERTIES"


Thx