backend table to know Enable history in Calculation View

[former_member514240]

eable-historycapture.pngHI,

We would like to know the query(backend table) to find , Whether enable history is checked in or not for each calculation view in SAP HANA.

Enable history is under view properties option. Screenshot added of the option.

Thanks and Regards

Sampath R.

[KonradZaleski · Accepted solution]

You can find this information by running this query:

SELECT 
	"CATALOG_NAME",
	"CUBE_NAME",
	"VIEW_NAME",
	"SCHEMA_NAME",
	"HISTORY_ENABLED"
FROM
	"_SYS_BI"."BIMC_ALL_CUBES"

HISTORY_ENABLED column indicates if for specific view option is selected ( 1 ) or not ( 0 ).

[former_member514240 · Accepted solution]

Thanks Konrad for the right query, It helped me