• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1594
  • Last Modified:

Cognos path to find folders

In cognos 8.4 we have my folders public folders where i can find this folders in cognos path
i mean c8 enviorment (like c:/progtamfiles/c8---)  any idea?

1 Solution
It's not stored in program files.
Cognos objects such as reports/folders etc. are stored in content database.
You have to setup auditing or directly query content database to find the report/folder path.
For example:
Follow IBM documentation to enable url_xml as a data source.
Then audit sample report 'Report Usage' actually gives report path.
Modify that report to what you want in the report.
For example, I get this from the report:

Rank   ReportPath   Times used   Last used on
-1   /content/package[@name='Audit']/report[@name='Report usage no. of runs with last date used']   5   01/31/2011
-2   /content/package[@name='ProjectTracker']/report[@name='Current Project Assignments by WORKGROUP']   4   01/31/2011

Reports in user's my folders will have CAMID instead of user's name:
   CAMID("DevAD:u:658f881c00f0304d8cd679087059f8f4")/folder[@name='My Folders']/report[@name='Test for package move to folder']   1   01/31/2011
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now