SAP BO Web Intelligence is a query, reporting, and analysis tool used to build reports from relational and OLAP data sources and to analyze data using features such as filters, conditional formatting, and data tracking.
Customizable Web Intelligence application interface
In the CMC, the BI administrator can change how the Web Intelligence interface appears for specific user groups. The BI administrator can customize interface elements such as toolbars or items within a toolbar, and customize access to specific document modes. The Customization panel is available in the Properties panel for a user group.
Table headers, columns and rows can be frozen
When you view a Web Intelligence report in Quick Display mode, you can freeze headers, rows, or columns in tables to keep them displayed as you scroll through data. You can freeze one or more zones of your table, depending on the type of table. The new Freeze button appears in the main toolbar.
Custom color palettes and color assignment in charts
You can personalize the appearance of charts in Web Intelligence reports by defining colors to dimension objects by using customized color palettes. You can set this color assignment on one or more dimension objects throughout all of the charts in a document using the Set as Default Colors option.
The automatic color assignment to a chart’s legend items generated by a palette can be made set to all instances of a chart in a document using the “Set as Default Colors” option. The default colors do not change when you apply refresh on open, drilling or filtering to a document.
Enhanced object merging in the Available Objects list
You can add and remove additional objects in a group of merged objects in the Available Objects list in the Side Panel
Merged hierarchies can be used in reports
You can now use merged hierarchies in reports. When objects in the same hierarchy are merged, the merged object replicates the hierarchy. A hierarchy merged with a flat dimension gives a hierarchy as the merged object.
Members with different parents in different merged hierarchies are replicated for each different parent in the merged object, along with their descendants.
Member Selector in the Query Panel allows you to define hierarchy depth Level based member selection on the default hierarchy can now be defined for BEx Hierarchy Node Variables. The hierarchy has to be set in the variable manager, otherwise no levels are available.
Only levels of the selected hierarchy are displayed; you cannot merge or set the maximum number of levels from all hierarchies.
Note – Levels must start from the root and you cannot skip the levels.
Web Intelligence usability enhancements
You can fold and unfold tables in Reading mode in the Web Intelligence HTML interface.
An object value selector is now available in the Formula Editor. When you are editing a formula that contains an object that has a list of values, you can display the available values by double-clicking values in the Available Objects pane. This makes the List of Values selector appear and you select the values you want to use in the Formula Editor.
In the toolbar above the Side panel, there is now an Edit data provider button that allows easier access to the Query Panel.
In the Query Panel, you can now execute a newly-added query without having to refresh all existing queries.
Auto-refresh is available at the server and document level
When you activate the Auto-refresh option in the document properties, the document is automatically refreshed.
The Auto-refresh option applies to the use of delegated measures. When this option is selected, the document is refreshed automatically when an object is added to or removed from the query, or when a different value is selected from a list in the Report Filter bar.
Query stripping support for relational data sources
Query stripping is a reporting feature that can be used to optimize performance. Query stripping is used only by Web Intelligence.
For relational universes, the BI administrator must enable the following parameters:
- The Allow query stripping option is selected in the business layer properties in the information design tool (unselected by default).
- The Enable query stripping option is selected in the document properties in Web Intelligence (selected by default).
- The Enable query stripping option is selected for the data provider in the query properties in Web Intelligence (selected by default).
Right-to-left alignment in Web Intelligence
In the Web Intelligence Applet interface and Web Intelligence Rich Client, the alignment of the application interface and document data is from right-to-left (RTL) when you select certain language locales.
Product locale and Right-to-Left interface alignment
When you choose Arabic for the Product locale, the Web Intelligence application interface elements are always right-to-left (RTL), in effect mirroring the left-to-right (LTR) alignment. For example, the side panel for an RTL locale is on the right, whereas in an LTR locale, the side panel is on the left.
Preferred viewing locale and Right-to-Left alignment
When you choose Arabic, Hebrew, Farsi, Urdu, or Divehi for the Preferred viewing locale, the elements and data in documents created in this locale are right-to-left (RTL). For example, in a cross table, in an LTR locale the side header column is on the left. In an RTL locale, the side header column is on the right.
Documents can be saved in CSV format in an archive file
In Web Intelligence Rich Client and the Web Intelligence Applet interface, you can save document data to the CSV archive format, which generates an archive file (.zip) that contains one CSV file per report. Each CSV file contains the report data without any headers, footers, or charts. You can have all or some of the reports in the CSV archive file.
Improved behavior regarding the #UNAVAILABLE message
The number of situations where the #UNAVAILABLE message appears has been reduced. When a smart measure (a database delegated measure) is used in a context of a dimension that is a formula, the expected value is returned. Previously, the #UNAVAILABLE error message was returned.
Report header and footer properties have been reorganized
There is a new specific property panel for the report header/footer settings, including the border property settings.
Single Sign-on support for HANA
You can now use Single Sign-on to connect to a HANA data source.
Enhanced universe support
ERP optional parameters that do not have a default value are now supported. ERP parameters can be consumed within Web Intelligence reports as optional prompts.
OLAP UNX universes can have their connection overloaded by a Business Security Profile. Web Intelligence reports created on this kind of universe take into account this security requirement.