SQL Server dbms:
(the logic for this query will be the same for the other mart supported databases such as Oracle and PostgreSQL)
select m9cg.C_Name 'Library',
m9cg2.C_Name 'Model',
m9rd.O_PhysicalName 'Table Name'
from m9ReportData m9rd,
m9catalog m9cg,
m9catalog m9cg2
where m9rd.O_Type =1075838979
and m9rd.O_ParentiD = m9cg.C_Container_Id
and m9rd.C_Id = m9cg2.C_Id
order by 1,2,3
You can modify the query to filter it on specific models or tables or libraries using a where clause.
e.g., below replace tablename with the specific name of the table.
m9cg2.C_Name 'Model',
m9rd.O_PhysicalName 'Table Name'
from m9ReportData m9rd,
m9catalog m9cg,
m9catalog m9cg2
where m9rd.O_Type =1075838979
and m9rd.O_PhysicalName = 'tablename'
and m9rd.O_ParentiD = m9cg.C_Container_Id
and m9rd.C_Id = m9cg2.C_Id
order by 1,2,3
Comments
0 comments
Please sign in to leave a comment.