290 likes | 404 Views
Creating and Maintaining Business Objects Universes. Presented by Douglas Greer. Overview. Software & Setup Required The Basics Hands On Tips & Tricks What’s Coming (Clarity 13.4 Changes) Q&A. Software & Setup Required. For Oracle Oracle Client (32-bit)
E N D
Creating and Maintaining Business Objects Universes Presented by Douglas Greer
Overview • Software & Setup Required • The Basics • Hands On • Tips & Tricks • What’s Coming (Clarity 13.4 Changes) • Q&A
Software & Setup Required • For Oracle • Oracle Client (32-bit) • TNS Names Entry exactly like the one found on the BO server • For MSSQL • Windows ODBC 32-bit data source exactly like the one found on the BO server • Install BO Client Tools • Full BO CD downloadable from CA Support • Client tools only downloadable from SAP Support
What is WEBI • Reporting tool (like Crystal Reports) • Included free with Clarity • Browser-based - nothing to install • Integrates with Clarity
What are Universes • Translator – business language to query language • Visually build data model • Define a simplified view of the data • Build SQL Queries on the fly
Implementing Ad-Hoc Reporting • Determine which custom fields are needed for reporting • Build a custom universe and add your custom fields to it • Link the custom universe with each of the (4) OOTB Universes • Provide 1-2 day WEBI training course for Clarity power users • Keep the universe in sync with any Clarity customizations • Let the time-saving begin!
Overall Architecture • Copy & Modify CA OOTB Universes • Custom Universe Linked to OOTB • Hybrid • Pros & Cons
Designer • Import, Export, and Save • Refreshing Table Structure • Integrity Check
Universe Parameters • Controls • Row Limit • Time Limit • SQL Parameters • ANSI92 • DISTINCT_VALUES
Tables & Joins • Alias every table • Set JOIN type properly (INNER vs. OUTER) • No loops • How to correct a loop
Classes & Objects • Use Clarity Terminology • Hide OOTB Folders & Objects that aren’t used • Use Detail fields to hide primary keys
Classes & Objects • Replace WHERE clause with CASE statement
Classes & Objects • Push measure aggregation to the database
Enhancing Universes • Add descriptions • Add object formatting at the universe level • Add relative date objects
Migrating Universes & Reports • Use the objects name and path to determine whether it already exists • Never overwrite connection contents • When the import is finished, always view the details
Documenting a Universe • Print (if you have PDF printing software) • Save As…PDF • Universe Documenter • http://bukhantsov.org/2011/09/universe-documenter/
What’s Coming – Clarity 13.4 • Business Analytics is going away • Adding Native Clarity Ad-Hoc Reporting (Jaspersoft) • Business Objects is here to stay • Upgrading to BOXI 4.1 (latest)
Questions Contact US 888.813.0444 Email Contact info@regoconsulting.com Web Site www.regoconsulting.com Thank you.