Cognos Content Store 10.2.2

[GeethaKL]

Hi All,
I am working in Cognos 10.2.2 and i am given a task to get the list of all cubes, dimensions and reports out of Cognos Configuration to be able to produce the required detail automatically if at ll possible. So they would then store the output as metadata table.

How to go about this task? What details should I need to progress with this one?
I know there are tables associated with this in Cognos Content Store database in SSMS?

I am clearly after few suggestions and advises to go step by step?

Thanks in advance

Regards
Geetha

[GeethaKL]

Can anyone help me with this?
Where should i query to get the list of all cubes, dimensions and all the reports in Cognos content store and against what tables?
Please help me with this?
thank you

Regards
Geetha

[bensah]

Hi,

You can check the below link for it.
http://www.cognoise.com/index.php?topic=28289.0

[GeethaKL]

Thank you Bensah for the response.
Yeah I will try and update the code as per my details and execute the code in SQL Management Studio against Cognos Content Store database.
I will continue to discuss via the above link

Regards
Geetha