--- title: Cognos Metadata Universe – Part II – Designing the Future description: Once you have established a data architecture to deal with Cognos metadata, there is virtually no limit to the things you can do. image: https://www.envisn.com/hubfs/images/Metadata-Universe-Data-Trans-D.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)   # *What if you could use your Cognos audit data for anything you wanted to?* [![See What the All New UniVisn Can Do for You](https://no-cache.hubspot.com/cta/default/70307/3e64868b-5b60-4894-976e-ba955c88e2b5.png)](https://cta-redirect.hubspot.com/cta/redirect/70307/3e64868b-5b60-4894-976e-ba955c88e2b5) # Envisn's IBM Cognos Blog ## [Cognos Metadata Universe – Part II – Designing the Future](https://www.envisn.com/envisn-cognos-blog/cognos-metadata-universe-part-ii-designing-the-future) Posted by [The Envisn Team](https://www.envisn.com/envisn-cognos-blog/author/the-envisn-team) - [Tweet](https://twitter.com/share) *By Rick Ryan, [Envisn, Inc.](https://www.envisn.com/)* In the [first blog in this series](https://www.envisn.com/envisn-cognos-blog/cognos-metadata-universe) published last month we presented the four key data groups in the [Cognos Metadata Universe](https://www.envisn.com/envisn-cognos-blog/cognos-metadata-universe) and described them in some detail. These are shown again on the left side of Figure 1 below. In that blog we also listed some of the things we would cover in subsequent blogs. One of these was the importance of having an architecture to deal with Cognos metadata. Having a data architecture begins with the desired outcome of the process. Which is the answer to the question of how we want to use the data. The goal of an architecture for our purpose has three principal goals: - *Be able to answer any questions you might have about the Content Store. * - *Develop capabilities for Cognos administrators and developers to manage routine tasks they have to deal with on a daily basis. * - *Ability to accommodate change and growth.* *![cognos metadata transformation to useable information](https://www.envisn.com/hs-fs/hubfs/images/Metadata-Universe-Data-Trans-D.jpg?width=765&name=Metadata-Universe-Data-Trans-D.jpg "cognos metadata transformation to useable information")* ## Capturing the Metadata The Content Store by itself is Big Data. It can have thousands of objects each of which can have hundreds of properties. A conservative count total for the number of metadata elements that a report object can have, for example, is around 800. Depending on type, some objects will have more and others less. We want to capture all of them. Are the numbers really important here? Up to a point. We’re not looking for precision but it’s worth knowing that there is a lot of stuff from these four groups that we need to capture, transform, store and manage. Coming up with the right architecture is important since whatever we create will either enable or limit what we can do with the metadata, both now and in the future. Ideally you should be able to use any of the metadata for any purpose and get an accurate representation of what you want. An obvious question here is why not just go to the Content Store directly for the metadata whenever it’s needed. After all, that’s what the Content Store is for isn’t it, to provide the metadata that will be mapped to the physical data for each user’s need. You can do this, but there are some reasons you may not want to take this approach. These include: - *This creates contention with users running reports, queries, etc. In a Cognos environment of any size this can become a problem. * - *It’s very inefficient since the metadata are not persisted for continual use. * - *And most importantly, it greatly limits what you can do with the metadata. The subject of security is a prime example.* If your decision is to persist the data from these sources you have to choose between using a relational database such as MS SQL, DB2 or Oracle, versus a No SQL database of which there are a number of alternatives. Here we chose the No SQL approach. Our view is that its advantages are clearly superior. ## The Magic Process Once you’ve completed the challenge of capturing all the Cognos metadata sources shown in the left side of Figure 1, you need a process that transforms, stores and accesses this metadata for use. This really is what you might call the ***secret sauce*** since it determines what you are able to do with the metadata. Essentially this involves providing dimensionality around key parameters such as time, relationships, state, change and a host of other parameters. The *connectedness* if you will, of the metadata elements. Doing this successfully is what enables you to use the metadata for multiple purposes. Again, we’re focused here on two principal areas: - *Answering questions about the Cognos metadata. * - *Managing key tasks for Cognos administrators.* Some of the key tasks are shown in the right pane of Figure 1. These include documentation, object dependency, version control, deployments, and security management. But there is virtually no limit to the things you can do once you have all the metadata. *Simple concept? Yes. Easy? Not so much.* There are literally thousands of metadata elements that we need to capture and be able to use in the Cognos metadata universe. In our [next blog](https://www.envisn.com/envisn-cognos-blog/cognos-metadata-universe-part-iii-capturing-deep-data) we will begin to explore some of the more novel and creative ways that all of this data can be used to address [real world issues that Cognos administrators face](https://www.envisn.com/envisn-cognos-blog/cognos-metadata-universe-part-iii-capturing-deep-data) every day. *© [Envisn, Inc.](https://www.envisn.com/) – 2018 – All rights reserved.*   *[![see why envisn customers sat netvisn is essential for cognos bi](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/70307/90ba4bde-4b41-4c1d-a6a5-03dc04736da3.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/70307/90ba4bde-4b41-4c1d-a6a5-03dc04736da3)*   Topics: [Cognos Content Store](https://www.envisn.com/envisn-cognos-blog/topic/cognos-content-store), [Cognos Metadata](https://www.envisn.com/envisn-cognos-blog/topic/cognos-metadata) *Your feedback is very important to us - we’d love to hear your comments!* ### Subscribe to Envisn's IBM Cognos Blog [![Your Content Store contains thousands of objects with hundreds of properties. netvisn gives you control of all of it learn more](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/70307/c76703b2-30ab-4086-9bc3-f2c890de7c5f.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/70307/c76703b2-30ab-4086-9bc3-f2c890de7c5f) ### 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/cognos-metadata-universe-part-ii-designing-the-future#) ### Posts by Popularity [![free download expert guide to cognos audit data](https://no-cache.hubspot.com/cta/default/70307/6933ba0f-4664-4d5d-9413-edf64d7b2644.png)](https://cta-redirect.hubspot.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)*