Blog

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

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.

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.