The SAP BusinessObjects Live Office application integrates with Microsoft Office using Microsoft’s Open Bridge Framework. We’ve created a live demo video entitled PowerPoints with SAP BusinessObjects Live Office which you can watch below. Live Office enables business users to embed corporate data from the data warehouse into Microsoft Office tools. This ability helps business users to become more self-sufficient, releasing them from their dependency on IT and providing them with ‘Self-Service BI’ access toTrusted BI data within the Microsoft Office tools they are familiar with. Once installed SAP BusinessObjects Live Office uses an intuitive wizard and integrated Microsoft Office tool bar to enable business users to select data easily from existing Crystal Reports and Web Intelligence Documents. Live Office users can also make ad hoc data selections based on a user friendly query panel that interfaces with the SAP Business Objects universe. Accessing the Single Version of the Truth quality assured data in this way increases user confidence in the accuracy of the data that is being analysed, consumed and shared. Live Office includes the functionality to instantly refresh data and change prompt parameter values. Live Office can also be used to feed Xcelsius Dashboards. Live Office documents can be published to SAP BusinessObjects business intelligence platform securely and then shared with colleagues as required. Live Office works with Microsoft Excel, Microsoft PowerPoint, Microsoft Word and Microsoft Outlook meaning that BI data can be directly embedded into your slide presentations and email messages. A practical example of beneficial use is to create a PowerPoint based management reporting slide deck pack. Many business users make the same presentations using the same slides over again but must continually capture numerous screen prints to remake the slide deck because the data values have changed. When Live Office is used the management reporting slide deck pack only needs to be created once. When next presenting just open the slide deck pack and then click ‘Refresh’ for the latest data!
So what is Web Intelligence and what can it do? We’ve created a short video of a live Web Intelligence demo. The video covers creating a new query, a table, a pie chart, a cross-tabulation, a calculation within a variable and an alert, drilling on a chart and then down through a product hierarchy in a table, finishing by creating a section.
SAP BusinessObjects Web Intelligence makes Self-service BI a reality by providing access to data in an intuitive information analysis product. By simply dragging and dropping objects into their reports users can gain business insights and turn these into true Business Intelligence for effective decision making. A business user can quickly create a query from scratch with a few mouse clicks. This is frequently termed ad hoc analysis or creating queries on the fly. Users can then format the retrieved information and analyze it to understand underlying data trends and root causes. The Web Intelligence interface is intuitive in design allowing business analysts and non-technical information consumers to ask spontaneous and iterative business questions of their data using their everyday business language. For example, users could easily create a query that allowed them to compare the performance of their top customers this year over last year. The user could then create their own variables, for example a forecast algorithm and add this to their report. Web Intelligence allows trends to be quickly identified along with sub-optimal areas. Users can drill down and drill across on their data. Web Intelligence access to the data is via a robust semantic layer known as the SAP BusinessObjects universe. The universe objects make query building easy and shields business users from needing to understand database technicalities. Multiple universes from different data sources can be combined in a single report.
The earliest versions of Web Intelligence were only available in thin client. In other words Web Intelligence had to be accessed via InfoView and a web browser. Web Intelligence is now available in the Rich Client version. This is loaded on to the users local machine. A report can now be viewed or developed on the local machine and then published to the BI Platform and shared and viewed as thin client via InfoView. This is great news for people working from home or on a train etc. They can now make changes to their Web Intelligence document off-line and then publish their changes next time they connect.