1 / 29

Creating and Maintaining Business Objects Universes

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)

xia
Download Presentation

Creating and Maintaining Business Objects Universes

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. Creating and Maintaining Business Objects Universes Presented by Douglas Greer

  2. Overview • Software & Setup Required • The Basics • Hands On • Tips & Tricks • What’s Coming (Clarity 13.4 Changes) • Q&A

  3. 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

  4. The Basics

  5. What is WEBI • Reporting tool (like Crystal Reports) • Included free with Clarity • Browser-based - nothing to install • Integrates with Clarity

  6. 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

  7. What are Universes

  8. 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!

  9. Designer

  10. Tables & Joins

  11. Classes & Objects

  12. Hands On

  13. Tips & Tricks

  14. Overall Architecture • Copy & Modify CA OOTB Universes • Custom Universe Linked to OOTB • Hybrid • Pros & Cons

  15. Designer • Import, Export, and Save • Refreshing Table Structure • Integrity Check

  16. Universe Parameters • Controls • Row Limit • Time Limit • SQL Parameters • ANSI92 • DISTINCT_VALUES

  17. Tables & Joins • Alias every table • Set JOIN type properly (INNER vs. OUTER) • No loops • How to correct a loop

  18. Classes & Objects • Use Clarity Terminology • Hide OOTB Folders & Objects that aren’t used • Use Detail fields to hide primary keys

  19. Classes & Objects • Replace WHERE clause with CASE statement

  20. Classes & Objects • Push measure aggregation to the database

  21. Enhancing Universes • Add descriptions • Add object formatting at the universe level • Add relative date objects

  22. 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

  23. Documenting a Universe • Print (if you have PDF printing software) • Save As…PDF • Universe Documenter • http://bukhantsov.org/2011/09/universe-documenter/

  24. Documenting a Universe

  25. 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)

  26. What’s Coming – Clarity 13.4

  27. What’s Coming – Clarity 13.4

  28. What’s Coming – Clarity 13.4

  29. Questions Contact US 888.813.0444 Email Contact info@regoconsulting.com Web Site www.regoconsulting.com Thank you.

More Related