Using scheduled Webis to save on querying time

As mentioned in Chapter 8, Dashboard Data Connectivity, being able to schedule Web Intelligence (Webi) reports instead of running live queries for each and every query will help improve performance drastically.

Let's take an example where it takes two minutes to execute a query. If we were to have the dataset prescheduled instead of running live, we could retrieve the data in seconds rather than minutes.

There will be people who complain that your database architecture or query strategy is incorrect if it takes two minutes to execute a query. However, a lot of times it is impossible to speed up a query due to the sheer size of data or the amount of work it would take to re-architect the entire data warehouse.

Getting ready

Create a Webi document. In our example, we will create a simple Webi from the eFashion Universe that contains a crosstab with months as columns and stores as rows. Also, make sure that you have a Live Office connection as...