www.regoconsulting.comphone: 1-888-813-0444 presented by douglas greer creating and maintaining...
Post on 01-Apr-2015
216 Views
Preview:
TRANSCRIPT
www.regoconsulting.com Phone: 1-888-813-0444
Presented by Douglas Greer
Creating and Maintaining Business Objects Universes
www.regoconsulting.com Phone: 1-888-813-0444
2
● Software & Setup Required● The Basics● Hands On● Tips & Tricks● What’s Coming (Clarity 13.4 Changes)● Q&A
Overview
www.regoconsulting.com Phone: 1-888-813-0444
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
www.regoconsulting.com Phone: 1-888-813-0444
4
The Basics
www.regoconsulting.com Phone: 1-888-813-0444
5
● Reporting tool (like Crystal Reports)● Included free with Clarity● Browser-based - nothing to install● Integrates with Clarity
What is WEBI
www.regoconsulting.com Phone: 1-888-813-0444
6
● Translator – business language to query language● Visually build data model● Define a simplified view of the data● Build SQL Queries on the fly
What are Universes
www.regoconsulting.com Phone: 1-888-813-0444
7
What are Universes
www.regoconsulting.com Phone: 1-888-813-0444
8
● 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!
Implementing Ad-Hoc Reporting
www.regoconsulting.com Phone: 1-888-813-0444
9
Designer
www.regoconsulting.com Phone: 1-888-813-0444
10
Tables & Joins
www.regoconsulting.com Phone: 1-888-813-0444
11
Classes & Objects
www.regoconsulting.com Phone: 1-888-813-0444
12
Hands On
www.regoconsulting.com Phone: 1-888-813-0444
13
Tips & Tricks
www.regoconsulting.com Phone: 1-888-813-0444
14
● Copy & Modify CA OOTB Universes● Custom Universe Linked to OOTB● Hybrid● Pros & Cons
Overall Architecture
www.regoconsulting.com Phone: 1-888-813-0444
15
● Import, Export, and Save● Refreshing Table Structure● Integrity Check
Designer
www.regoconsulting.com Phone: 1-888-813-0444
16
● Controls○ Row Limit○ Time Limit
● SQL Parameters○ ANSI92○ DISTINCT_VALUES
Universe Parameters
www.regoconsulting.com Phone: 1-888-813-0444
17
● Alias every table● Set JOIN type properly (INNER vs. OUTER)● No loops● How to correct a loop
Tables & Joins
www.regoconsulting.com Phone: 1-888-813-0444
18
● Use Clarity Terminology● Hide OOTB Folders & Objects that aren’t used● Use Detail fields to hide primary keys
Classes & Objects
www.regoconsulting.com Phone: 1-888-813-0444
19
● Replace WHERE clause with CASE statement
Classes & Objects
www.regoconsulting.com Phone: 1-888-813-0444
20
● Push measure aggregation to the database
Classes & Objects
www.regoconsulting.com Phone: 1-888-813-0444
21
● Add descriptions● Add object formatting at the universe level● Add relative date objects
Enhancing Universes
www.regoconsulting.com Phone: 1-888-813-0444
22
● 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
Migrating Universes & Reports
www.regoconsulting.com Phone: 1-888-813-0444
23
● Print (if you have PDF printing software)● Save As…PDF● Universe Documenter
○ http://bukhantsov.org/2011/09/universe-documenter/
Documenting a Universe
www.regoconsulting.com Phone: 1-888-813-0444
24
Documenting a Universe
www.regoconsulting.com Phone: 1-888-813-0444
25
● Business 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
www.regoconsulting.com Phone: 1-888-813-0444
26
What’s Coming – Clarity 13.4
www.regoconsulting.com Phone: 1-888-813-0444
27
What’s Coming – Clarity 13.4
www.regoconsulting.com Phone: 1-888-813-0444
28
What’s Coming – Clarity 13.4
www.regoconsulting.com Phone: 1-888-813-0444
29
Questions
Contact US888.813.0444
Email Contactinfo@regoconsulting.com
Web Sitewww.regoconsulting.com
Thank you.
top related