The desktop edition of Interactive Analysis is what was previously known as Web Intelligence Personal. It provides for the self-service of data analysis on the part of data savvy individuals. As one of these individuals, you would normally have a good idea of what the data means for your specific needs within an organization and do not have the time to wait for IT to create your reports. Through the use of the desktop edition of Interactive Analysis, you are able to analyze data from multiple sources in both online and offline capacities. Once you have completed your analysis, you can then share your insights with other members of your organization. The end result is a streamlined process of data analysis that can be achieved either singularly or in collaboration with others.
For those that are familiar with Web Intelligence, you will recognize the interface and the features of the Interactive Analysis client. Those that have not yet used Web Intelligence will be able to take advantage of the intuitive nature of the interface and the one-click analysis functions as a starting point to interactive analysis. From there, more advanced ad hoc query and analysis features will become useful as you begin to dig deeper into the data to make connections and start piecing together a story from your analysis sessions.
Some of the more useful aspects of the desktop edition of Interactive Analysis are:
The ability to use an existing report as a starting point for your analysis
You can easily use one of the existing reports as a starting point for you own analysis. For example, you could have a report that shows the margins by product category…
…and you could easily turn this into a report that shows the margins by product line within each category.
This was done by simply adding a section on “Category” and replacing “Category” inside the table with “Line”. So, we can now see, for example, the margins for the “Jackets” line within the “Boatwear” category.
The available one-click analysis features
There are a myriad of different one-click analysis features that will allow you to quickly filter and analyze the data down to the parts that are more applicable and interesting to your purposes. For example, you have the ability to quickly insert breaks, sort the results, perform one-click calculations, insert a new row or column, and enable the track data changes features – which quickly shows what data has changed since the last refresh of the report.
In addition, you have the ability to quickly:
Add an Alert
Set the Ability to Fold and Unfold Sections
Filter the Data
and Add One of the New Input Controls
The ability to create new reports from multiple data sources
It is also easy to setup queries against multiple data sources. Starting from an existing report you just need to click on “Edit Query” and then on “Add Query”.
Once you click on “Add Query”, you will see a window that lets you choose whether you want to add a query from an existing Universe or from another type of data source.
If you were to choose “Other data source”, you would then get to choose whether you wanted to your additional data source to be a Text or Excel file OR a Web Service.
If you were to choose “Universe”, then you would get the option to choose your Universe and create your new query via the normal Query Window. You can see from the screenshot below that I know have two query tabs for “Query 1” and “Query 2”.
An additional benefit of utilizing multiple data sources is that you can use the results of one query to filter another. This is done by using the query on query feature. When defining a query filter in the presence of a multiple query report, you will see the option to use the “result from another query”.
The ability to perform your analysis offline
Finally, it is very important to note that any of your analysis within a report can be done in an “offline” capacity. This means that, out of the steps that I performed above, all of them were performed offline except for the adding of the additional Universe-based query. All of my analysis outside of this one feature was performed without being connected to an SAP BusinessObjects Enterprise deployment. This is great for when you need to perform analysis “on the go”.