Currency conversion in Hana views

[former_member196080]

Experts

Is there a way to find list of views in Hana studio where currency conversion is happening in Hana?

Thanks

[sreevatsa_adiraju · Accepted solution]

To get only view names

SELECT DISTINCT "CATALOG_NAME", "SCHEMA_NAME", "CUBE_NAME" FROM "_SYS_BI"."BIMC_DIMENSION_VIEW" WHERE ("CURRENCY_CONVERSION" = '1') ORDER BY "CATALOG_NAME" ASC, "SCHEMA_NAME" ASC, "CUBE_NAME" ASC

To get Particular column also

SELECT DISTINCT "CATALOG_NAME", "SCHEMA_NAME", "CUBE_NAME", "COLUMN_NAME" FROM "_SYS_BI"."BIMC_DIMENSION_VIEW" WHERE ("CURRENCY_CONVERSION" = '1') ORDER BY "CATALOG_NAME" ASC, "SCHEMA_NAME" ASC, "CUBE_NAME" ASC, "COLUMN_NAME" ASC

[former_member199945]

Hi,

There is a standard view "_SYS_BI"."BIMC_MEASURES"

, which holds all the created views with the measures where used list details. In this view we have measure_unit,Unit_type ,Unit_colum_name.

By using combiniation of these 3 columns you can get the details.

Thanks