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