Web Intelligence and Crystal Reports

Back to Tracks and Agenda

What’s New in Web Intelligence v4.1!

Michael Ward, Creative Technology & Training Solutions

This exciting and enlightening presentation will provide an overview of v4.1. It will include a look at the new BI Launchpad and how to navigate it successfully. It will provide an in-depth look at the new Report Viewer Window and the new “Ribbons” concept. Throughout the presentation there will be comparisons to v3.1 versus v4.1. This presentation will provide an excellent foundation to all the remaining presentations on the WebIntelligence track. All topics covered will be demonstrated through live demonstrations of the product!

Web Intelligence: Interactive Charts and Document Linking

Allan Williams, Manitoba Public Insurance

Web Intelligence 4.1x provides a very powerful charting engine.  This presentation will illustrate creating a Webi report containing multiple charts that interact with one another – in other words, achieving Dashboard functionality within a Web Intelligence Report.  Another powerful feature is Document Linking, the ability to “drill-down” from a master report to a detail report.  This presentation will show how this functionality can be achieved.

SQL Programming Tips for Crystal Developers

Adam Lange, A. Lange Consulting LLC.

SQL programming is a critical skill for business intelligence administrators and power users. Writing a SQL snippet for a custom field, developing free-hand SQL queries for Crystal Reports, building a database view, and developing a Universe derived table are just a few examples of how you can leverage SQL to achieve complex reporting objectives.

This session will offer an overview of SQL tips most relevant for Crystal Report developers. Attendees will learn the differences and applications of database views, stored procedures, custom fields, derived tables, and more. We will also explore SQL querying methods, including If/Then/Else statements, how to flatten data, how to aggregate data, and how to perform sub-queries.

Running Crystal Reports — Even When Your Database Isn’t

Don Collins, Connected BI Solutions, Inc.

Sometimes the best way for your users to remain connected in our increasingly connected world is to disconnect. Or, at least: Have the ability to do so and still gain data insights.

Based on an actual customer case study, this session explores a powerful and often-overlooked feature of Crystal Reports that allows non-technical users to perform relatively powerful analysis on the data that interests them, even when they are disconnected from their underlying datasource, using no more that the easy-to-use (and free) SAP Crystal Reports Viewer.

In addition to report design strategies to make the most of Crystal’s disconnected-environment features, this session also covers a self-service strategy allowing your users to decide when they wish to work online and when they wish to “check out data” for analysis offline. Lastly, a unique strategy for implementing row-level security for non-universe Crystal Reports (traditionally only available with universes) is presented.

Even if your users are always connected, this session is bound to inspire and equip you to look at Crystal in a whole new way and harness its hidden power.

How to Get Business Users Thinking Spatially With Maps and Webi

Ryan Goodman, Centigon Solutions Inc.

Why use Google Maps in enterprise reporting? That is the million dollar question that we will answer in this session where you will learn not only “why” but how to engage business users and create map templates that can be used directly inside of Webi with just a few clicks.

Optimizing Response Time and Productivity

Jean-Francois Cayron, Sagitta BI

How you approach the design of the overall visualization solution will deeply impact performance as perceived by the consumer. An adequate selection of techniques from the query design to report distribution will allow your organization to optimize the user experience.  Learn how to achieve success by combining Query Stripping, Scheduling, Document Linking and more.

Let’s Get Crystal Clear with Crystal Reports

Rajesh Ponnurangam, InfoSol Inc.

Is Crystal Enterprise the new version of Crystal Reports? How different is Crystal Enterprise compared to Crystal Reports 2013/2011/2008. What are the architectural changes in Crystal Enterprise? What are the different data connectivity options for Crystal Enterprise? Which version of Crystal Reports is best suited for SAP data sources – specifically SAP BW & HANA? Do I need to convert Crystal 2008/2011 reports to CR Enterprise? This session will address all of the above questions. Demo showing the differences between Crystal 2013 and CR Enterprise will be discussed.

Web Intelligence: Customizing the Product for a Mission-Tailored Tool

Jean-Francois Cayron, Sagitta BI

Web Intelligence has grown in features but also complexity over the years, it is very powerful and appeals to advanced report designers, but may prove to be a bit overwhelming or confusing for the casual user. Learn how to customize every aspect of the tool specifically for each segment of your audience.

What’s New in v4.1: Advanced Reporting Techniques

Michael Ward, Creative Technology & Training Solutions

This presentation will provide an in-depth look at how to convert reports into other report types. There will be an emphasis on creating Master Detail Reports. It will include many of the new features of v4.1, including how to hide columns, blocks and sections. You will learn how to apply conditional formatting to a Master Detail Block! You will learn how to place both a report and a chart in a Master Detail Report. You will also learn how to navigate a Master Detail Report utilizing the map tab. Other interesting report features will be covered as well. All topics covered will be demonstrated through live demonstrations of the product.

InfoBurst with Crystal – The Science Behind the Shine

Rajesh Ponnurangam, InfoSol Inc.

Hear how one of America’s largest supermarket chains implemented InfoBurst to deliver Crystal Reports to 1500+ Stores. This case study covers migration of Crystal Reports from Crystal Enterprise 9 to Crystal 2013 and replacing their existing job scheduler with InfoBurst. An A to Z design guide for bursting Crystal Reports with InfoBurst will be discussed.

Dazzle Your Web Intelligence Reports with Conditional Formatting

Michael Ward, Creative Technology & Training Solutions

In this 1 hour session you will learn how to apply conditional formatting to your report blocks. You will learn 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.  It will also include a section on how to give your reports more of a dashboard like look.  You will also learn how to link multiple blocks, including reports and charts.  The presentation will consist of a live demo of all topics covered.

Introduction To Formulas and Variables in v4.1

Michael Ward, Creative Technology & Training Solutions

This presentation will provide an in-depth look at how to convert reports into other report types. There will be an emphasis on creating Master Detail Reports. It will include many of the new features of v4.1, including how to hide columns, blocks and sections. You will learn how to apply conditional formatting to a Master Detail Block! You will learn how to place both a report and a chart in a Master Detail Report. You will also learn how to navigate a Master Detail Report utilizing the map tab. Other interesting report features will be covered as well. All topics covered will be demonstrated through live demonstrations of the product.

Calculations in Web Intelligence V4.1 from Basic to Context

Michael Ward, Creative Technology & Training Solutions

This 1 hour session will cover the basics of creating calculations up to the most advanced features. It will include creating formulas, converting to variables, and creating variables directly. It will include an in-depth look at the function library. The presentation will also include a detailed look at utilizing dates in your calculations. There will also be an in-depth look at how to utilize Context Operators in your reports.  The presentation will feature a live demo of all topics covered.

Crystal Reports: Creating Customized Grouping

Oliver Prucha, InfoSol Inc.

Sometimes the grouping done at the database isn’t sufficient to get you all the numbers we are looking for so in this session we will learn how to create customized groups in Crystal Reports. We will create our custom group and deduce various KPI’s for the same.

Charting Data in Web Intelligence

Adam Lange, A. Lange Consulting LLC.

The charts offered in Web Intelligence XI 3.1 were notoriously limited in their functionality and effectiveness. In the latest version, Web Intelligence 4.1, SAP introduced many improvements to the chart engine which allow for better, more attractive, and more robust data visualizations.

This session will explore new and expanded visualization features, including heat maps, tree maps, box plots, combo charts, waterfall charts, tag clouds, and dual axis charts. Attendees will also learn about new interactive functions and formatting options.

Web Intelligence – Tables and Sections

Allan Williams, Manitoba Public Insurance

Web Intelligence provides two methods for grouping data – Tables and Sections.  This presentation will focus on the details of using both methods illustrating the benefits and limitations of each and how they can be used together.

Best Practices for Changing a Webi Document’s underlying Universe

Jake Tully, InfoSol Inc.

This presentation will teach users how to change the underlying Universe that Production reports are using, without causing any change to the CUIDs using the “Promotion Management” tool as well as Webi Rich Client.

Enhancing Call Center BI with Web Intelligence 4.1 Visualization

Mike Gurtler, Freeport-McMoran (FCX)

Freeport-McMoRan (FCX) implemented BusinessObjects 4.1 a year ago. With it came new features that begin to rival the interactive capabilities of other BI products in the marketplace. Mike Gurtler, an FCX BI lead, will demonstrate our Call Center Reporting and how we’ve put to use input controls, interactive chart elements, and drill through reporting to provide a more interactive experience.

Comments

  1. Best view i have ever seen !

Speak Your Mind

*