Blog

What's New in BI 4.3

by Runali Ghosh on July 20, 2021 No comments

It may not be an understatement to consider the recent SAP BI 4.3 release as a huge milestone. This comes entirely with the new FIORI-based interface and offers a modern and new experience for ad-hoc and operational reporting as well as designing visually rich dashboards with Web Intelligence. While this is a great foundational step towards future analytics it is also quite a transition from the classic launchpad. This session will summarize the key usability and functionality changes that Webi consumers and developers would potentially come across while transitioning from WebI 4.2 to 4.3.

read more
Runali GhoshWhat's New in BI 4.3

Writeback with Squirrel Through Webi!

by Amy ONeel on July 6, 2021 No comments

This session will show users how the exciting Squirrel dashboarding tool can be used to create a writeback application while hosted inside a Web Intelligence report. Watch as we take you through the process of setting up this innovative idea which users can use to springboard their own implementation.

read more
Amy ONeelWriteback with Squirrel Through Webi!

Achieving Complex Calculation With Webi Custom Context

by Runali Ghosh on June 22, 2021 No comments

Calculating aggregation at different levels to slice and dice data is a frequent requirement in the world of BI. Web Intelligence provides a very efficient method to perform aggregate calculations against not only different levels of granularity but also display them together. A very simple example will be to show the Revenue by City and by Country in the same table side by side in the same row. But there are more scenarios in which customizing the calculation context is necessary. As fairly a commonly used feature it is, the advanced use can often be intimidating.

In this session, we will cover some of scenarios in details and go beyond showing basic aggregate at the same row. Knowing this feature will also eliminate the need to export the data out of WebI into excel frequently for detail analysis. Understanding the concept will allow you to recreate many day-to-day spreadsheet activities easily within WebI itself and encourage users to stay more within BI system.

read more
Runali GhoshAchieving Complex Calculation With Webi Custom Context

The Murky Morass of Merged Dimensions

by Roxanne Pittman on June 8, 2021 No comments

Frequently in Web Intelligence, we need to bring in data from different sources which necessitates the creation of “merged” dimensions. This session will cover scenarios for when merged dimensions are necessary, when to use extended merged and auto-merged dimensions and what the rules are for successfully working with merged dimensions and how knowing these rules can help us navigate this murky topic.

VIEW THE SLIDES

read more
Roxanne PittmanThe Murky Morass of Merged Dimensions

Creating Column Charts with Custom Images in Columns

by Heather Rapetti on May 25, 2021 No comments

Column charts are a great way to show data comparisons in a visual way. In this session you will learn how to make your Webi reports and dashboards even more exciting by using a custom image or graphic in place of the standard columns in the chart.

View the PowerPoint Presentation

Where did this concept come from?

https://www.speakbo.com/webinars/fun-formatting-with-webi-workarounds/

Photo Editing tool used:

https://pixlr.com/

read more
Heather RapettiCreating Column Charts with Custom Images in Columns

The Magic of Breaks

by Michael Ward on May 11, 2021 No comments

This presentation provides an in-depth look at applying breaks to report blocks. Topics include:

  • Adding Single/Multiple Breaks
  • Adding Group Breaks
  • Managing Your Breaks
  • Removing redundant headers and footers
  • Value based breaks
  • Automatic subtotals when applying breaks
  • Other Break format options
  • Tips and tricks to get the most out of the Analysis Toolbar
read more
Michael WardThe Magic of Breaks

Recreating SQL "Partition By" with Web Intelligence to Display Detail Row and Aggregates Together

by Runali Ghosh on April 13, 2021 No comments
Calculating aggregation at different levels to slice and dice data is a frequent requirement in the world of BI. Web Intelligence provides a very efficient method to perform aggregate calculations against not only different levels of granularity but also display them together. A very simple example will be to show the Revenue by City and by Country in the same table side by side in the same row.
In this session, we will explore the different scopes and ways this capability can be utilized. This will also offer an alternate way to obtain the same result as “PARTITION BY” – a clause frequently used in SQL to achieve complex calculations related to aggregation. This clause divides a query's result set into partitions. Although an option, Custom SQL is often not accessible to many WebI users and brings other challenges. Knowing the WebI technique will be a great addition to eliminate those limitations and extend your options for complex analytical calculations.
read more
Runali GhoshRecreating SQL "Partition By" with Web Intelligence to Display Detail Row and Aggregates Together

Creating Webi Dashboards that Blow Your Socks Off! Part 2

by Amy ONeel on March 30, 2021 No comments

You ask for it, you got it! In response to requests for more Dashboarding tips, we’ve put together some detail on some of the other methods we often use in creating “Socks-off!” dashboards in Webi. We’ll cover a plethora of details on images and symbols as well as usage and limitations of the new Time Dimension feature. We’ll finish up the presentation with some lesser known chart formatting options in Webi to get to the final look and maximum meaning we want in our dashboards.

read more
Amy ONeelCreating Webi Dashboards that Blow Your Socks Off! Part 2

Compare and Contrast Charts - WebI Vs Tableau

by Rajesh Ponnurangam on March 16, 2021 No comments

A chart transforms your data into Actionable insights. Do you want to know how Web Intelligence charts compare against Tableau? Join this webinar where Rajesh Ponnurangam from Infosol will compare the charting engines in Web Intelligence and Tableau.

read more
Rajesh PonnurangamCompare and Contrast Charts - WebI Vs Tableau

Intuitive Report Filtering with Element Linking

by Roxanne Pittman on February 2, 2021 No comments

Setting up Element Linking in Webi Reports is easy and can greatly expand your on-report filtering options. From “dashboard” like menu selectors to chart “drilling”, this often overlooked functionality in Webi is a cool tool for the Webi report developer. This session will show creative ways of using Element Linking to drive decisions and expand insights in Web Intelligence.

read more
Roxanne PittmanIntuitive Report Filtering with Element Linking