If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos Content Store - Documenting reports

Started by johnmsp, 26 Jul 2018 06:50:33 PM

Previous topic - Next topic

johnmsp

Hello friends,

Is there a way to extract details about report query/queries using Content Store tables? For each report, we want to extract information about the package each query is built upon and list items pulled in each query. Also we want to extract SQL definition of each item.

The version we're using is 10.2.2.

I would really appreciate if you could share a query to extract all such information or give me some pointers.

Thank you.

- John.

sdf

Hi,

Below is a post regarding querying the Content Store DB to get basic info for reports and packages used.

https://www.cognoise.com/index.php/topic,28289.msg113869.html#msg113869

maybe you can start from here.

johnmsp

I had already looked at that posting, but didn't find it useful. The query posted by the user has a table named as "CognosContent", but there is no such table in our Content Store database.

Lynn

Quote from: johnmsp on 27 Jul 2018 09:15:05 AM
I had already looked at that posting, but didn't find it useful. The query posted by the user has a table named as "CognosContent", but there is no such table in our Content Store database.

Directly accessing the content store is not recommended as a best practice since it can change from one version to another. The table in question may have existed once upon a time. The SDK is a more reliable way to access information if you have access and skills necessary. There are also 3rd party tools that might be useful.

Having said all that, I do think I've seen more posts on Cognoise and elsewhere about direct access to the content store. Maybe others will chime in with more information.