1 / 26

CMSPro

CMSPro. Omniversal Apps, Inc. Application overview.

louise
Download Presentation

CMSPro

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. CMSPro Omniversal Apps, Inc.

  2. Application overview CMSPro is an extremely powerful, yet simple, metadata exploration and analysis tool for Business Objects Enterprise XI. It allows viewing, drilling, and exporting of the Business Objects CMS repository data in a quick and easy format, entirely via web browser. It provides powerful flexibility with ease-of-use and superior performance. For any administrator who uses Query Builder, this is the tool that will save them many hours of time and frustration.

  3. Enables quick and easyquerying of the entire repository with commonly used fields • Produces queries and result sets for the CMS repository in a normal horizontal table layout • Delivers combined results for all of the possible different object types, into an easily readable result set • Dynamic navigation of the repository -- drill up/down/across to related objects

  4. Capable of finding all dependent child objects • Has customized fields to save time and effort • Has predefined quick filters • Supports ALL object types incl. CrystalRepository • Option to display user security for result objects • Capable of retrieving and displaying the various “Property Bags” as well as other rarely used fields if needed • Use as an interface to reports and Universes to support multi-tab, multithread testing of reports

  5. Uses multi-pass SQL and multi-type queries internally, to avoid extra workflows for the user • Produces SQL that is interchangeable and usable with Query Builder • Supports Path queries, Search queries, CUID queries, and SQL queries • Provides a drop-down list of fields (incl. property bags) • Impact Analysis Guide helps you create the necessary queries for Impact Analysis, to avoid problems from removing or changing content.

  6. Supports Enterprise, LDAP and AD logins • Can be hosted on servers and/or desktops running Tomcat 5.5 or 6 ( or modified for other App servers ) • Can be installed and running in minutes • Has a small resource footprint & NO client or plugin • Multitask: Work in multiple browser tabs using the same session • Keeps a log of SQL submitted & result size • Faster than CMC for viewing object metadata & drilling • Integrated links from Results page into InfoView and Webi, for seamless navigation • Exports to Excel, Word, and HTML

  7. Use it to… • Quickly find any object & system metadata • Perform impact analysis for system & object changes • Document your environments regularly (support Audits) • Quickly list everything created/changed recently • Perfect for assisting in operational troubleshooting • Drill into object relationships such as Universe: Webi docs or Connection:Universes • Navigate object hierarchies and view metadata • Navigate User / Group relationships • Find large files and documents which may be causing performance or capacity problems • Assist in system cleanups by finding dependents, empty folders, inactive users etc. • Take system snapshots for analysis of performance • Find internal problems such as unbound Webi docs • Compare the contents of different BO XI systems

  8. Premium edition features: • Easily create BIAR files for import/upgrade or archive – with one click from your result sets! • Generate listings of reports triggered by Events, and instance limits on reports • Run an analysis to find Dynamic Prompt objects related to Crystal reports • Use the Cleanup Agent for periodic purges of document instances • Schedule a daily system snapshot report (which can be customized) • Quickly generate lists of objects accessible to a selected user or group • Compare lists of accessible objects for one Principal to another with one click • Generate queries / browse Universes in Webi with one click from your result set. • Integrate it with other apps by using the Manual SQL plugin. • Create BIAR archives of all recurring jobs for replication or DR

  9. CMSPro Benchmarks: BIAR files • Test group A: 100 content objects (reports and documents) • Total raw file sizes (summed) = 29 MB • BIAR file generation time: less than 1 minute • Generated BIAR file size: 5 MB • Import Wizard BIAR generation time (same objects): 1.5 minutes • Test group B: 2000 content objects (reports and documents) • Total raw file sizes (summed) = 1.7 GB • BIAR file generation time: 41 minutes • Generated BIAR file size: 497 MB • Import Wizard BIAR generation time: Failed after 1 hour Tested running CMSPro and Import Wizard on 2.4 GHz, dual core Windows XP laptop, 3 GB RAM

  10. Dynamic Drill paths provided • Parent Folder   Subfolders   Documents • Group  Subgroups   Users   Groups • Universe Folder   Universes  Reports • Universe  Connection  Universes • Crystal Report  Universe  Connection • Object Package   Package components • Crystal Rpt  Dynamic Prompts  BusinessView objects • Custom Roles  Objects assigned to a role • ServerGroups  Servers • Any Object  Principals and Roles assigned for object • Any Object   Immediate children • Any Object  all descendants • Any Object  all fields for that object (select *)

  11. Advantages over Query Builder • Easy & useful point-and-click interface w/ common fields pre-selected • Quick filters (radio buttons) • Dynamic custom fields show selected useful detail, tailored to object type • Directory of other repository fields, selectable with a mouse click • Dynamic auto table selection • Error correction for manual SQL • Shows folder path at object level • Column-based results grid • Customizable font size • Dynamic drilling • Dynamic Prompt analysis • Show Security / rights on objects • Export results to Excel or Word • Maintains a log of queries • Supports SQL queries, Path queries, Search queries, and CUID queries • A one-click System Snapshot Report, which can be scheduled* • Any query can be scheduled* * This feature is in the Premium edition

  12. Advantages over Query Builder (continued) • Biar files can be generated from query results, and even scheduled* • Can generate a matrix of all Events and the reports or objects triggered by each.* • Can generate a matrix of all Recurring Instances and the limits defined on each.* • Can generate a matrix of Universes and the reports that use them.* • Integrates links from result sets to Infoview, allowing seamless viewing of reports, navigation of folders, and querying/browsing universes from Webi, all with one click. • Create BIAR archives of all recurring jobs for replication or DR * This feature is in the Premium edition

  13. Sample screens

  14. End

More Related