Tucson BusinessObjects User Group – September 12th 2019


Tucson Police Department

1310 W. Miracle Mile

Tucson, AZ  85705

Room: Rillito Meeting Room


12:30 – 1:00 pm | Check-In

1:00 – 1:10 pm | Welcome & Announcements

1:10- 1:45 pm | Building Web Intelligence Dashboards – Part 1 – Roxanne Pittman, InfoSol Inc

In this session we will create a Webi Dashboard use the 80/20 rule to  focus attention on the top performers and also incorporate Trend charts with shared elements.

1:45- 2:20 pm | Using Excel Files In Web Intelligence – Michael Ward, CTTS

This presentation will provide the user with a variety of ways Excel files can be used in reporting. It will include using Excel as a data provider, using Excel for a bridge file when encountering incompatible format types, as a dynamic filer file, and other uses.  IT will include an in-depth look at how to properly import an Excel files, where to store the Excel file, and how to update an Excel file without breaking the Webi Document.  It will include some nice tips and techniques when using Excel files. It will open your eyes to the real power of an Excel file.

2:20- 2:35 pm | Leveraging formulas in WebI – Ozlem Kacira, Pima Community College

We will show how complex formulas have been implemented in the reports to compare different snapshot data rather than using nested or subqueries. Also we will show how to add scrolling html marquee to make more attractive dashboards.

2:35- 2:50 pm | Break & Networking

Enjoy some delicious snacks and drinks.

2:50- 3:25 pm | Building Web Intelligence Dashboards – Part 2 – Roxanne Pittman, InfoSol Inc

This session will demonstrate how to add conditional formatting to a chart and use a dual slider to view data more precisely.  We will also show how to display key data points on chart – showing beginning, low, high and ending points for quick analysis.

3:25- 4:00 pm | IDT Overview – Michael Ward, CTTS

A high level look at building universes with the new IDT. Learn about creating connections, building the data foundation layer,  adding a business layer, and applying security profiles. Also learn about creating LOV’s and combining those with Parameters. Defining Context,  adding aggregate awareness, and sharing project will also be covered.

4:00 – 4:15 pm | Raffle & Prizes

Map/Directions to the UC Health Business Center – Cincinnati BOUG

The Seminar will be held at the UC Health Business Center at 3200 Burnet Avenue, Cincinnati, OH 45229.  This building is located on Burnet Avenue across from the University of Cincinnati Medical Center.


I-75 North/South – Exit at the Hopple Street interchange.  At the end of the ramp, turn left.  At the first stoplight, travel through the intersection and continue up the hill.  This road is Martin Luther King Drive.  Continue on Martin Luther King, driving past the west campus of the University of Cincinnati until you reach the medical center area.  Continue to the top of the hill, then turn left onto Burnet Avenue.  The Business Center is on the right (3200 Burnet).

I-71 South – Exit at William Howard Taft Road.  Turn right at the first light onto Reading Road.    Go to third light and turn left onto Martin Luther King. Go to second light and turn right onto Burnet.  The Business Center is ahead on the right (3200 Burnet).

I-71 North – Exit at Reading Road.  Travel north.  At the fourth stoplight, Reading splits.  Stay to the left.  This is now Burnet Avenue.  Proceed on Burnet.  The Business Center is on the right side (3200 Burnet).

I-471 North – After crossing the river, take the Liberty Street exit.  At the end of the ramp, turn right onto Reading Road going north.  At the fifth stoplight, Reading splits.  Stay to the left.  This is now Burnet Avenue.  Proceed on Burnet. The Business Center is ahead on the right (3200 Burnet).

When you arrive at the building you should park in the garage located to the south of the Business Center.  If the gate is down, take a ticket and you will get a validation ticket for when you exit.

Take the garage elevator down to the ground floor and enter at the South Entrance and follow the signs to the RITE TRAINING ROOM.

UC Health Business Center Map

Grand Rapids BusinessObjects User Meeting: Tuesday, October 13th

Back to BOUG Overview

You are personally invited to join us at the next information packed Grand Rapids BusinessObjects Users Meeting on Tuesday, October 13th, 2015, 8:30 am– 4:00 pm hosted by Creative Technology & Training Solutions and InfoSol Inc.  Attendance is free; however, we do ask that you register for count purposes.


University of Farmers
5665 N Kraft Lake Drive
Caledon, MI 49316

KM2 building –Franklin Room MAP
Parking is available on either side of the building

8:30 – 9:00 am Registration

8:45 – 9:00 am Introduction

9:00 – 10:00 am Data Profiling in Data Services

While SAP Information Steward is the primary tool for data profiling, technical data profiling can actually be done directly in Data Services. In this session you will see through demonstration how you can go beyond simple viewing of the data to actually conducting a thorough analysis of your data. This in turn provides you with great information to building better jobs in Data Services. You will see how the data profiling process will produce a statistical analysis that includes Frequency Distribution, Distinct Values, Null Values, Minimum / Maximum Values, Data Patterns, Comparisons of values between data sets and Drill-down capabilities to view specific records.

Doug Evans, InfoSol Inc.

10:00 – 10:15am Break

10:15 – 11:30am Top 3 Cases for location Intelligence and BI

Top business cases and tips for injecting maps into your BI implementation. Extract knowledge taken from hundreds of customer stories and learn how to gather and transform requirements into amazing location intelligence solutions.

Ryan Goodman, Centigon Solutions

11:30– 12:45 pm Lunch: On Your Own

12:45 – 1:30 pm Containing Content Chaos

This session will look at various challenges and costs of content chaos within a BI environment, considerations for developing a system storage strategy for overcoming that chaos, and effective use of technologies which target the reduction and containment of content growth.

Alan Golding, APOS

1:30 – 2:30 pm Mobilizing your Xcelsius Dashboards

We will explore how to effectively turn an Xcelsius Dashboard into a mobile HTML5 equivalent. When designing the dashboard, you need to keep in mind that on mobile devices you won’t have the pinpoint precision selection of a mouse, but rather users will be using their fingers. We will investigate how you can determine which dashboard components are mobile compatible and see how a converted dashboard can be accessed in different ways.

Doug Evans, InfoSol Inc.

02:30 – 2:45 pm Break

02:45 – 3:30 pm Building Master Detail Reports in Webi v4.1 SP6

This presentation will show you how to create master detail reports in v4.1. It will highlight those features that have changed from v3.1. It will also provide some great tips and techniques that can be applied to master detail reports, including hiding blocks, sections and objects, and conditional formatting.

Michael Ward, CTTS

03:30 pm Wrap-up

Note: This event is not sponsored by SAP or ASUG. Presentations subject to change

San Francisco BusinessObjects User Meeting: Monday, September 28 | 830am-400pm

Back to BOUG Overview

You are personally invited to join us at the next information packed San Francisco BusinessObjects Users Meeting on Monday, September 28, 2015, 8:30 am– 4:00 pm hosted by Creative Technology & Training Solutions and InfoSol Inc.  Attendance is free; however, we do ask that you register for count purposes.


County of San Mateo
400 Harbor Blvd.
(Ralston Exit from 101)
Belmont, CA


8:30 – 9:00 am Registration – Breakfast Provided by County of San Mateo (Free)

8:45 – 9:00 am Introduction

9:00 – 10:00 am Limitless Business Intelligence –Let’s Speak BO

There are many good reasons why SAP BusinessObjects is still the best BI suite on the planet. Most notably is the totally amazing and limitless business intelligence application that organizations are creating with it every day. Interestingly, many are finding that this can be done without making huge investments in new technology but by simply understanding and using the capabilities that exist in the core BO tools. This session will discuss what has been happening with and around BusinessObjects in the last 12 months, show some truly Limitless Bi solutions using BO and explain why the “Let’s Speak BO” movement is on fire.

Paul Grill, InfoSol Inc.

10:00 – 10:15am Break

10:15 – 11:30am Multiple Data Providers: It’s a Whole New World

This presentation will be a live demo of how to add multiple data providers to a document. It will include a section on how to synchronize your data by merging or linking real dimensions. It will include tips and tricks and best practices.

Michael Ward, Creative Technology & Training Solutions

11:30– 12:45 pm Lunch: Provided by County of San Mateo (Free)

12:45 – 1:30 pm Using BusinessObjects BI Solutions to Improve Supply Chain Management

Business Intelligence is changing the way we look at every aspect of our business or operation. One area where it has enormous impact is Supply Chain Management.
This session will present and discuss three recent case studies of how using the BusinessObjects BI tools in supply chain management processes brought about remarkable positive change and results. This will include a global mining company that implemented a spend analytics solution resulting in tens of millions of dollars in annual savings.

Paul Grill, InfoSol Inc.

1:30 – 2:30 pm Introduction To the IDT

This live demo/presentation will provide an in-depth look at building universes with the IDT. It will include a project, creating connections, building the data foundation, adding a business layer, and security. It will include best practices as well

Michael Ward, Creative Technology & Training Solutions

02:30 – 2:45 pm Break

02:45 – 3:30 pm Turbocharged Mobile BI Dashboards for the Masses

It has taken a while for the adoption of BI applications on mobile devices for a variety of reasons but now it is possible to create custom mobile BI dashboards applications without coding that can handle large amounts of data with excellent response times.

Xcelsius Dashboards (aka SAP BO Dashboards) have been hugely successful as both the visual interface of many BI solutions as well as delivering complete BI applications. In the latest release of BI 4.1 and Dashboards 4, it is now possible to generate the dashboards in HTML5 and deploy them to both mobile and Web. When this is combined with intelligent data caching, the result is amazing and fast mobile BI applications.

In this enlightening session, we will look at this new capability and show example case studies of some of the turbocharged mobile applications in action.

Paul Grill, InfoSol Inc.

03:30 pm Wrap-up

This event is not sponsored by SAP or ASUG. Presentations subject to change

BusinessObjects User Group Meeting Registration

Thank You for Registering!

Thanks for Registering!

We look forward to seeing you at this BusinessObjects User Group meeting!  If you signed up for our newsletter, we believe in the Golden Rule: No spam – and you can unsubscribe at any time.

You will receive email reminders leading up to this event, see you there!