Skip to Content
0
Former Member
Sep 16, 2014 at 01:51 PM

Querying Sys tables - Calculation Views

7154 Views

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