on 05-29-2013 9:54 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.