--- title: Cognos BI Administration – Lessons From the Trenches description: List of key learnings based on the challenges in Cognos BI Administration as reported by Cognos administrators. image: https://www.envisn.com/hs-fs/file-55263214-jpg/images/lessons-chalkboard.jpg --- [![envisn](https://www.envisn.com/hs-fs/file-15282154-gif/images/logo.gif?width=120&name=logo.gif "envisn")](https://www.envisn.com) [![Request a Demo](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/70307/973f9256-ef61-4ab8-ab2d-a004a90a18be.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/70307/973f9256-ef61-4ab8-ab2d-a004a90a18be) [![see our new video the magic of netvisn](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/70307/1845b46e-0995-41bd-9970-5523914e0cdd.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/70307/1845b46e-0995-41bd-9970-5523914e0cdd) # Envisn's IBM Cognos Blog ## [Cognos BI Administration – Lessons From the Trenches](https://www.envisn.com/envisn-cognos-blog/bid/92632/Cognos-BI-Administration-Lessons-From-the-Trenches) Posted by [Rick Ryan](https://www.envisn.com/envisn-cognos-blog/author/rick-ryan) - [Tweet](https://twitter.com/share) ***![chalkboard reading lessons from the edge](https://www.envisn.com/hs-fs/file-55263214-jpg/images/lessons-chalkboard.jpg?width=345&height=248&name=lessons-chalkboard.jpg)*May 31, 2013, 2013 by Paul Hausser, [Envisn, Inc.](https://www.envisn.com/) *"Make everything as simple as possible, but not simpler." - Albert Einstein* We regularly get feedback from customers and prospective customers on the challenges they have to deal with as a Cognos BI administrator. Much of this makes its way into our CRM system in summary form and we recently sifted through this to see what learnings, if any, there might be. Below are some of the key lessons that we came across and they are in the approximate order of importance or frequency of mention.   1. ***Stay Ahead of Your Cognos Security Model.*** Einstein was probably talking about security when he made his quote. Your security model is going to evolve whether you want it to or not. In many Cognos environments this happens passively and all too often gets to a point where it becomes unworkable. A better approach is to develop a model you want to evolve too. The major reasons for an outdated security model are: *a. Organic growth * *b. Acquisitions – this can be a new company, combining content stores, etc. * *c. Organizational change* So how do you intelligently evolve your security model? Keep track of the changes you are making to security, or where your current model is not appropriate, to see what, if any, patterns exist and use them as a guide to the next point of evolution. Stay focused on the key attributes of groups, roles and accounts and be consistent on what should be used where. You need to be control of what your Cognos security model evolves to. 2. ***Know where you’re currently spending your time.*** This isn’t just you but your colleagues that work in support of the Cognos environment as well. Is this where it makes sense to be focused? If not, how should you change it? It’s easy to get trapped into the daily routine of simply reacting to what needs to be done every day. Step back and figure out what you need to do to make it more focused on your key deliverables. 3. ***Get rid of no reward activities.*** Think of dumb, time wasting activities that get repeated all too frequently and have limited or no value. Do you or your people waste valuable time helping users, authors, etc. with things they would know if they had been better trained? Then conduct more training. Another example is responding to user requests to help find a particular report or subject area. If your content is not organized to make it easy for users to find what they need then reorganize it based on user feedback and input. 4. ***Invest in tools to support your work.*** Successful Cognos BI administration is focused on two things: Getting the information you need about your environment(s) in a timely manner and managing key tasks on a routine basis. Think about it. You’re using the best BI tools in the business with IBM Cognos but you don’t have any tools to manage the work needed to support them. Does that make sense? 5. ***Archive report output*** – In almost every Cognos environment that’s been in place for a while this is usually the largest part of the Content Store and often dwarfs reports, packages, etc. in terms of storage size. If large enough, this stored output can negatively impact Cognos’ performance. You can learn more about how to deal with this here: [*Archiving Cognos Content.*](https://www.envisn.com/envisn-cognos-blog/bid/81834/Archiving-Cognos-Content) 6. ***Eliminate unused content*** – Nothing is more valueless than maintaining and updating reports, queries and models that have outlived their usefulness. If you don’t know what part of your content is being used then look to the Cognos audit tables to help you get started or consider third party tools to get this information. Content that that has not been used during a given period, say 90 days or more, should be a candidate for removal unless it’s a report that is designed for a longer time period or is required for policy purposes. 7. ***Set some rules*** for the user community. The majority of most Cognos environments appear to have few if any rules around output retention, personal content, etc. This area can be tricky because once you’ve given users the ability to do what they want it can often be difficult to take them away or limit what they can do. 8. ***Listen to the users.*** Don’t know what your users like or dislike? Ask them, but remember that you have to be willing to do something with the answers you get.   *Have any learnings worth sharing? Post them as a comment to this article. **© 2013 – Envisn, Inc. - [Why NetVisn?](https://www.envisn.com/why-netvisn/)* Topics: [Cognos BI administration](https://www.envisn.com/envisn-cognos-blog/topic/cognos-bi-administration), [Archiving Cognos Content](https://www.envisn.com/envisn-cognos-blog/topic/archiving-cognos-content) *Your feedback is very important to us - we’d love to hear your comments!* ### Subscribe to Envisn's IBM Cognos Blog ### Posts by Category - [Cognos Content Store (22)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-content-store) - [Cognos BI Best Practices (21)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-bi-best-practices) - [Cognos Analytics (19)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-analytics) - [Cognos BI administration (19)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-bi-administration) - [Cognos Security (18)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-security) - [Cognos Tools (14)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-tools) - [Cognos Audit Data (11)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-audit-data) - [Cognos Reporting (9)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-reporting) - [Cognos Auditing (8)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-auditing) - [Cognos 10 (7)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-10) - [Cognos Framework Manager (7)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-framework-manager) - [Cognos Metadata (7)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-metadata) - [BI Trends (6)](https://www.envisn.com/envisn-cognos-blog/topic/bi-trends) - [IBM Information on Demand (6)](https://www.envisn.com/envisn-cognos-blog/topic/ibm-information-on-demand) - [Cognos Audit Log (5)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-audit-log) - [cognos impact analysis (4)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-impact-analysis) - [Big Data (3)](https://www.envisn.com/envisn-cognos-blog/topic/big-data) - [Cognos Data Sources (3)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-data-sources) - [Cognos Documentation (3)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-documentation) - [Cognos Scheduling (3)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-scheduling) - [Product Information (3)](https://www.envisn.com/envisn-cognos-blog/topic/product-information) - [cognos data lineage (3)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-data-lineage) - [Archiving Cognos Content (2)](https://www.envisn.com/envisn-cognos-blog/topic/archiving-cognos-content) - [Cognos FM Model (2)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-fm-model) - [Cognos migration (2)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-migration) - [Announcements (1)](https://www.envisn.com/envisn-cognos-blog/topic/announcements) - [Cognos Change Management (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-change-management) - [Cognos Data Provenance (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-data-provenance) - [Cognos Hotfiles (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-hotfiles) - [Cognos Powerplay (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-powerplay) - [Cognos Triggers (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-triggers) - [Consolidating Cognos Environments (1)](https://www.envisn.com/envisn-cognos-blog/topic/consolidating-cognos-environments) - [Impromptu (1)](https://www.envisn.com/envisn-cognos-blog/topic/impromptu) - [Merging Content Stores (1)](https://www.envisn.com/envisn-cognos-blog/topic/merging-content-stores) - [Remote Cognos Management (1)](https://www.envisn.com/envisn-cognos-blog/topic/remote-cognos-management) - [cognos deployments (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-deployments) - [cognos fm model documentation (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-fm-model-documentation) - [cognos workspace (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-workspace) - [netvisn (1)](https://www.envisn.com/envisn-cognos-blog/topic/netvisn) [see all](https://www.envisn.com/envisn-cognos-blog/bid/92632/Cognos-BI-Administration-Lessons-From-the-Trenches#) ### Posts by Popularity [![free download expert guide to cognos audit data](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/70307/6933ba0f-4664-4d5d-9413-edf64d7b2644.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/70307/6933ba0f-4664-4d5d-9413-edf64d7b2644) ### [Cognos Tools from Envisn](https://www.envisn.com/envisn-products) [NetVisn](https://www.envisn.com/netvisn) [AutoVisn](https://www.envisn.com/autovisn-cogos-scheduler) [UniVisn](https://www.envisn.com/univisn-cognos-performance-management) [DocuVisn](https://www.envisn.com/docuvisn-cognos-documentation) ### [Cognos Resources](https://www.envisn.com/resources) [Envisn’s IBM Cognos Blog](https://www.envisn.com/envisn-cognos-blog) [Custom Query Library](https://www.envisn.com/custom-query-library) [Tutorial Videos](https://www.envisn.com/cognos-demo-videos) [Mastering Cognos Security](https://www.envisn.com/mastering-ibm-cognos-security) [Content Store Survival Guide](https://www.envisn.com/content-store-survival-guide) [Expert Guide to Cognos Audit Data](https://www.envisn.com/cognos-audit-data-expert-guide) ### [Contact Envisn](https://www.envisn.com/contact) [Request a Demo](https://www.envisn.com/request-a-demo) [Support](https://www.envisn.com/support) 512-991-3999 [info@envisn.com](mailto:info@envisn.com) ### Latest Cognos Posts | [![youtube](https://www.envisn.com/hs-fs/hubfs/youtube.png?width=30&name=youtube.png)](https://www.youtube.com/user/envisn) | [![linkedin](https://www.envisn.com/hs-fs/hubfs/linkedin.png?width=30&name=linkedin.png)](https://www.linkedin.com/company/envisn-inc./) | [![twitter](https://www.envisn.com/hs-fs/hubfs/twitter.png?width=30&name=twitter.png)](https://twitter.com/Envisn) | [![facebook](https://www.envisn.com/hs-fs/hubfs/facebook.png?width=30&name=facebook.png)](https://www.facebook.com/envisn/) | | --- | --- | --- | --- | [![Real Time Analytics](https://static.getclicky.com/media/links/badge.gif)](http://clicky.com/101126274) ![Clicky](https://in.getclicky.com/101126274ns.gif) 3000 Polar Lane, Suite 901, Cedar Park, TX 78613 USA *Serving North America, Europe, and the UK with plans to expand to other areas in the near future. **[Privacy, Copyright & Liability](https://www.envisn.com/privacy-copyright-liability)*