I have a requirement to extract/see the report xml from the Cognos Content Store. I have searched the Cognos Support site, they dont have documented the schema of the Content store tables. I searched for tables, it took lot of time and we need to remember the join conditions. Later i found a discussion thread, please find the link below.
<http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos-reportnet-l/report-xml-in-content-store-1526046>
One of the Guy in the thread suggested a SQL to extract the plain text report XML.
select names.name, specs.spec from CRN.CMOBJNAMES_BASE names, CRN.CMOBJPROPS7 specs where names.CMID = specs.CMID and names.name LIKE '%REPORT NAME%' -- name field is case sensitve
I am going to try this in my content store tomorrow. I also heard about this tool in the same thread. Its for meta data management.
<http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos-reportnet-l/report-xml-in-content-store-1526046>
One of the Guy in the thread suggested a SQL to extract the plain text report XML.
select names.name, specs.spec from CRN.CMOBJNAMES_BASE names, CRN.CMOBJPROPS7 specs where names.CMID = specs.CMID and names.name LIKE '%REPORT NAME%' -- name field is case sensitve
I am going to try this in my content store tomorrow. I also heard about this tool in the same thread. Its for meta data management.
I want to explore what this tool is doing.
