Skip to Content
Product Information
Author's profile photo Christian AH-SOON

SAP BI 4.3: What’s New In Web Intelligence and Semantic Layer

New, simplified and rejuvenated user interfaces for BI Launch Pad and Web Intelligence have been released in SAP BI 4.2 SP4 and improved in the following Support Packages (see here). These new interfaces, based on SAP FIORI and HTML5, came as a complement of the classic interfaces since they were not on parity:

  • Only a reader version of Web Intelligence was implemented.
  • Only a subset of BI Launch Pad features was available.

With the SAP BI 4.3 release, a new milestone has been reached. Main missing features have been implemented; which make the classic BI Launch Pad version as well as the Web Intelligence DHTML and Java clients obsolete. Only the new FIORI-based interface is released in SAP BI 4.3. No more HTML, Java, or Java Rich Client flavors, one single experience, common to both the Web and Desktop accesses!

Users who have not yet tried the new FIORI version released in SAP BI 4.2 might have to go through some change management to get used to the new interface. But this is balanced by:

  • Highly simplified and intuitive interfaces and workflows. Some more specialized interfaces such as the Query Panel or the Formula Editor remain the same, but have also got the FIORI skin.
  • Web Intelligence documents have not been changed and expose the same concepts and contents. Only the product user interfaces have been simplified.
  • Using FIORI as do other SAP products, which follow the same user interfaces and principles.

Some features are not yet implemented but will be offered in future Support Package 1 or 2. This first SAP BI 4.3 release is the foundation for future enhancements intended to make the Web Intelligence and Semantic Layer the main SAP analytics on premise offering to cover requirements for operational reporting, ad-hoc query, analysis and self-service dashboards. As investments and innovations will be done in this SAP BI 4.3 branch, no new innovations should be expected in SAP BI 4.2. This means that all coming SAP BI 4.2 SP8+ Support Packages will mainly contain fixes, corrections and updates on the supported platforms.

This article is a complement of the official SAP documentation and summarizes the new features in SAP BI 4.3 for Web Intelligence and Semantic Layer:

BI Launch Pad Overview

You can perform a fresh SAP BI 4.3 full install or upgrade your previous SAP BI 4.x system. In both cases, you  need a new 4.3 license that can be downloaded from the SAP Support web site.

Once installed and deployed, you can connect to the BI Launch Pad through its Login page, whose URL is by default http://<server>:<port>/BOE/BI

BI Launch Pad: Login Page

After you have authenticated, the Home page presents some tiles that give you access to repository’s resources:

  • Folders: to navigate in the BI Platform repository folders.
  • Categories: to navigate in the BI Platform repository categories.
  • Documents: to display your documents as a flat list.
  • BI Inbox: to access the documents and alerts you have received.
  • Instances: to give you an overview of all your schedules and publications.
  • Recycle Bin: to display and restore documents you have deleted.

BI%20Launch%20Pad%3A%20Home%20Page

BI Launch Pad: Home Page

Under these tiles, three sections with document tiles are displayed. These documents are the ones:

  • You have set as favorites (Favorites)
  • You have previously opened (Recent Documents)
  • That have been recently processed through schedules (Recently Run).

Finally, the Applications section contains tiles you can click to start the corresponding application hosted in BI Launch Pad. These applications include Web Intelligence.

BI Launch Pad: Applications Tiles

To modify the BI Launch Pad settings, click the icon () at the top left of the Home page, then Settings to open the Settings dialog box.

  • In the Application Preferences section, click the Web Intelligence tab to display the Web Intelligence preferences. In addition to the usual drill, Excel save or right-to-left orientation options, you can also define your measurement unit (centimeters or inches). This was previously defined at document level and you had to set it for every document.

BI Launch Pad: Web Intelligence Preferences

  • In the Appearance section, you can also choose another Fiori theme for the user interface, for example a high contrast display for BI Launch Pad and Web Intelligence.

Web Intelligence: High Contrast Display

To open a Web Intelligence document:

  • If it is displayed on the Home page as a tile, click this tile to open it in Reading mode
  • If you access the document through the Folders, Categories or Documents tile, click the More button () to open the contextual menu. This menu contains the different actions you can perform on this document, including View to open it in Reading mode or Modify to open it in Edit mode

BI Launch Pad: Document Menu

For more details about BI Launch Pad’s new features, see SAP BusinessObjects BI 4.3: What’s New.

Web Intelligence: Reading Mode

The Web Intelligence Reading mode proposes a simplified interface in which users can easily view, refresh and export documents. It proposes some interactivity and analysis capabilities through input controls, elements linking, drill or track changes. In SAP BI 4.3, this Reading mode interface is similar to the Web Intelligence Interactive Viewer FIORI-based interface released since SAP BI 4.2 SP4.

Main Toolbar

The toolbar contains sections with the following commands:

File

  • : Opens the menu with the Save and Save As
  • : Undoes the last actions.
  • : Redoes the last undone actions.
  • : Opens the Print dialog box to set parameters (report and page selection, page size, orientation, margins and scaling) and generate a PDF that can be printed out.
  • : Opens the Export to dialog box to export the report’s or cube’s data into different file formats. The dialog box has been reorganized to better display all possible options (Request 215268) and to propose the Excel format by default (Request 140228).

Web Intelligence: Export to Dialog Box

  • : Opens the Send to users dialog box in which you can select the users or groups that are to receive this document in their BI Platform repository inbox.
  • : Opens the Online Help on the SAP web site.
  • : Displays the Web Intelligence version.

Data

  • : Refreshes the document’s queries that have been selected for refresh by the document’s designer. In the new interface, this button is more visible (Request 131476), especially when a data provider has been partially refreshed. In this case, a warning is sent and an orange dot () is added to the Refresh button (Request 206429).

Web Intelligence Refresh: Partial Refresh Warning

Analyze

  • : Opens or closes the Filter Bar used to display and set filters values (see description below). Another icon is displayed () if (a) filter(s) already applies/apply to the current report.
  • Drill checkbox: Enables/disables the drill mode.
  • Fold/Unfold checkbox: Enables/disables the fold / unfold.
  • Show Changes checkbox: If the “Track Data Changes” feature has been enabled, use this checkbox to highlight these changes.
  • : Opens the Track Data Changes dialog box in which you can enable/disable the tracked changes, define the dataset reference and the reports to compare. It also displays the fonts and colors used to show the differences.
  • : Switches to the “Auto Refresh” mode in which the document is refreshed regularly and automatically (see SAP BI 4.2 SP6). Before entering this mode, you need to define a refresh frequency and answer potential prompts if any. These values are kept for the next refresh actions, as long as you remain in this mode.

Reading Mode: Auto-Refresh

Filter Bar

In Reading mode, the Filter Bar is the single place where you can see and, when possible, modify the filters and input controls that impact your document’s dataset.

Reading Mode: Filter Bar

In detail, the Filter Bar contains the following items:

  • The Reset button () to reset all input controls to their default values and remove the element linking filtering (Request 144999).
  • The prompts that have been answered during the document’s queries execution. Click Prompts () to see these values. To modify them, refresh your document and provide new values for the prompts.
  • The document’s input controls () that apply to the whole document, and the report input controls () that apply only to the current report. Click an input control to modify its values using list, multi-list (checkboxes), slider, spinner… depending on the document’s designer choice. For list and multi-list, a search text field can be used to find only the values that match a search string.For a group of input controls, click the group and select the input controls to add. The order in which you select the input controls defines the filter path, i.e. the input controls’ dependencies. For example, if you select Country before City, the selected countries filter your choice of cities.
  • Element linking through which a block is filtered by a value selected in a table. Click the element linking icon () to display the value of this element linking and reset it, if needed.

If the window is too small to display the full Filter Bar‘s content, then arrows are displayed on its edges allowing you to scroll.

Reading Mode: Filter Bar Scrolling Arrows

Report Selection and Vanishing Toolbar

In Reading mode, you can move from one report to another by clicking the corresponding tabs displayed under the toolbars.

To navigate in the report, you may use the Vanishing Toolbar at the bottom of the page. This toolbar appears when you move your cursor to the bottom of the page and disappears when you stay idle for a few seconds. This toolbar contains the following commands:

  • The controls to go to the first page, previous page, a specific page, next page or last page.
  • : Opens the Zoom slider to select the zoom ratio.
  • : Toggles between the Print layout and the Draft
  • : Fits the page’s width to the window’s width.
  • : Fits the page to the window.

Reading Mode: Vanishing Toolbar

Side Panel

Unlike the previous releases, the side panel is located on the right. To open or close this side panel, click one of the buttons in the toolbar depending on the content you want to display:

  • : The Navigation Map pane, to quickly navigate in the report based on its sections.
  • : The Comments pane, containing the comment threads. Click an existing comment in the document to view its thread or right click a report element in the document to comment it.
  • : The Document properties pane, to display the document’s statistics and properties (Refresh on open, document style, …)

Reading Mode: Navigation Map, Comments and Properties Side Panels

Web Intelligence: Edit Mode

The main improvement in SAP Web Intelligence 4.3 is the Edit mode. It completes the FIORI convergence (Request 209030). This mode has been simplified to improve the productivity of report designers by allowing them to perform tasks faster.

There are several ways to open the Edit mode:

  • By clicking the Web Intelligence tile on the BI Launch Pad Home page and creating a new document.
  • By selecting the Modify command () on the document menu allowing you to edit this document.
  • In Reading mode, by clicking the Edit button to edit the current document.

Main Toolbar

The toolbar contains only general commands that apply to the overall document. These commands should be familiar and have been reorganized for a simpler and faster access (Request 107473).

Edit Mode: Toolbar

The toolbar contains  sections with the following commands:

File, that contains the same commands as in Reading mode

Data

  • : Opens the Query Panel allowing you to edit the document’s queries.
  • : Opens the Refresh menu described below. As in Reading mode, when a data provider has been partially refreshed, an orange dot is displayed on the Refresh button () to provide you with a visual “document contains partial data”.
  • Change Source: Opens the Change Source Wizard dialog box, to change universes, SAP BW or SAP HANA data providers.
  • Purge Data: Opens the Purge Data Providers dialog box, to remove datasets from queries.

Insert

  • : Opens the menu in which you can select tables types and forms to insert into your report.
  • : Opens the menu in which you can select one of the default charts types to insert. For further charts types, open the Turn Into section in the Data side panel.
  • : Opens the menu in which you can select predefined cells to insert.
  • : Adds a section.
  • : Inserts a custom element, if you have registered one in the CMC.

Analyze

  • : Opens/closes the Filter Bar (see below). As in Reading mode, an icon is used to highlight that the dataset is filtered ().
  • : Opens/closes the Formula Bar (see below).
  • Drill, Fold/Unfold, Show Changes checkboxes: As in Reading mode, click these checkboxes to enable/disable drill, enable/disable fold/unfold or show document changes.
  • : Opens the Track Data Changes dialog box.
  • : Opens the Manage Formatting Rules dialog box.

Display

  • : Opens the Zoom slider to select the zoom ratio.
  • : Toggles between the Print layout and the Draft
  • Structure checkbox: Use this checkbox to switch between Structure and Data
  • : Fits the page’s width to the window’s width.
  • : Fits the page to the window.

Navigate contains the same controls as in the Vanishing Toolbar of the Reading mode to navigate in the report’s pages.

Depending on your screen size, some commands are reachable by opening the More menu ().

Filter Bar

Like in Reading mode, you can use the Filter Bar to view and change filters values. In Edit mode, you can in addition manage input controls and group of input controls, through the Manage Input Controls button ().

Edit Mode: Filter Bar

Click this button to open a menu with the following commands:

  • New Input Control: Opens the New Control dialog, in which you can provide the different parameters to create an input control (the impacted object, its scope document or report, the interface item used to modify it…)

Edit Mode: New Control

  • New Group of Controls: Once you have selected the scope of the group to create (the whole document or the current report), the New Group dialog box opens. You can give the new group a name and click Add Control to select the input controls to add in this new group. If needed, you can click New Control to create an input control on the fly and add it.

Edit Mode: New Group of Input Controls

  • Manage Filter Bar: Opens the Manage Filter Bar dialog box listing all input controls and groups. Select a group or input control and click the Edit icon () to edit it or the Delete icon () to delete it.
    To define the position of a group of input control on the Filter Bar, select it and use the arrow buttons ( and ) to move it up and down in the list.
    You can also create a group or an input control from this dialog box by clicking + Add.
  • Reset All: Resets all input controls to their default values and removes the element linking filtering.

Another way to edit an input control’s properties is to click first the input control in the Filter Bar, then the Settings icon () and finally Advanced Settings. This opens the Edit Control dialog box.

Formula Bar

In the Formula Bar, you can enter a value or a formula in a cell. This Formula Editor supports auto-completion: while you type a formula, a menu proposes the objects, functions or operators that match the letters you have typed (Requests 236699 and 241647). You may select the one to use by clicking it or by using the arrow keys and pressing [Enter].

Edit Mode: Formula Bar

The Formula Bar contains the following four buttons:

  • Display the Formula Editor: Opens the Formula Editor that can help you to type the formula.
  • Create a new variable using this formula: Opens the Formula Editor allowing you to create a variable from the formula in the Formula Bar.
  • Restore the initial formula: To cancel the formula you have entered and restore the previous one.
  • Validate the formula: To validate and save the current formula in the cell.

Report Tab

In the document, you access a report by clicking the corresponding tab below the Main Toolbar and Filter Bar.

Click the drop-down menu () beside the report name to open the menu containing commands to add a new report, duplicate, delete, rename or move the selected report.

Edit Mode: Report Menu

The last command in the menu (Copy Link of the Report) copies the Opendoc URL to this report into the clipboard. You may copy and share this URL that can be used to directly open this report.

Main Side Panel

The Edit mode proposes two side panels and as in Reading mode, they are located on the right. By default, only the main side panel opens. It contains two stacked panels:

  • Report Structure: This panel displays the report structure with the different blocks it contains.
  • My Objects: This panel displays the document dictionary with all objects retrieved by the queries and also the enrichments added by the document designer.

Like in Reading mode, the buttons on the toolbar can be used to display the Navigation Map, Comments and Document properties panels in the main side panel. In Edit mode, they replace the Report Structure and My Objects panels when selected. Document properties panel allows you to modify document’s options and properties in Edit mode.

Edit Mode: Main Side Panel

Main Side Panel: Report Structure

As in previous releases, the Report Structure displays a tree of all items in the current report: header, footer, charts, cells, tables, …

Edit Mode: Report Structure Side Panel

It can be useful to understand how a report is organized and access a specific block rather than looking for it in the document: if you click the More icon () beside an item, the Format and Data commands open the Format and Data panels described below.

Main Side Panel: My Objects

The My Objects panel lists the document’s dictionary. In this panel, you manage the objects retrieved from the document’s queries, the enrichment you defined for these objects as well as the variables and references you create. For example, to add a new variable, click Add Variable, to opens the Formula Editor and create your variable.

Edit Mode: My Objects Panel

You can display these objects in alphabetical order, by folders or by queries. The corresponding options are Alphabetical View, Folders View or Queries View and are available in the View Mode menu ().

Click the More options icon () beside an object to open its contextual menu with the usual actions you can perform:

  • Enriching a dimension by making it a geo or time dimension
  • Merging / unmerging objects
  • Managing groups
  • Editing object properties
  • Setting the measure type to Number or Decimal
  • Defining a custom sort for the object

Edit Mode: My Objects Contextual Menu

This panel works in a similar way than in previous releases. There are, however, a few usability enhancements:

  • You can delete several variables at the same time (Request 208832).
  • The focus remains on the current variable when you edit it (Request 208418).
  • In Queries View, you can directly edit a query and open it in the Query Panel by clicking the Edit Query icon ().

Build Side Panel

The Edit mode introduces a second side panel that can be opened or closed through a fourth button () located in the toolbar. This second side panel replaces the modal dialog boxes (Assign, Turn To, Format, Breaks, Sort, …) available in previous releases. It contains all the properties that were previously exposed in the modal dialog boxes. Depending on their category, these properties are displayed in one of these two panels:

  • Data, defines the data structure of the item you have selected
  • Format, defines the format of the item you have selected

You can switch from one panel to another by clicking their respective header.

They are contextual panels and the displayed properties depend on your selection. When you select an element, it automatically displays the relevant properties.

The properties you set in the Data panel are immediately applied to the selected item. You can decide to automatically apply the properties you picked in the Format panel by selecting the Instant Apply checkbox at the bottom of the panel. As these format changes imply regular requests to the server for each modification, you may prefer to unselect this checkbox and rather click Apply in one request to the server.

Edit Mode: Format Panel Apply Options

This new side panel is one of the main enhancements of the document authoring workflows. As described in the next two sections, setting a format or organizing a block feed is much easier through this side panel than via the previous dialog boxes (Requests 109434 and 107959).

Build Side Panel: Data

The Data panel is available when you select a chart or a table and is used to define the data and structure of this selected table or chart block. The corresponding properties of the Data panel are organized in tabs, and only tabs relevant to your selection are displayed. These tabs are:

  • : The Feeding tab contains the Turn into command used to select the table or chart type for this block. If you have registered custom elements in the CMC, they appear in the last menu of the Turn Into command.

    Edit Mode: Selecting Custom Element (Courtesy from Need4Viz)

    The Data Assignment section defines the objects used in the selected table or the chart. You may easily add objects to this block by drag-and-dropping them from the My Objects panel. Drag and drop can also be used to more easily change the objects’ order in the block.

    Edit Mode: Adding Objects to a Table Through Drag and Drop

    Another way to add objects is to click the More icon (), select the Formula and picks them from the Formula Editor or enter a formula to feed the block.

  • : To manage the Filters and Element Links for the selected block. If a filter has been defined, then a dot is displayed on the tab. This tab provides an overview of all filters that apply to this block by listing also the input controls.
  • : To manage the Sort that applies to the selected block. If sorts have been defined, the number of defined sorts is displayed on the tab.
  • : To manage the Ranking that applies to the selected block. If a ranking is defined, a dot is displayed on the tab.
  • : To manage the Breaks options of the selected table.

Edit Mode: Data Sub-Tabs for a Chart

Build Side Panel: Format

The Format panel contains all formatting properties for the selected item: report, cell, table, table cell, chart… To select a specific area of a chart (axis, title, legend, …), you can either:

  • Click this area in the chart itself.
  • Or select the chart and then the desired chart area in the menu located beside the chart’s name in the Format

Edit Mode: Chart Area Selection

The properties you can set depend on your selection, since some may not be relevant to your selection. These properties are organized by categories in the Format panel’s sub-tabs.

  • : Contains Display settings. For tables, it includes the properties that define what must be displayed or hidden: header, footer, object name, hide when empty, duplicate rows aggregation… For charts, it also includes the components to be displayed or not: title, data label, legend, …
  • : Contains Appearance settings, like background color, borders’ definition, spacing, padding…
  • : Contains Text settings, like its police, font, color, alignment, …
  • : Contains Styling settings for charts, like palette, markers size…
  • : Contains Layout settings. For pages, it includes print layout, margins and scaling properties. For blocks, it includes relative positioning regarding other blocks, size and page break options…

Edit Mode: Format Sub-Tabs for Charts

At the top of the panel, beside the name of the selected block area (that can be changed as in the Data side panel), you may open the Format Painter menu ( ). It contains the Copy Format and Reset Format commands to respectively copy or reset the format of the current block.

Edit Mode: Format Menu

Query Panels

When you create a document or add a query to an existing document, you are asked to select a data source type and then the data source itself.

Query Panel: Data Source Type Selection

The Query Panel opens, and you can select objects to create a query and retrieve the corresponding dataset. This Query Panel depends on the data source type. In SAP BI 4.3, these Query Panels are similar to the ones available in SAP BI 4.2, except for the FIORI skin, and propose the same features.

Query Panel: Universe Data Source

Query Panel: Excel Data Source

To run the query and close the query panel, click Run. If your document contains several queries, you can open a menu from this button and select the query to run.

Query Panel: Selecting Query to Run

Refresh and Purge Queries

The Refresh menu () of the toolbar’s Data section contains the following commands:

  • Refresh to refresh all authorized queries.
  • Refresh Data For to open a dialog box that provides some statistics about the queries’ last refresh. You can explicitly select the data sources to refresh during the next document refresh.

Refresh Data Providers Dialog Box

The toolbar’s Data section also contains the Purge Data command that opens the Purge Data Providers dialog box. The content of this dialog box is the same as in the Refresh Data Providers dialog box. However here, you can explicitly purge data from the data providers of your choice by selecting the checkbox in front of the data providers and clicking Purge (Request 143679).

Purge Data Providers Dialog Box

Web Intelligence: Rich Client

SAP BI 4.3 also offers Web Intelligence Rich Client for desktop usage. It is not a Java application any longer bur rather reuses the same interface as the SAP BI 4.3  web version in BI Launch Pad.

As all desktop tools in SAP BI 4.3 (Information Design Tool, Universe Design Tool…), it is released in 64-bit (Request 107828).

Login

You can start Web Intelligence Rich Client from the Start menu or by double-clicking a locally-saved Web Intelligence document. You land on the login page the process of which has been simplified (Request 127659). You are required to enter the system name, your credentials and the authentication mode. With the toggle button, you can choose to work in Online or Offline mode (used to work disconnected after you have retrieved resources locally on your desktop).

The Standalone and ZABO modes (allowing you to download and install Web Intelligence Rich Client from BI Launch Pad) are not yet released.

Web Intelligence Rich Client : Login Page

If your login parameters are valid, Web Intelligence Rich Client displays the Welcome  page.

Welcome Page

The new Web Intelligence Welcome page design is similar to the Home Page of BI Launch Pad.

Web Intelligence Rich Client: Home Page

Three tiles are displayed at the top of this page. They offer actions that follow the workflows of your documents:

  • Import: To select a document in the BI Platform repository and explicitly import it toa local folder so that you can edit it.
  • Open: To open a document you have previously imported on your local file system.
  • New: To create a local document.

The Welcome page also displays two other sections:

  • The Recent Local Documents section displays tiles for the local documents you have previously opened. These tiles contain a thumbnail of the document, a snapshot taken the last time the document was saved, as well as its last save date. Click a tile to open the corresponding document.
  • The Open Documents section displays tiles for the documents that are open in this session. These tiles show a thumbnail of the active report of the document. You can also click this thumbnail to quickly switch to this document or click the cross icon in the tile’s header to close it.

Web Intelligence Rich Client: Recent and Open Documents Tiles in Welcome Page

The drop-down menu at the top of the Welcome page header, contains the following commands:

  • Settings: to set Web Intelligence Rich Client parameters like the local documents’ default folder, the drill options, the locales or the measurement unit.
  • Help and About: To open the usual Online Help and About dialog box.
  • Log Out: to logout and return to the Login page.
  • Exit: to exit the tool. When exiting, all local Web Intelligence processes are terminated.

Web Intelligence Rich Client: User Menu

Web Intelligence Rich Client: Settings Dialog Box

Creating a Document

To create a local document, click the New tile in the Welcome page. The interface and workflows to create a document are the same as in BI launch Pad:

  • Select the data source type, then the data source itself. (The data source you can select must be stored in the repository; local data providers are not yet supported.)
  • Create and run your query.
  • Add charts, tables, formatting… to your report and add new reports and queries

Basically, you can take advantage of the same Edit and Read modes as in the web version, except for some features that are not yet supported or not yet available:

  • You can view comments but cannot modify comments on local documents.
  • You cannot send a document to BI Platform users.

Once you have finalized your document, you can:

  • Save it locally by selecting the File > Save You can reopen it later by selecting the Open tile in the Welcome page.
  • Publish it in the BI Platform repository by selecting the File > Publish to Enterprise command, and then select the destination folder in the Publish Document dialog box.

Web Intelligence Rich Client: Publish Document Dialog Box

Importing a Document from the Repository

If you have already some documents in the BI Platform repository, you can work on them in Web Intelligence Rich Client. Start Web Intelligence and connect to the BI Platform repository. In the Welcome page, click the Import tile to open the Import and Open dialog box and select the document to import and open.

Web Intelligence Rich Client: Import and Open Dialog Box

The selected document is copied to your file system, and this copy is opened for you to work on it using the same interface as in BI Launch Pad.

Once you have finalized your changes, you can save it in the BI Platform repository again by selecting the File > Publish to Enterprise command first, and the destination folder in the Publish Document dialog box as a second step.

You may prefer to save it locally for further changes before publishing it. In this case, select the File > Save command or select the File > Make Copy one to create another local copy.

In both cases, depending on your security rights, you may save it:

  • With document access to all users, so that all repository users that have provided their credentials can open it.
  • While removing the document’s security, so that users do not need to authenticate anymore.
  • While keeping it secured for you only.

Later on, if you restart Web Intelligence Rich Client in Online or Offline mode, you can reopen this local copy by clicking the Open tile in the Welcome page.

Web Intelligence: Document as a Data Source

The support of Web Intelligence document as a data source for another document is a new capability offered in SAP BI 4.3 (Requests 107970 and 109142). The source document can be considered as a virtual universe and a database; and their metadata and data can be shared and leveraged by other documents.

This feature covers several use-cases:

  • A document that queries a large dataset can be refreshed during quiet periods through a schedule and then be used as a data source for other documents. These documents do not query the initial data sources, but the dataset saved in the source document. This prevents initial data sources from being too solicited and improves the refresh time.
  • A power report designer may prepare metadata (merged dimensions, geo-dimensions, time dimensions, variables) and share it through a source document.
  • Likewise, a document that queries multiple heterogeneous data sources can be exposed as one single metadata provider and hide the complexity of the data sources it queries.

Creating a Query

When you create a document or add a query to an existing document, you can select Web Intelligence document in the list of possible data sources.

Web Intelligence: Adding a New Query

You are then asked to select a document in your Personal folders or in the Public folders of the BI Platform repository.

Web Intelligence: Document Selection

Once you have selected the source document, the Query Panel opens and displays the document’s objects: its dimensions, attributes, measures, hierarchies or variables… You can define a query by drag-and-dropping objects in the Results Objects section. You can also add filters in the Query Filters section to narrow down the dataset to retrieve from the source document.

This Query Panel is very similar to the one used for universes, although it does not yet support features like combined queries, advanced filters or query stripping.

Query Panel: Web Intelligence Document Data Source

If the source document contains hierarchies, you may use the Member Selector to select the members to query. This Member Selector supports the same operators as for SAP BW data sources: Children, Descendants Until and Descendants Unit Named Level, but not Ancestors nor Parents.

Refreshing Data

The refresh retrieves the dataset from the source document. If your query contains filters or member selections, they are applied when it is sent to the source document.

After the refresh, the objects that your query consists of appear in the My Objects panel. You can use them to feed the tables and charts in your report like you would for any data source. If you have enriched the source document with merged dimensions and/or geographical or time dimensions, they are retrieved as well and can be reused in the new document.

During this refresh, the source document is not refreshed. This is the reason why a source a document defined as being refreshed on open or based on an SAP HANA Online data source, cannot be used as a data source. The source document must be explicitly refreshed, either manually or through a schedule. If the Smart View option has been selected in the CMC, the data is retrieved from the source document’s last scheduled instance.

The aggregation of variable defined as measure is delegated to the source document. If you change the aggregation scope, the measure returns #TOREFRESH. Refresh the document to send the query against the source document so it returns the new aggregated value for the measure.

View-Time Security Filtering

The date of the dataset retrieved from the source document corresponds to the source document’s last refresh time. At refresh time, it is secured with the security profiles that apply to the user who is running the query. As the source document is not refreshed, it might be an issue if this source document dataset is shared with other users who do not have the same security profiles.

If the source document queries a universe created with Information Design Tool and secured with a Business Security Profile, you can enable the Apply security filtering at view time option (see SAP BI 4.2 SP6) to filter the dataset when a document based on this source document is opened.

If you set this option for the consuming document, the Business Security Profiles that apply to the user are enforced on the fly when the document is opened and without refreshing the source document, nor the document created on it:

  • Display Data Business Security Profiles prevents a denied object and its data to be displayed.
  • Only rows that match the filters conditions defined in the Filters Business Security Profiles are displayed.

If you set this option for the source document, the filtering is applied when data is retrieved from this source document:

  • Display Data Business Security Profiles prevents a denied object and its data from being retrieved.
  • Only rows that match the filters conditions defined in the Filters Business Security Profiles are retrieved.

You can also set this option for both documents.

As this security relies on universe’s Business Security Profile, it applies only to source document queries based on universe created in Information Design Tool.

Document Dependencies

In the BI Platform repository, a link is created between the source document and a document that uses it as a source. Hence, dependencies between these documents are properly displayed in Life Cycle Management, Promotion Wizard or in the CMC if you use Tools > Check Relationships.

CMC: Source Document Relationship

Web Intelligence: Geo Map

To provide more accurate geo dimensions, the Here geographical database used by Web Intelligence has been updated with its 2019 version:

  • Borders and regions take geographical changes into consideration, e.g., new French regions are available (Request 144513).
  • Regions, sub-regions and cities have been added in some countries for better coverage.
  • New cities have been added, some have been removed,  considering the 100,000 inhabitants limit, except for the United States of America.

Geo-Map: New French Regions

If you have created geo charts in SAP BI 4.2 with a mapping by name, you need to remap these names when editing these documents in SAP BI 4.3 due to ID changes in the geographical database.

Web Intelligence: Formula Language Functions and Formula Editor

In the Data Provider category, DataProviderType has been updated to return the correct data provider type. The possible values are: “Universe”, “Text”, “Excel”, “Web Services”, “SAP BW”, “SAP HANA”, “Free-Hand SQL” and “Web Intelligence” for the new Web Intelligence document data source. Besides NumberOfRows, NumberOfColumns has been added to return the number of objects of a data provider.

  • string DataProviderType ( Data provider dp )
  • int NumberOfColumns ( Data provider dp )

In the Document category, DocumentPath, DocumentParentFolder and DocumentParentFolder have been added to respectively return the document’s path (Request 108755), the name of its parent folder (Request 206442) and the document description (Request 144988). QuerySummary has also been updated to return the correct data provider type (cf. DataProviderType).

  • string DocumentPath ()
  • string DocumentParentFolder ()
  • string DocumentDescription ()
  • string QuerySummary ()

In the String category, Trim, LeftTrim and RightTrim have been extended to allow you to define the character to remove from the string (Request 217310). By default, this character is the space character.

  • string Trim ( string str [; string ch] )
  • string LeftTrim ( string str [; string ch] )
  • string RightTrim ( string str [; string ch] )

To create more readable and maintainable formulas, you can use the classic comments usually supported by most programming languages (Request 111272) in the formula language:

  • To comment the end of a line, you may use //
  • To comment a block in the formula, you may use /* */

When you open the Formula Editor, all category folders are closed by default (Request 202146). To find a function more easily, the All category (that contains all functions) is displayed at the top of the categories’ list.

As in the Formula Bar, the Formula Editor supports auto-completion. When you type a formula, a menu displays the objects, functions or operators that match the letters you typed (Request 241647). Select the one to use by clicking it or using the arrows keys and pressing [Enter].

Auto-Completion in the Formula Editor

Web Intelligence: Security Rights

To adapt the new interface and deployment modes, the Web Intelligence security rights have been updated:

  • Names and categories have been simplified and aligned (Request 214981)
  • Two new rights are introduced to secure the use of Free-Hand SQL (Request 219070): Query: Edit Free Hand SQL script and Query: View Free Hand SQL script

The following table lists Web Intelligence application security rights, with their equivalent in SAP BI 4.2.

SAP BI 4.3 Security Right Previous SAP BI 4.2 Name
Data: Enable data tracking Data – Enable data tracking
Data: Enable formatting of changed data Data – Enable formatting of changed data
General: Enable Desktop client access Desktop interface – Enable Web Intelligence Desktop
Desktop: Publish to Enterprise Desktop interface – Export documents
Desktop: Print documents Desktop interface – Print documents
Desktop: Remove documents security Desktop interface – Remove document security
Desktop: Give access to everyone Desktop interface – Save document for all users
Documents: Disable automatic refresh on open Documents – Disable automatic refresh on open
Documents: Enable autosave Documents – Enable autosave
Documents: Enable creation Documents – Enable creation
Documents: Publish and manage content as web service Documents – enable publish and manage content as web service
General: Edit Web Intelligence preferences General – Edit ‘My Preferences’
General: Enable Web client access Interfaces – Enable web viewing interface
Query: Edit script generated from universe Query script – Enable editing (SQL , MDX, …)
Query: Edit Free Hand SQL
Query: View script generated from universe Query script – Enable viewing (SQL , MDX, …)
Query: View Free Hand SQL
Reporting: Create and edit breaks Reporting – Create and edit breaks
Reporting: Create and edit conditional formatting rules Reporting – Create and edit conditional formatting rules
Reporting: Create and edit input controls and group Reporting – Create and edit input controls
Reporting: Create and edit predefined calculations Reporting – Create and edit predefined calculations
Reporting: Create and edit filters and consume input controls Reporting – Create and edit report filters and consume input controls
Reporting: Create and edit sorts and rankings Reporting – Create and edit sorts
Reporting: Create and edit formulas, variables, groups and references Reporting – Create formulas and variables
Reporting: Enable document change Reporting – Enable formatting
Reporting: Merge objects Reporting – Enable merged dimensions
Reporting: Insert and remove reports, tables, charts, and cells Reporting – Insert and remove reports, tables, charts, and cells

In the CMC, the following rights are prefixed with the “Obsolete_” tag since they are either useless in SAP BI 4.3 or their security intent is replaced by customization when it is supported:

  • Disable Export to BI On Demand for this user
  • Disable Import from BI On Demand for this user
  • General – Enable right-click menus
  • Interfaces – Enable Rich Internet Application
  • Left pane – Enable document structure and filters
  • Left pane – Enable document summary
  • Desktop interface – Save documents locally
  • Desktop interface – Import documents

CMC: Web Intelligence Application Security Rights

The following rights are still exposed in the CMC but will be leveraged once the corresponding features are supported:

  • Desktop: Send by e-mail
  • Desktop: Enable local data providers
  • Desktop: Install from BI Launch Pad
  • Shared: Publish shared elements
  • Shared: Insert shared elements

The following table lists Web Intelligence document security rights, with their equivalent in SAP BI 4.2.

SAP BI 4.3 Security Right Previous SAP BI 4.2 Name
Edit Query Edit Query
Export the cube’s data Save as CSV
Export the report’s data Export the report’s data
Import document locally N/A
Refresh List of Values Refresh List of Values
Refresh the report’s data Refresh the report’s data
Use Lists of Values Use Lists of Values
View SQL View SQL

The Save as Excel or Text and Save as PDF security rights have been removed since exporting or scheduling report’s data into PDF, Excel, HTML archive, Text or CSV archive is now simply covered by the Export the report’s data right.

Two new rights have been introduced:

  • Export the cube’s data: This right allows the user to export a document’s cube data or to schedule it into a CSV file. (Request 134236)
  • Import document locally:This new right replaces the previous application Desktop interface – Save documents locally and Desktop interface – Import documents security rights and is used to allow the document to be saved locally so that it can be opened in Web Intelligence Rich Client.

The Publish shared elements right is still exposed in the CMC but will be leveraged only when the corresponding feature is supported.

Web Intelligence: Publishing and Scheduling

When the new BI Launch Pad has been released in SAP BI 4.2 SP4, it was possible to schedule documents but not to distribute them through publications. In SAP BI 4.3, this missing capability has been implemented in BI Launch Pad and offers the same options as in SAP BI 4.2.

To create a publication, go to a folder, click the Create/upload objects button () at the top of the folder’s page and select Publication in the menu.

BI Launch Pad: Publication in the Create Menu

In the New Publication page, enter the publication parameters. These parameters are organized by sections, displayed in two tabs. Depending on the document type, some parameters appear only after the source documents have been added to the publication.

BI Launch Pad: New Publication

To navigate into the possible parameters more easily, you may click the following tabs, and select the section in the corresponding menus:

  • General. This tab contains the generic publication parameters: publication details, source documents, destination, recurrence, enterprise and dynamics recipients, events, …
  • Report Features. This tab and its sections appear if your publication contains a Web Intelligence or Crystal Reports document. It contains publication properties that are specific to this document type. For Web Intelligence, this covers the publication formats, personalization, prompts and delivery rules.
  • Summary: This tab displays the publication’s most common parameters.

BI Launch Pad: Publication Menus

When the publication is defined, click Save or Save and Close.

In SAP BI 4.3, you can still schedule a document. To provide the same look & feel as in New Publication page, the Schedule page has been modified.

BI Launch Pad: New Schedule

When defining a schedule, you can move to specific sections through two tabs and the corresponding menus.

  • The General tab contains the generic sections that define a schedule, like the schedule’s destinations and recurrence, its attached events, …
  • The Report Features tab contains the sections specific to a Web Intelligence document. Formats, Prompts and Delivery Rules are available, but Caching properties are not yet implemented.

BI Launch Pad: Schedule Menus

Both schedule and publication take advantage of the new options introduced in SAP BI 4.3:

  • When you define the publication or schedule frequency in the Recurrence section, you can select business days and hours for the schedule to run.
  • Another new option, Allow Retries, can be used to define if a failed schedule must be re-run and if so, how many times and when.

BI Launch Pad: Recurrence Options

  • In the BI Launch Pad Home page, click the Instances tile to display an overview of all schedules and publications run by you and their status. At the top of the page, you can find controls to filter this list by date, status, scheduled object type or just by name.

BI Launch Pad: Schedule Instances Page

Web Intelligence: OpenDocument URL

The Copy Link of the Report/Table/Chart/Cell commands previously described allow you to directly generate an Opendoc URL to access the corresponding item. You can also get the link to access a document by opening the document’s contextual menu in BI Launch Pad and selecting the Details command. The Opendoc URL you can share is provided in the Document Link field.

BI Launch Pad: Document Details Dialog Box

With the Web Intelligence user interface simplification, the sViewer option is no longer used by the Opendoc URL and is skipped when it is processed. Some options like instance are not yet supported in SAP BI 4.3 and will be supported in future Support Packages.

To allow your user to directly access a folder, you can select the Details command in a folder’s contextual menu, and share the URL provided in the Folder Link.

BI Launch Pad: Folder Details Dialog Box

Web Intelligence: REST Web Services

In the Web Intelligence REST Web Services, some new APIs have been added:

  • To get, create, edit and delete referenced cells in a document
  • To get, create, edit and delete table’s calculations (Average, Count, Max, Min, Percent or Sum)
  • To get the details of a publication

Some existing APIs offer additional options and can be used to:

  • Purge a document
  • Set a table cell as a section
  • Change the position of a report element in the layout (front, back…)
  • Delete all breaks of a table
  • Update or delete all breaks on a table axis
  • Get, edit or delete all custom formatting of a report element
  • Get the details of a hierarchy member
  • Re-order input controls
  • Create a custom format for number or datetime
  • Get the marker palettes, the gradient orientations and the locales supported by the BI Platform server

Web Intelligence: Performance Enhancements

To improve the performance of Web Intelligence, several enhancements have been implemented:

  • The most visible one is the progressive disclosure, aka lazy loading: to avoid blocking the user while the document is fully displayed, the document skeleton is computed and displayed first, followed by the charts in the background. The gain is particularly significant on document a that contains many charts.
  • The Web Intelligence REST Web Services calls used by the new Web Intelligence interface have been optimized
  • Documents with the Refresh on open option are automatically purged when saved in order to reduce the document opening time (Request 110058).
  • A Web Intelligence document stores details related to the universes it queries. If one of these universes has been modified, the updated details are retrieved from this universe when the document is opened. A warning message is displayed to recommend that you save the document, to avoid the same update next time it is opened.

Information Design Tool: 64-Bit

Like other client tools in SAP BI 4.3 (Web Intelligence Rich Client and Universe Design Tool), Information Design Tool and Connection Server drivers are released in 64-bit only (Request 210604).

Information Design Tool: Calculated Column in List Of Values Based On SQL

In a data foundation or a business layer, a list of values based on custom SQL can reference a calculated column (Request 212610).

In the SQL defining the list of values, you must pass the calculated column name with the @CalculatedColumn function.  This is similar to the support of derived table in SAP BI 4.2 SP6 through the @DerivedTable function.

This @CalculatedColumn function is automatically added when you double-click or drag and drop the calculated column from the Tables list.

Using Calculated Column in List of Values Definition

Information Design Tool: Other Enhancements

Some enhancements have been done to simplify the use of Information Design Tool:

  • In the data foundation, when adding a table to a view, the list of views is alphabetically sorted.
  • In the data foundation and business layer editors, the search in the filter pop-up is case-insensitive (Request 222473).
  • In the Edit Business Layer View dialog box, you can order views by selecting them and clicking one of the two arrow buttons. This was already possible by dragging and dropping these views in the list. Views are displayed in Query Panel in the order you have defined.

Business Layer Views

  • When exporting a business layer as a Text, HTML or PDF file, the objects’ CUID are also saved if you select the Object CUID checkbox in the Save As dialog box.

Save As Dialog and CUID in Generated HTML

Semantic Layer Java SDK

The Semantic Layer Java SDK is available in 64-bit (Request 138464).

When creating an object, you can set this object CUID with a new method the signature of which is as follows:

<T extends BlItem> T createBlItem(Class<T> type, String name, BlContainer parent, String cuid);

If you do not pass any string to define a CUID, then a random one is assigned, like in SAP BI 4.2.

SAP BW: Secure Network Connection (SNC)

SAP Secure Network Connection is a protocol that secures SAP system accesses. In previous releases, it is already supported by BusinessObjects BI Platform servers and Universe Design Tool to encrypt communications with SAP BW servers.

In SAP BI 4.3, Information Design Tool and Web Intelligence Rich Client also use SNC encryption to connect to SAP BW servers. To leverage this capability, SNC must first be configured in the CMC (in Authentication > SNC Settings) and on each machine running these client tools (see SAP Note 2183696).

SAP BW: InfoProvider

When using SAP BW as a data source, you are no longer limited to SAP BEx queries and you can query one of the following SAP BW Info Providers (Request 138931):

  • Advanced DataStore Object – ADSO (Request 239793)
  • CompositeProvider – HCPR (Request 227149)
  • InfoCube – CUBE
  • MultiProvider – MPRO
  • Open ODS View – FBPA

This support is available in both:

  • Web Intelligence: After the selection of an SAP BW data source, you can directly browse it and select an SAP BW Info Provider
  • Information Design Tool: You can create a multidimensional universe (UNX) on top of an SAP BW Info Provider. This universe can then be used as a data source in Web Intelligence.

Web Intelligence SAP BW Direct Access: Browsing InfoProviders

In both cases, you connect to an OLAP connection (BICS-based) and can leverage multidimensional concepts (hierarchies, levels, member selectors…)

SAP HANA: S/4HANA CDS Views

When using S4/HANA as a data source, you can directly query the S/4HANA CDS views defined as #CUBE or #DIMENSION in the Data Definition script from ABAP Development Tool. In SAP BI 4.2, only the ones defined as #QUERY are supported.

This support is available in both:

  • Web Intelligence: After the selection of an SAP S/4HANA data source (in the list of data sources, select the SAP BW option), you can directly browse it and select a CDS view.
  • Information Design Tool: You can create a multidimensional universe (UNX) on top of an S/4HANA CDS view. This universe can then be used as a data source in Web Intelligence.

This access uses OLAP connection (BICS-based, but not HTTP) and leverages multi-dimensional concepts, like CDS hierarchies and CDS variables.

SAP HANA: Variable Mapping

In SAP HANA Studio or Web IDE for HANA, a metadata designer can create HANA cascading variables by mapping the input parameters or variables of an external view with the input parameters or variables of a calculation view.

Web Intelligence can consume these cascading variables as cascading prompts.

SAP HANA: HTTP Connection

In SAP BI 4.2, some products like Analysis for OLAP or SAP Design Studio support HTTP-based connections to access SAP HANA. In SAP BI 4.3, such connections are also supported by the Web Intelligence / Semantic Layer stack:

  • In Web Intelligence, you can directly query SAP HANA information models through direct access by selecting an HTTP connection.
  • In Information Design Tool, you can create a multi-dimensional universe based on an HTTP connection.

This HTTP connection, based on InA service, supports the following SAP HANA features:

  • Analytic and calculation views
  • Hierarchies and member selections on hierarchies
  • Variables and input parameters
  • Filters on hierarchies, attributes and measures

This HTTP connection can be created in:

  • Information Design Tool, through the New OLAP Connection dialog box
  • Since SAP BI 4.2, in the OLAP Connections tab of the CMC

SAP HANA HTTP Connection in Information Design Tool

SAP HANA: Smart SQL Access for HTTP Connections

In Information Design Tool, when creating an HTTP connection to an SAP HANA database, you may optionally select the Allow SQL access to the remote database checkbox and provide the parameters to query this SAP HANA database through SQL.

Defining SQL Parameters in SAP HANA OLAP Connection

When connecting to SAP HANA through direct access, Web Intelligence rather uses SQL if you select this Allow SQL access to the remote database checkbox and if the query contains no hierarchy as it’s faster than HTTP in this case. However, if the query contains hierarchies or is generated from a universe created in Information Design Tool, it is sent through HTTP.

For the time bieng, the Allow SQL access to the remote database checkbox can only be set in Information Design Tool, and not in the CMC.

Data Sources: New Supported Data Sources

In addition to the relational databases supported in previous releases (see the SAP BI 4.3 Product Availability Matrix), Connection Server supports the following additional data sources in Information Design Tool:

  • IBM DB2 Warehouse 3, through native driver (with single sign-on support) and JDBC driver
  • Denodo 7, through JDBC driver (Request 201192)
  • Google BigQuery, through native driver (Request 140996)
  • Snowflake, through JDBC and ODBC drivers (Request 205399)
  • SAP HANA Cloud through SAP HANA JDBC and ODBC connections. You can create a relational universe on SAP HANA Cloud tables. The SAP HANA client interface version must be equal to 2.4.167 or higher.
  • SAP Data Warehouse Cloud through SAP HANA JDBC connection. You can create a relational universe on SAP Data Warehouse Cloud tables and views. The SAP HANA client interface version must be equal to 2.4.167 or equal.
  • And Java Beans for custom drivers that can be written by developers or partners (see Connection to custom sources with a JavaBean for more details).

For big data sources, Connection Server supports Hive, Impala and Spark and hence also, the distributions that embed them:

  • Cloudera CDH1 with Hive and Impala
  • Hortonworks HDP 2.5 with Hive
  • Hortonworks HDP 3.1 with Hive and Spark
  • MapR MEP 6.1 with Hive, Impala and Spark

Relational Connections List

Data Sources: ODBC DSN-Less Connectivity

To simplify the use of ODBC connection, Connection Server supports the ODBC Data Source Name (DSN)-less connection for databases that support it. When creating the connection in Information Design Tool, you can also enter the required parameters (host, port, …). Hence, you avoid defining the DSN across all machines that access the database through this ODBC connection.

In Information Design Tool, when creating an ODBC connection for SAP HANA, Microsoft SQL Server, Microsoft Access, Microsoft Excel, Teradata, Oracle MySQL, PostgreSQL, Oracle databases or IBM Informix, you can select:

  • The Use existing data source radio button to continue defining the DSN as in previous releases.
  • Or the Use connection string option, and then provide parameters that depend on the selected databases (Driver, Host, Database, Service, Protocol…)

Defining ODBC DSN-less Connection

Data Sources: Multiple Secondary Credentials

In SAP BI 4.2, you can define secondary credentials for each user in the CMC. When a user uses a relational or OLAP connection the authentication mode of which is Use BusinessObjects credential mapping, his or her secondary credentials are used to authenticate him to the corresponding database. But as only one set of credentials can be defined per user, the same credentials are used for all connections with this authentication mode.

In SAP BI 4.3, multiple credential mappings can be defined per user through the new concept of Data Source Reference. To create a new Data Source Reference, select the Data Source Reference tab in the CMC.

In the Data Source References page, click the Create new Data Source Reference button () and enter a name and a description for the new Data Source Reference.

CMC: New Data Source Reference

Once created, the Data Source Reference appears in the page and you can later edit or delete it there.

Data Source References Page

In the Database Credentials section of a user’s properties page, you can set the credentials for this user and for each individual Data Source Reference you have created.

CMC: Defining User’s Credential Mapping

When you create a connection in Information Design Tool and select Use BusinessObjects credential mapping as authentication mode, in the Data Source Reference drop-down menu, you can select the mapping to use. If you do not select any, the default one is used.

Information Design Tool: Data Source Reference Selection in Connection Definition

When a user accesses the database through this connection, he is authenticated with the credentials defined in the CMC for this Data Source Reference and for this user.

Samples

On Windows, the eFashion and Rio sample databases are released on SQLite and no longer on Microsoft Access.

Restrictions

In this first SAP BI 4.3 release, the following features are not yet supported and will only be supported in a future Support Package:

  • Authoring of Query / Document as a Web Service
  • Web Intelligence: Extensions
  • Web Intelligence: Customizations
  • Web Intelligence: Text files as a data source
  • Web Intelligence: Authoring of Shared Elements
  • Web Intelligence: Authoring of intra-document and intra-document links
  • Web Intelligence Reading mode: Freeze headers
  • Web Intelligence Edit mode: Lock Copy Format
  • Web Intelligence Rich Client: ZABO and Standalone modes
  • Web Intelligence Rich Client: Local Text and Excel data providers
  • Web Intelligence: Authoring of SAP HANA Online documents. Migrated SAP BI 4.2 documents can still be read and refreshed, but you can’t create new ones or edit the migrated ones.
  • Web Intelligence: Some key shortcuts have not yet be implemented.

Retired Products

The following products and components are no more supported and released in SAP BI 4.3:

  • SAP BusinessObjects BI Widget. For more information, refer to 2837139.
  • SAP BusinessObjects Explorer. For more information, refer to 2824537.
  • SAP Crystal Dashboards and Presentation Design. For more information, refer to 2739919.
  • Upgrade Management Tool. For more information, refer to 2776738.
  • Report Conversion Tool. For more information, refer to 2801797.
  • Desktop Intelligence Compatibility Pack.

The PeopleSoft, JD Edward, Siebel and Oracle EBS Integration Kit are in maintenance mode and supported only for authentication. For more information, refer to 2776738.

Assigned Tags

      16 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mahboob Mohammed
      Mahboob Mohammed

      Thanks Chris!

      Author's profile photo Jason Everly
      Jason Everly

      Thanks Christian!!!

      I put it on the WebI Bulletin.

      Jason

      Author's profile photo Thierry Baraton
      Thierry Baraton

      a very great job.

      it's time to go to 4.3

      Author's profile photo Muhammad Sohail
      Muhammad Sohail

      going slow but right way…..clients and consultant waiting for the features….My observations about new enhancements:

      - Classic interfaces with com
      - Fiori theme for BI Launch Pad and Web Intelligence (Webi)
      - New Webi Welcome page is attractive
      - In Webi, accurate Geo dimensions
      - Edit/View script generated from universe is important
      - Edit Free-Hand SQL is important
      - Export the cube's data is important
      - Webi OpenDocument URL is important
      - Using SAP BW as a data source is important
      - IDT enhancement specially new Supported Data Sources are important

      Author's profile photo Michael Neville
      Michael Neville

      This is a great "all-in-one" resource! I am bookmarking this page for future reference.

      Great job as always on these "new features" blogs Christian!!!

      Author's profile photo Christian Key
      Christian Key

      Thanks for the information Christian.

      Cheers,

      Christian

      Author's profile photo GyanSys Basis
      GyanSys Basis

      Thanks for the information Christian, Could you please provide information about "Freezing" option in  New BI Launchpad (Fiori based) for rows and headers

       

      Thanks

       

      Author's profile photo Christian AH-SOON
      Christian AH-SOON
      Blog Post Author

      Hi,

      Indeed, “Freeze headers” is not yet available in Reading mode.

      We should deliver it in Support Package 2 the latest.

      Regards

      Christian

       

      Author's profile photo James Halligan
      James Halligan

      Some welcome new functionality here.

      Nice to see publications being integrated into BI Launchpad, although it would be nice if they could retrofit the publications scheduling functionality of being able to embed HTML content into an email body into the core scheduling engine

      A very handy resource to share with customers....

      Thanks Christian

       

       

       

      Author's profile photo Christian AH-SOON
      Christian AH-SOON
      Blog Post Author

      Hi James

      Like in SAP BI 4.2, in SAP BI 4.3:

      • You can schedule a Web Intelligence document in HTML Archive
      • You can publish a Web Intelligence document in mHTML

      But in Outlook, the generated mHTML output looks different than the original document since Outlook does not support the HTML version used by Web Intelligence (see SAP Note 2474630).

      If we support mHTML in scheduling, it means you’ll get the same limitations than in publication. Is it acceptable to you?

      If yes, you can vote for this request by following this link: Request 122520.

      Regards,

      Christian

      Author's profile photo Selvarasan Subramanian
      Selvarasan Subramanian

      Great , All at one place for WEBI

      Author's profile photo Ajay Gupta
      Ajay Gupta

      Great Job Christian

       

      Ajay

      Author's profile photo Alfons Gonzalez Comas
      Alfons Gonzalez Comas

      Hi Christian,

      Quick question. What does happen with the publication of WebI content as Web Services (WS) on 4.3?

      We have installed 4.3 SP0 P1 on a sand box and it looks like this feature has disappeared (when right clicking on a webi table the option "Publish as web service" does not longer appear .

      On the other hand we have found this slide from a SAP presentation.

       

      What is the official statement regarding publication of Web services on 4.3? Is the feature definitely deprecated or it will reappear again on SP1?

      Regards,

      Alfons

      Author's profile photo Christian AH-SOON
      Christian AH-SOON
      Blog Post Author

      Hi Alfons

      In SAP BI 4.3, documents based on QaaWS or DaaWS continue to work, but it is no more possible to create new QaaWS or DaaWS, to edit existing ones or create new queries on top of them.
      This will still be the case for SAP BI 4.3 SP1, and very likely beyond.

      For SAP BI 4.3 SP2+, we are looking for a more modern protocol to retrieve and expose data through web services. The technology is still being decided (it could be Odata or REST Web Services), so there is no commitment for the moment.

      Regards,

      Christian

      Author's profile photo Abhilash Chindam
      Abhilash Chindam

      Hello Christian,

      We've earlier 4.2 SP6,we've now a standalone server for 4.3 ,while trying to implement some security settings we found this .
      I%20am%20trying%20to%20find%20the%20Customization%20feature%20for%20User%20Groups.It%20says%20Not%20available

      I am trying to find the Customization feature for User Groups.It says Not available

       

      Earlier version we've used the Custmization feature of Web intelligence to disable the Design mode .

       

      Now,I want to disable the EDIT Mode for a Report so that user don't have any EDIT access,Please help me here

      Author's profile photo Christian AH-SOON
      Christian AH-SOON
      Blog Post Author

      Hi Abhilash,

      Web Intelligence Customization was indeed out of SAP BI 4.3 scope.
      Customization will be back in SAP BI 4.3 SP1 (to be released by the end of the year).
      As Web Intelligence interface has been simplified in SAP BI 4.3, the customization has also been simplified in SAP BI 4.3 SP1.

      In the meantime, if you want to prevent your users to modify documents, you may deny Web Intelligence application security right "Reporting: Enable document change".

      Regards,

      Christian