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.