Blog

It’s one of the most common problems in Web Intelligence reports. You’ve got rows and rows of data that you want to condense and flatten into a more horizontal format that is easier for your end-users to consume. This session will offer clear and easy-to-understand solutions for how you can pivot, flatten, and simplify the output of your Web Intelligence reports.

First impressions matter – even for reports! This session will be covering how to use formatting shortcuts and templates to make a meaningful report stand out and shine.

VIEW THE SLIDES

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.

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.

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

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/

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