Let’s Speak BO Webinar: Recreating SQL “Partition By” with Web Intelligence to Display Detail Row and Aggregates Together

Back to Let’s Speak BO Webinars

April 13th, 2021 at 10AM PT/1PM ET

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.

SpeakBO has a NEW HOME

We are excited to announce SpeakBO Plus Plus.SpeakBO.com as the new home for all things SpeakBO!

If you would like to register for any of our upcoming webinars, you will need to setup a free account on Plus.SpeakBO.com.

With your free account you will have access to all upcoming webinars and events, you can stream the most recent webinar for 30 days after it runs, and you will get access to our BusinessObjects Updates section where we will be keeping you up to date on all things BO!

We also have an Extra and PLUS premium plan that will give you access to even more perks such as full access to our webinar library, Virtual BI 4.3 training, tips and tricks and best practices, a forum, and more!

Speak Your Mind

*