cancel
Showing results for 
Search instead for 
Did you mean: 

Get the list of measures and dimensions in an analytic view

Former Member
0 Kudos

Hi,

How to get the list of measures and dimensions of a specific analytic view using SQL /SQLScript in SAP HANA I need to send this list to the client so

he chooses what measures and dimensions to see. Then I will extract the data based on what the client selects. Examples are welcome.

Thanks & regards

Mohamed Ali

Accepted Solutions (1)

Accepted Solutions (1)

former_member184768
Active Contributor
0 Kudos

Hi Ali,

For Dimensions:

SELECT --*

distinct "DIMENSION_NAME", "DIMENSION_CAPTION"

FROM "_SYS_BI"."BIMC_DIMENSIONS" where "CUBE_NAME" = '<View_Name>' and "CATALOG_NAME" = '<package_name>';

For Measures:

SELECT --*

distinct "ALTERNATIVE_PROPERTY_NAME", "DESCRIPTION"

FROM "_SYS_BI"."BIMC_PROPERTIES" where "CUBE_NAME" = '<View_Name>' and "CATALOG_NAME" = '<package_name>' and ALTERNATIVE_PROPERTY_NAME is not null

and DIMENSION_UNIQUE_NAME = '[Measures]';

Hope this helps. You can always modify the queries mentioned above to get exactly what you need.

Regards,

Ravi

Former Member
0 Kudos

thank you Ravindra, it works perfectly.

Answers (0)