Calculation view dependencies using system Tables

[former_member1580]

Hello Experts,

I need the system tables where all the dependencies are specified.

for the below example, if my CV has dim1,dim2 and measure1, I need the following

CV | CV.Dim1| Join1.Dim1 | proj2.Dim1 | WIS_C01.Dim1

CV | CV.Dim2| Join1.Dim2 | proj1.Dim2 | WIS_D01.Dim2

CV | CV.measure1| Join1.measure1| proj1.Dim1 | WIS_D01.Dim1

a kind of Data lineage from the attributes of the CV till the tables/views used

Thanks in advance

[Cocquerel]

Hello,

There is a system view that provides dependencies between objects (SYS.OBJECT_DEPENDENCIES) but it does not provide dependencies information at field level. There is a data lineage functionality in the calculation view editor but, I think, it just parses the xml of the design-time object to show the information in graphical way. I don't think it relies on any system view. You can try to parse via SQL this XML from field CDATA of table "_SYS_REPO"."ACTIVE_OBJECT" but it may be complexe.

Regards,

Michael