Creating and Maintaining Business Objects Universes Software amp Setup Required The Basics Hands On Tips amp Tricks Whats Coming Clarity 134 Changes QampA Overview Software amp Setup Required ID: 815730
Download The PPT/PDF document "Presented by Douglas Greer" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Presented by Douglas Greer
Creating and Maintaining Business Objects Universes
Slide2Software & Setup RequiredThe Basics
Hands On
Tips & TricksWhat’s Coming (Clarity 13.4 Changes)Q&A
Overview
Slide3Software & 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
Slide4The Basics
Slide5Reporting tool (like Crystal Reports)Included free with Clarity
Browser-based - nothing to install
Integrates with Clarity
What is WEBI
Slide6Translator – business l
anguage to query
languageVisually build data modelDefine a simplified view of the data
Build SQL Queries on the fly
What are Universes
Slide7What are Universes
Slide8Determine 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 UniversesProvide 1-2 day WEBI training course for Clarity power usersKeep the universe in sync with any Clarity customizations
Let the time-saving begin!
Implementing Ad-Hoc Reporting
Slide9Designer
Slide10Tables & Joins
Slide11Classes & Objects
Slide12Hands On
Slide13Tips & Tricks
Slide14Copy & Modify CA OOTB UniversesCustom Universe Linked to OOTB
Hybrid
Pros & Cons
Overall Architecture
Slide15Import, Export, and SaveRefreshing Table Structure
Integrity Check
Designer
Slide16ControlsRow Limit
Time Limit
SQL ParametersANSI92DISTINCT_VALUES
Universe Parameters
Slide17Alias every tableSet JOIN type properly (INNER vs. OUTER)
No loops
How to correct a loop
Tables & Joins
Slide18Use Clarity TerminologyHide OOTB Folders & Objects that aren’t used
Use Detail fields to hide primary keys
Classes & Objects
Slide19Replace WHERE clause with CASE statement
Classes & Objects
Slide20Push m
easure aggregation to the database
Classes & Objects
Slide21Add descriptionsAdd object formatting at the universe level
Add relative date objects
Enhancing Universes
Slide22Use the objects name and path to determine whether it already exists
Never overwrite connection contents
When the import is finished, always view the details
Migrating Universes & Reports
Slide23Print (if you have PDF printing software)Save As…PDF
Universe Documenter
http://bukhantsov.org/2011/09/universe-documenter/
Documenting a Universe
Slide24Documenting a Universe
Slide25Business Analytics is going away Adding Native Clarity Ad-Hoc Reporting (Jaspersoft)
Business Objects is here to stay
Upgrading to BOXI 4.1 (latest)
What’s Coming – Clarity 13.4
Slide26What’s Coming – Clarity 13.4
Slide27What’s Coming – Clarity 13.4
Slide28What’s Coming – Clarity 13.4
Slide29Questions
Contact US
888.813.0444
Email Contact
info@regoconsulting.com
Web Site
www.regoconsulting.com
Thank you.