A frequently asked question is whether IBM Cognos provides any tools for helping administrators manage their BI environment. The answer is both yes and no. IBM Cognos does provide a tool that enables users to browse their Content Store. A link for downloading this tool is at the end of this article.
The Cognos 8 Content Manager browser tool provides a tree view of the objects in the Content Store. The major categories are:
As you navigate up and down the branches of the tree within these categories you will see the detail properties on the right side of your screen for whatever object you have selected. So if you were looking at a report, for example, you can see all of the properties and parameters of this report. If you chose “specification” here it would give you the detail specs for this report including data lineage. The problem, however, is that this can only be viewed or opened in Notepad, and when doing that you get a mega dump of XML like content that can be difficult to parse for consumable information. So yes, you can drill down into the detail but when you get it you may not find it very useable.
The tool also has a search capability so you can search selectively for virtually anything in the Content Store. This includes wild card searches as well. There apparently is a limit on searching, however, since you could encounter a Content Store lockout if the Record Read Limit exceeds 5000. But if you are looking for something specific and can narrow your search this feature can be helpful.
Areas where this Content Manager Browser Tool can be useful are for finding things and looking at relationships between objects. Thus, if you wanted to know which package, or version of a package, that a particular report was using you could easily find that by first finding the report and then looking at the properties section to find the package being used. If you wanted to look at the folder structure of your Cognos environment it is easier to use this tool for browsing that than to try and do this in the Cognos portal itself. You can quickly drill down into the tree structure to see both personal and public folders. The tool also provides a snapshot for all settings and properties for all objects in the Content Store and the Cognos software configuration. So if you know what you need it’s relatively easy to look it up. Basically, it is most useful when looking for point to point relationships between objects and for finding the detail properties of individual objects.
While useful, the tool has some limitations:
The Cognos 8 Content Manager Browser Tool may be helpful when you need to know specific detail about an object or folder structure or license capabilities. To go much beyond that will require a more robust third party tool such as NetVisn.
© 2011 - Envisn, Inc. – All rights reserved
Image by takomabibelot