Querying Sys tables - Calculation Views

[#1]

Soooo....

I've been playing around in the system views and found quite a bit of useful stuff for querying meta-data around base objects.

For Tables, column definitions, constraints etc ...

For Attribute views,  column names, dependencies, joins & join conditions....

Yet for Calculation Views; I'm drawing a blank.

Ok, so I can list them (name, type) from sys.objects, but I've not been able to gain any further info.

Does anyone know (a) why this is (they they are not detailed in sys views ?)  and (b) does the data I'm looking for exist in tables elsewhere ?

Just for illustration, a small example of the views I've been hitting so far ..

M_TABLES

CS_VIEW_COLUMNS

CS_BO_VIEWS

CONSTRAINTS

CS_JOIN_TABLES

CS_JOIN_PATHS

CS_JOIN_CONDITIONS

CS_KEY_FIGURES

OBJECTS

OBJECT_DEPENDENCIES

[lbreddemann]

What is it you want to find out about column views?

- Lars

[Former Member]

In the simplest case, I'd like to be able to see what tables/views it depends on.(and vice-versa)

Example of what you can to explore for Attribute Views .... so something like this for CVs :

Select * from SYS.CS_JOIN_TABLES WHERE VIEW_NAME = 'myView'

SCHEMA_NAME	VIEW_NAME	TABLE_SCHEMA_NAME	TABLE_NAME	TABLE_TYPE
_SYS_BIC	myView_AT	ABC	Table1	none
_SYS_BIC	myView_AT	ABC	Table2	none
_SYS_BIC	myView_AT	ABC	Table3	none

Select * from SYS.CS_JOIN_TABLES WHERE TABLE_NAME = 'myTable'

SCHEMA_NAME	VIEW_NAME	TABLE_SCHEMA_NAME	TABLE_NAME	TABLE_TYPE
_SYS_BIC	....../CUSTOMER_AT	ABC	myTable	none
_SYS_BIC	....../Vendor_AT	ABC	myTable	none
_SYS_BIC	...../PurchaseHistory_AT	ABC	myTable	none