1 / 14

Streamlining Crop Production Reporting with MetaManager and IBM Cognos Solutions

As a global agricultural company focused on the retail of fertilizers, chemicals, and seeds, we utilize MetaManager by BSP Software for effective management of IBM Cognos in our data environments. With approximately 1,000 Cognos report users accessing 800 reports and generating 1,000 daily requests, our migration from Oracle to faster Netezza enhances performance. MetaManager enables seamless deployments, report conversions, and user auditing through an intuitive interface, significantly improving operational efficiency and leveraging IBM Cognos capabilities to their fullest.

mercia
Télécharger la présentation

Streamlining Crop Production Reporting with MetaManager and IBM Cognos Solutions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MetaManagerAs We Use It

  2. Who is Crop Production Services? • Global Agricultural company focused on retail sales of Fertilizer, Chemicals and Seed • Child Company to Agrium based in Calgary Canada.

  3. Map…. We Are Here

  4. About Our Users? • Approximately 1000 cognos report users • 800 reports • 1000 requests daily

  5. About Our Environment? • Oracle and Netezza DW • Converting 800 reports from Oracle to Netezza • Why in the world would you do that?!?! • Netezza is a much faster • Some of the data structure changed • Development environment • Production environment • Series 7’s Access Manager for authentication • Oh and we are running IBM Cognos 10.1 • Cognos Administration • Framework Manager • Transformer • Report Studio • Analysis Studio • Business Insight Advanced

  6. Enough About Us…. What the heck is Metamanager? • BSP Software’s tool - http://www.bspsoftware.com/ • MetaManager offers administrators and developers the ability to gain full control over all aspects of their deployment through one intuitive, powerful user interface.  Through the various product modules, users are able to save tremendous time automating manual processes while adding a wealth of capabilities to extend the value of the out-of-the-box IBM Cognos software. • What it is to us • Deployment between Development and Production • Report Conversions from Oracle to Netezza • User Auditing tool for defining ….. Anything

  7. Module Demos • Find and Replace • Backup/Restore/Deploy • Security Auditor • Content Store Documenter

  8. But First…a few things Modules

  9. Authentication

  10. Find / Replace

  11. Backup/Restore/Deploy We restore from Prod to Dev and visa versa

  12. Content Store Documenter

  13. Security Auditor • Example of CAMID’s for burst queries.

  14. Bonus Material • Modules are Well Documented on You tube • BrightStar Partners , Inc product • Questions?

More Related