BI Development Sessions

Back to Tracks and Agenda

Creating Cross Tables in WebIntelligence v4.x From Basics to Advanced!

Michael Ward – Creative Technology & Training Solutions

In this session, you will learn a variety of ways to create Cross Tables in WebIntelligence v4.x. Topics will include using Turn Into, how to properly use the Report Element Tab, and using Assign Data to create a Cross Table.  You will learn how to create a master detail report with a Cross Table as the detail report. There will also be a section on how to apply calculations to a Cross Table and how to apply block features such as alternating rows, and turning on report headers to a Cross Table block.  You will learn how to apply the various reporting functions to a Cross Table, including Break, Rank, Sort, Local Filter, Outlining and Ranking.

Creating Formulas and Variables in Web Intelligence: From The Basics To Advanced

Michael Ward – Creative Technology & Training Solutions

This session will focus on the basics of building formulas and variables.  Learn how to convert a formula to a variable.  Learn how to utilize functions in your formulas and variables.  Learn advanced calculation features such as the use of Context Operators, and building date formulas.

Crystal Reports 2013 – Best Practices

Paul Gonzales – InfoSol Inc.

A collection of Best Practices for the development of Crystal reports will be discussed including: naming conventions, formula standards, aesthetic considerations and visualization standards and purpose.

Crystal Reports 2013 vs. Crystal for Enterprise

Paul Gonzales – InfoSol Inc.

In this session, we will explore the paradigm shift in moving from Crystal Reports 2013  to the Enterprise edition. Just how similar are the products?  Does  Enterprise have all the features  of CR 2013?  We will also discuss the use of the semantic layer versus using a database as a data source.

Crystal Reports 2013 – Developing an Effective Testing Strategy and How to Manage the Migration Process

Paul Gonzales & Evan Davies – InfoSol Inc.

Best practices in setting up effective testing strategies for Crystal Reports will be discussed.  In addition, a case study from a migration involving the testing of over 7000 Crystal Reports from a legacy version to the BI 4.1 platform will be presented.

Crystal Reports 2013 – Making Your Report More Interactive

Paul Gonzales – InfoSol Inc.

Crystal offers a variety of ways to make your report more interactive and even perform like a dashboard. In this session we will explore the different things we can do in a report to make it more interactive such as: drill down, prompts that suppress sections, prompts to highlight data, and sub-reports.

Crystal Reports 2013 and Web Intelligence Face-Off

Paul Gonzales – InfoSol Inc.

Synopsis: In this session we will explore and pros and cons in Crystal Reports and Web Intelligence side-by-side. We will determine the role and uses of each reporting tool within the SAP BI stack.

Dazzle Your Web Intelligence Reports with Conditional Formatting

Michael Ward – Creative Technology & Training Solutions

In this session you will learn how to apply conditional formatting to your report blocks as well as how to create different types of rules, including cell format, text and variable, and how to turn on and off the rules as required.  More advanced uses of conditional formatting in Cross Tables and Master detail reports will also be demonstrated.

Highs and Lows of Adopting SAP BusinessObjects for BW at British America Tobacco (BAT)

Mark Cooper – British America Tobacco

British American Tobacco is halfway through a journey to implement a global ERP solution with SAP BW7.3 and SAP BusinessObjects BI4.x delivering the BI. Attend this session to understand why BAT chose BusinessObjects over BEx and benefits along with the challenges that have ensued. The session will focus on a number of areas including:  [expand title=”continue reading…” alt=”continue reading…” swaptitle=”collapse”]

  • Technical Architecture considerations including sizing
  • Rationale for choosing Crystal Reports for Enterprise over Crystal Reports 2011 and subsequent experiences
  • Bridging the gap left by BEx WAD while BAT waited for BusinessObjects Design Studio
  • Experiences with the new OLAP “Analysis” family of reporting tools
  • Pros and Cons of BO integration with SAP BW vs. direct connect to SAP
  • Customizations, Challenges and Success stories[/expand]

No More Boring Reports: How to Create an Interactive Web Intelligence Solution

Adam Lange – Lake Tahoe Community College

Lake Tahoe Community College has created several strategic-level Web Intelligence reports using the SAP BusinessObjects XI 3.1 platform. These are no ordinary reports with boring data tables. These are engaging reports with lots of interactive features: prompts, drill-downs, input controls, quick filters, hyperlinks, and more.

LTCC has employed many of WebI’s most powerful features to develop flexible reports which managers can use to get the precise information they need when they need it.  This case study will discuss the business problems these reports addressed and the outcomes of the project. This session will also include technical information on how each interactive feature was implemented.

Mobilizing BI for Business Objects

Bree-Anna Mustad – InfoSol Inc.

In the ever-expanding mobile world ,  it is important to consider the best way to view BI content on a mobile device. This session will discuss ways to develop mobile content from the  various BO tools such as Web Intelligence, Dashboard (Xcelsius) and Explorer.

Prompts, Parameters and LOVs in Business Objects 4

Allan Williams – Manitoba Public Insurance

This presentation will focus on creating prompts, Parameters and LOVs in Business Objects 4 in addition to the concept of Cascading Prompts. We will show how to create a prompt at the report level using the default LOVs created by Business Objects.  [expand title=”continue reading…” alt=”continue reading…” swaptitle=”collapse”]

In addition, we will show how to create custom LOVs either at the Data Foundation or Business Layer level and illustrate how to use these custom LOVs in the creation of Cascading Prompts that can be used in Web Intelligence Reports.  Takeaways:

  • An understanding of how prompts work in Web Intelligence
  • An understanding of how to create Parameters and associate a custom LOV to the Parameter
  • Understanding how to create custom dynamic cascading Prompts in Business Objects[/expand]

Report Filtering in WebIntelligence v4.x

Michael Ward – Creative Technology & Training Solutions

In this session, you will learn how to create query filters and local reporting filters.  Attendees will learn about the differences between a query filter and a local filter.  Topics include how to properly utilize the various operators in a query filter. You will learn how to make static query filters dynamic by using the prompt feature. Also included will be an in-depth look at prompts and prompt properties and how they can affect your report. Topics will include how to mix and’s and or’s properly in query filter. You will also how to utilize wildcarding in your query filters.  [expand title=”continue reading…” alt=”continue reading…” swaptitle=”collapse”]

Attendees will learn how to create local filters and apply those filters to blocks in the report document, including report and chart blocks. There will a section on how apply local filters at the report tab level and how that affects the local filtering. You will also learn how to utilize both the query and report filter templates to provide detailed information on filters. A major topic will also include creating and applying input controls to a report/chart block.[/expand]

Take Web Intelligence to the Next Level with Advanced Formula Techniques

Adam Lange – Lake Tahoe Community College

Web Intelligence is a wonderful tool for simple ad hoc queries and basic data extracts. But beyond those basic features lies a powerful formula editor that developers can use to solve complex reporting problems.  [expand title=”continue reading…” alt=”continue reading…” swaptitle=”collapse”]

  • Have you wondered how to perform calculations based on previous or future row values? Web Intelligence can do that.
  • Have you wondered how to calculate percentages of a grand total? Web Intelligence can do that.
  • Have you wondered how to do conditional aggregation, like the SUMIF function in Excel? Web Intelligence can do that.

This session will cover the advanced functions and formulas that every Web Intelligence guru should know. It will also include examples of how Lake Tahoe Community College applies these techniques to real-world reporting scenarios.[/expand]

Web Intelligence Rich Client: Tips and Tricks from the Master

Michael Ward – Creative Technology & Training Solutions

This session will provide an in-depth look at how to bring in personal data providers, such as text and Excel, to a Webi Rich Client document.  Attendees will learn how to properly synchronize common dimensions, and how to “fix” format issues with dimensions. Presentation will also include a section on various tips and tricks for extending Webi Rich Client documents for use by pure WebIntelligence users. It will also include a section on how to utilize personal data files for filtering in a document.

Back to Tracks and Agenda

Speak Your Mind