HANA Information Viewの参照先を確認するためのSQL

Attribute View, Analytic View の参照先オブジェクト

select 
	DEPENDENT_SCHEMA_NAME
	,DEPENDENT_OBJECT_NAME
	,DEPENDENT_OBJECT_TYPE
	,BASE_SCHEMA_NAME
	,BASE_OBJECT_NAME
	,BASE_OBJECT_TYPE
from SYS.OBJECT_DEPENDENCIES
where DEPENDENT_OBJECT_NAME not like '%/hier/%'
//and	DEPENDENT_OBJECT_TYPE = 'VIEW'
order by DEPENDENT_SCHEMA_NAME, DEPENDENT_OBJECT_NAME

SELECT
	ao.PACKAGE_ID
	,ao.OBJECT_NAME
	,ao.OBJECT_SUFFIX
	,ao.CDATA
	,od.BASE_OBJECT_NAME
FROM	object_dependencies	od
INNER JOIN
	_SYS_REPO.ACTIVE_OBJECT ao
ON
	SUBSTR_BEFORE(od.DEPENDENT_OBJECT_NAME, '/') = ao.package_id
AND	SUBSTR_AFTER(od.DEPENDENT_OBJECT_NAME, '/')	= ao.object_name
AND	ao.object_suffix in (
	'analyticview'
	, 'attributeview'
	, 'calculationview'
	)
WHERE
	ao.package_id like 'パッケージ名%'
and od.DEPENDENT_OBJECT_NAME = 'パッケージ/InformationView名'
and od.DEPENDENT_OBJECT_NAME not like '%/hier/%'
AND	od.DEPENDENT_SCHEMA_NAME = '_SYS_BIC'
AND	od.DEPENDENT_OBJECT_TYPE = 'VIEW'
order by ao.PACKAGE_ID, ao.OBJECT_NAME

Calculation Viewを含むXML定義情報

SELECT
	ao.PACKAGE_ID
	,ao.OBJECT_NAME
	,ao.OBJECT_SUFFIX
	,ao.CDATA
FROM	_SYS_REPO.ACTIVE_OBJECT ao
WHERE
	ao.object_suffix in (
		'analyticview'
		, 'attributeview'
		, 'calculationview'
	)
AND	ao.package_id like 'パッケージ%'
order by ao.PACKAGE_ID, ao.OBJECT_NAME

参考URL：
https://blogs.sap.com/2016/10/24/sap-hana-base-columns-information-views-depend/