SAP BI 4.3 SP1: What’s New In Web Intelligence and Semantic Layer
Released in June 2020, SAP BI 4.3 has been completely renewed with modern interfaces and many expected new features.
Its first Support Package was highly expected by many since it re-introduces some features that were not yet available, enhances some user interface parts for better usability and improves the overall performance, stability and quality.
If you already know SAP BI 4.3, then this article describes Web Intelligence, Semantic Layer and (some) BI Launch Pad enhancements compared only to SAP BI 4.3:
- Web Intelligence: Usability Enhancements
- Web Intelligence: Hyperlinks Authoring
- Web Intelligence: Customization
- Web Intelligence: Text Data Source
- Web Intelligence: Export to CSV
- Web Intelligence: Formula Language and Formula Editor
- Web Intelligence: Prompts
- Web Intelligence: Rich Client
- Data Sources: New Data Sources
- Scheduling and Publishing
- BI Launch Pad
If you do not know yet SAP BI 4.3, you may rather read this article that merges the SAP BI 4.3 and SAP BI 4.3 SP1 content and exhaustively describes the Web Intelligence and Semantic Layer enhancements compared to SAP BI 4.2.
Web Intelligence: Usability Enhancements ⤒
Several improvements have been made in the new Web Intelligence interface to make it even easier to use.
In Edit mode, two buttons are displayed at the right side of the toolbar, one for the Main side-panel and one for the Build side-panel.
Edit Mode Side Panels
With these two buttons, you can independently open and close the Main and Build side-panels. These side panels are organized in tabs:
- The Main side panel contains the following tabs, the organization of which makes you think of the SAP BI 4.2 one:
- : Objects, to display the document dictionary with all objects retrieved by the queries and also the enrichments added by the document designer.
- : Structure, to display the report structure with the different blocks it contains.
- : Navigation Map, to quickly navigate in the report sections.
- : Comments, 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.
- : Properties, to display the document statistics and set its properties (Refresh on open, chart animations, …)
- The Build side panel contains the following tabs:
- : Data, to define the data structure of the selected item.
- : Format, to define the format of the selected item.
This new organization is intended to simplify the way you open and select these panels.It also provides you with more flexibility for the display of your documents. For example, to get more space for your document, you may close all side panels, or open only the Build side panel. These two last actions cannot be performed in SAP BI 4.3.
The display mode (Alphabetical, Queries, Folders) selected in the Objects tab is consistently used in other dialog boxes (Request 108799): Formula Editor, Input Control, Conditional Formatting, …)
Formula Editor: Object Displayed in Queries View Mode
In Queries View, if the document contains only one query, this query is displayed in expanded mode right away and all the retrieved objects are immediately available. If the document contains more than one query, these queries are displayed in collapsed mode (Request 107475).
In the Comments tab, the Copy All button is back, allowing you to copy all messages of the comment thread.
Comments: Copy All
In Reading mode, only one button is displayed in the toolbar. It can be used to display the Main side panel or not. In this side panel, the panes are organized in the following tabs: Navigation, Comments, and Properties.
Reading Mode Side Panel
In order to identify icons used to represent objects more easily, some of them have been changed compared to SAP BI 4.3. Additionally, they have colors similar to the ones you are used to see in SAP BI 4.2.
The following list details these objects and the icons used to display them.
- : Dimension
- : Merged dimension
- : Measure
- : Detail, calendar level and calendar level detail
- : Geo-dimension
- : Merged geo-dimension
- : Time dimension
- : Merged time dimension
- : Calendar
- : Filter
- : Filter set
- : Analysis dimension
- : Analysis time dimension
- : Hierarchy
- : Default hierarchy
- : Level
- : Member
- : Named set
- : Calculated member
- : Prompted member
- : Reference
These icons are consistently used everywhere in the Web Intelligence interface: in the Query Panel, in the Main and Build side-panels, in the Formula Editor, Conditional Formatting, Input Controls… dialog boxes.
Objects Tab in Main Side-Panel
When you create a query on top of a Web Intelligence document data source, these icons are also used to identify geographical dimensions, time dimensions and hierarchies that are defined in this document data source.
Query Panel: Web Intelligence Document Data Source
Data Source Icons
The icons used to identify a data source type are consistently the same in all places where queries are displayed.
Icons used to identify SAP BW and SAP HANA data sources have been changed:
- : SAP BW
- : SAP HANA
When you create a query based on an SAP HANA or SAP BW data source and, browse the repository for the connection to be used, the following icons are used to represent the possible connection types.
- : Relational connection
- : OLAP connection to a server
- : OLAP connection to an SAP HANA view, SAP BW Info Provider or query
- : HTTP connection, introduced in SAP BI 4.3 for SAP HANA only
User Interface Persistence
The following Web Intelligence user interface settings are saved and reused in your next session:
- The “open” or “closed” status of the Main and Build side panels
- The selected tab of the Main and Build side panels
- The selected display view (Alphabetical, By Query, By Folder) in the Objects tab of the Main side panel (Request 122309)
- The Instant Apply checkbox selection in the Format tab of the Build side-panel
- The size of the Query Panel dialog box
- The “open” or “closed” status of the Query Panel sections (Result Objects, Filters, Data Preview) open or closed status and relative sizes
- The “open” or “closed” status of the Filter Bar
- The “open” or “closed” status of the Formula Bar
- The last colors you’ve selected in the Color Palette remain available. They are displayed at the bottom of the dialog box and you can use them as any other color.
Recently Used Colors in Color Palette
When you create a group of input controls, this group is automatically added to the Filter Bar with all input controls it contains (the Add all ICs to the filter path checkbox is selected by default). You can remove them from the filter path later on.
Group of Input Controls: Default Display
Input controls based on constant variables drive the value for the whole document and are now displayed as document input control in the Filter Bar.
When selecting a chart or table in Edit mode, the floating toolbar is no longer displayed (Request 251210). Its commands (Send Forward, Send Backward, Hide When Empty, Sort, Add Break, Delete,…) have been added to the right-click contextual menu, if they were not yet available there.
Table and Chart Contextual Menu
In Edit mode, you can now directly insert any of all supported charts. In the Insert section of the toolbar, click the Insert chart button to open the menu. Select a chart category and in the sub-menu that opens, the chart to add.
Inserting a Chart
If you open a document that has been upgraded from a SAP XI 3.x system or that uses a universe for which a newer version exists, a warning is displayed to recommend saving the document. Saving it updates the document structure so that it must not be computed next time it is opened. This speeds up the document display. If you do not have the rights to save this document, this warning is not displayed (Request 255570).
Web Intelligence: Hyperlinks Authoring ⤒
While hyperlinks are still working in documents created with a previous product version, it is not possible to create or edit link to other document or intra-document link in SAP BI 4.3.
Creating or editing these links is possible in SAP BI 4.3 SP1: in Edit mode, select a cell, right-click it and select Hyperlink > Add Link in the contextual menu.
The Hyperlink dialog box is displayed. You can now create a link to any URL, to another document in the repository or to another report of the document.
CMC: Web Intelligence Properties
Link to URL
To add a link to any URL, add this URL in the Target URL text field. If your URL contains parameters you want to customize, click the Customize URL Parameters (Parse) button.
Hyperlink Dialog Box
Once the analysis is done, the list of parameters found in the URL are displayed in the Customize URL Parameters section. You may turn your link into a dynamic one by defining for each parameter if you want to pass values from an object or by adding a formula. You select these options in the drop-down menu beside each parameter. You may also keep a parameter static either through its initial value or by explicitly typing a new one.
Hyperlink: Parsed URL
In the URL Options section, you may define how the hyperlink is displayed in the report: the hyperlink text, and the tooltip for this hyperlink. In both cases, you may pass the value of an object, a formula or a static value, as for the URL parameters.
Hyperlink: URL Options
Click OK to close this dialog box and finalize the creation of the hyperlink.
To create a link to another document in the repository, you may also enter its URL in the Target URL text field. You can retrieve this URL in 2 ways:
- Select the document in BI Launch Pad, and click Details from its contextual menu. You can copy the link to the document from the Document Link entry of the Details dialog box.
- You can open the target document in Edit mode and generate an URL to a specific part of the document. To generate an URL to a specific report, in the report menu, select Copy Link to the Report from the report tab menu of the document. To generate a link to a table, a chart or a cell, open the contextual menu of the selected item and select the Copy Link to the Table, Copy Link to the Chart, Copy Link of the Free Cell menu item. This will copy the URL to this object into the clipboard.
In both cases, you may then copy this link into the Target URL of the Hyperlink dialog box.
Document Link in Details Dialog Box
Once the URL is copied, it is recognized as a link to another document.
You may keep the full path URL or click the Use complete URL path to create hyperlink checkbox to change the URL and insert a relative path, so it remains valid if you change your base URL later on.
Click the Customize URL Parameters (Parse) button. Once the analysis is done, the list of parameters found in the URL (like the document type and ID) are displayed in the Customize URL Parameters section.
Click the Analyze the Document button. Documents properties are displayed in the Analyze the Document dialog box, where you can select the prompts to answer or how to manage document’s instance.
Inter-Document Link: Analyze the Document
If you have selected a few prompts, these prompts are added to the list of URL parameters. You can fill them with an object, a formula or a static value, as for URL link.
Inter-Document Link: Parameter Customization
You may also define in the URL Options section the link’s label and tooltip as for URL link.
Click OK to close this dialog box and finalize the creation of the link to another document.
To create a link to another report of the document, select the This Document section of the Hyperlink dialog box. In the Targeted Report within the Document drop-down list, select the report to open when this link is clicked.
In the Label text field, enter the text to display for this link. You may type a fixed string or use a dynamic string by selecting an object or editing a formula. Likewise, you may define a tooltip for this link, based on a fixed or dynamic string, in the Tooltip text field.
Intra-Document Link: Report List
Click OK to close this dialog box and finalize the creation of the link to another report in this document.
Web Intelligence: Customization ⤒
In SAP BI 4.3, the Web Intelligence interface has been simplified compared to SAP BI 4.2. The customization capability, that allows Administrators to hide some elements of the interface, is back in SAP BI 4.3 SP1. It is also simpler than in SAP BI 4.2.
Customization supports a high-level grain, where you can hide some features, rather than individual user interfaces elements. The possible features that can be hidden are:
- Mode > Edit: To allow Web Intelligence to open in Edit mode.
- Mode > Reading: To force the user to open Web Intelligence only in Reading mode. If both Edit and Reading modes are disabled, Web Intelligence opens in Reading mode.
- Data Source > Universe: To hide the data source option when creating a document, adding a query or changing the document data source.
- Data Source > Web Intelligence document: To hide the data source option when creating a document, adding a query or changing the document data source.
- Data Source > Excel: To hide the data source option when creating a document or adding a query.
- Data Source > Text: To hide the data source option when creating a document or adding a query.
- Data Source > SAP BW: To hide the SAP BW data source option when creating a document, adding a query or changing the document data source.
- Data Source > SAP HANA: To hide the SAP HANA data source option when creating a document, adding a query or changing the document data source.
- Data Source > Free-hand SQL: To hide the free-hand SQL data source option when creating a document or adding a query
- Refresh > Refresh: To hide the Refresh buttons in the toolbar and in the Query Panel.
- Refresh > Advanced Refresh: To hide the Advanced Refresh command in Reading mode (Request 238434).
- Refresh > Auto-Refresh: To hide the Auto-Refresh command in Reading mode.
- Document > Comments: To hide the Command tab and the Add comments menu or button. Disabling this feature does not prevent to see existing comments.
- Analysis > Drill: To hide drill filters and prevent drilling and enabling drill.
- Export to > Excel: To hide the Excel option when exporting a document into another file format.
- Export to > PDF: To hide the PDF option when exporting a document into another file format.
- Export to > HTML: To hide the HTML option when exporting a document into another file format.
- Export to > Text: To hide the Text option when exporting a document into another file format.
- Export to > CSV: To hide the CSV option when exporting a document into another file format.
Granting export file formats is no more done by security rights but by the Export to customization, that covers all file formats. However, for the moment, these customizations apply to the Web Intelligence interface, but not to scheduling.
Customized List of Data Sources
As in SAP BI 4.2, customization can be assigned in the CMC, per user group and per folder.
CMC: Group Customization for Web Intelligence
Web Intelligence: Text Data Source ⤒
The Text file data source support is back in SAP BI 4.3 SP1.
When you create a document, or when you add a query to a document, the Text file option is available.
Select a Data Source: Text
Selecting this option allows you to browse the BI Platform repository and list the Text and CSV files that have been uploaded to the public or your personal folders. Select a file and click Open.
Text File Selection
In the Custom Data Provider – Text file options, you may define the properties to interpret the Text file. In the Data Separator section, where you can select how columns are separated in the file, the Character menu contains by default the comma and the semicolon. You may also type any character in this text field.
Text File Option
Once you have selected your options, click OK to open the Query Panel where you can finalize and run your query.
Text File Query Panel
Local Text data sources (as well as local Excel data sources) are not yet supported in Web Intelligence Rich Client.
Web Intelligence: Export to CSV ⤒
When you export to a CSV file, both in the interface or through scheduling, you can select the character to use as a column separator.
The Column Delimiter drop-down menu contains by default the comma, the semicolon and the tab character, but you can type any character in this text field.
CSV Export: Column Separator
Web Intelligence: Formula Language and Formula Editor ⤒
Pos and RPos
To ease string manipulation (Request 120009), the Pos function has been improved with an optional start and end position for the search. Additionally, a new RPos function, used for the reverse search has been introduced. The signatures of these functions are:
- string Pos ( string fullstring; string pattern[; integer start [; integer end ]])
- string RPos ( string fullstring; string pattern [; integer start [; integer end ]])
- fullstring is the string in which the search is performed.
- pattern is the string to search.
- start is the position in the string at which the search starts.
- end is the position in the string at which the search ends.
If only start is provided, the search is done between this position in the string and the end of the string, for both Pos and RPos.
These functions return 0 if the search is not successful.
The Formula Editor has been reorganized to display more items in the Objects, Functions and Operators tree lists (Request 221155). This is especially useful if you are working on a screen with a low resolution.
When inserting the Between, ForAll, ForEach, In, InList, Not or Where operator in a formula, parenthesis are added after the operator (Request 217308).
If you use auto-completion to add an operator (If, Then, Else, And, Or…) or a function that is not followed by parentheses, a space is automatically added after the insertion (Request 236699).
Prompt Predefined Cells
In Edit mode, if your document contains prompt(s), when you insert a cell from the toolbar, the Prompt menu is available in the Insert > Predefined Cells menu, where you can select to add:
- A cell with the PromptSummary formula, through the Summary command.
- For each prompt, a cell with the answers of this prompt.
Prompt Predefined Cells
Web Intelligence: Prompts ⤒
Sort List of Values
In the Prompts or Query Panel Filters dialog boxes, you can sort the list of values.
You can sort the values by ascending or descending order, or simply not sort them and keep the values in the order returned by the server.
To apply a sort, click the Select order icon in the list of values’ header, and in the menu that opens, select Sort ascending, Sort descending or Server order.
Order List of Values
If you have a list of values with multiple columns, you can choose which column to sort.
Order Multi-Column List of Values
If you have a multidimensional list of values, only the values of the current node are sorted.
SAP BW / SAP HANA
For queries based on SAP BW or SAP HANA, prompts are displayed in the following order:
- SAP BW or SAP HANA key dates.
- SAP HANA or SAP BW variables, in the order defined in the SAP BW or SAP HANA database system. When you click the button to set a variable’s value, if this variable depends on other variables, you may expand the Dependencies section to list all these depending variables.
- Prompts created in the query panel or the universe.
SAP BW / SAP HANA Set Variables Dialog Box
SAP BW / SAP HANA Prompt Dependencies
If you use an OLAP universe created with Universe Design Tool on top of SAP BW, you may display and set key dates values. In Edit mode, in the toolbar, in the Data section, select the Keydates command.
This opens the Keydate Properties dialog box in which you can set:
- Their default value to all key dates.
- A common value for all key dates.
- For each key date, a specific value or its default value.
Web Intelligence: Rich Client ⤒
Download Web Intelligence Rich Client Installer
It is possible to download the Web Intelligence Rich Client installer from the BI Launch Pad.
Once you are logged in the BI Launch Pad, click on the menu on the top right if the page. In the menu; select Settings, then Application Preferences. In the Web Intelligence tab, containing Web Intelligence preferences, click the Download link to upload the Web Intelligence Rich Client installer on your desktop.
Web Intelligence Preferences: Download Installer
Once downloaded, you can run this setup to install Web Intelligence Rich Client.
You may want to look for a string in the active windows. To do so, press the [Ctrl]+[F] keys and type the string to search in the text field that appears at the top right. The found instances will be highlighted in the active report page.
Web Intelligence Rich Client: Find
Web Intelligence Rich Client: Show Password
To align with the BI Launch Pad Home Page, the user menu has been moved from the left side of the Home Page to the right.
Web Intelligence Rich Client: User Menu
Data Sources: New Data Sources ⤒
The following databases are newly supported databases for relational connections and universes:
- MongoDB through JDBC and ODBC drivers that are provided at installation time (Request 121099)
- SAP Data Warehouse Cloud through a dedicated data source (it was previously available in SAP 4.3 through the SAP HANA driver)
Information Design Tool: Relational Connections
The eFashion sample universe is available on UNIX and Windows since the database has been moved to an SQLite database. However, the SQLite driver is only supported for this sample.
Scheduling and Publishing ⤒
Several enhancements have been made for scheduling:
- In the Schedule instances page, to display the instances, you can switch between a list view or a calendar view by selecting the Calendar button in the toolbar.
Instance Page: Calendar View
- When adding an Email destination to a schedule or a publication, in the email properties, you can fill the Reply-To text field to define an email address if the schedule recipient answers to the received email.
- You can also format the message to be sent by using the options available in the toolbar of the text field: bold, italic, font, color…
Instance Page: Calendar View
- In the History page of a scheduled document, the list of instances is automatically refreshed every 3 seconds, as in SAP BI 4.2.
BI Launch Pad ⤒
SAP BI Launch Pad User Menu
This menu contains the following menu items:
- Settings: to open the different Settings dialog box, in which you can set your settings, applications’ options,…
- Edit Home Page: to reorganize the tiles on the Home Page.
- About: to display the About dialog box.
- Help: to open the Online Help.
- Logout: to exit SAP BI Launch Pad.
In addition to the capability to download the Web Intelligence Rich Client installer, there are only two new features in the Settings dialog box:
- In the Database Credentials tab of the User Account section, you can modify the Data Source Reference the administrator has defined in the CMC. Introduced in SAP BI 4.3, these Data Source References are used as secondary credentials for the authentication of connections.
BI Launch Pad: Data Source Reference
- New BI Launch Pad themes are available in the Appearance You can select them to modify the BI Launch Pad look and feel and select a high contrast display for a better visibility.
SAP BI Launch Pad: Themes
SAP BI Launch Pad Display
You can define the order of the tiles displayed in the top and Applications lines of the BI Launch Pad Home Page:
- The Documents, Folders, Categories, Instances, Recycle Bin, Inbox tiles in the Home line.
- The applications tiles (Web Intelligence, BI Workspace,…) in the Applications line.
To do so, select the Edit Home Page menu item of the user menu.
SAP BI Launch Pad: Ordering Tiles Order
A new page opens, in which you can drag and drop these tiles to re-order them in these two rows. Click Done to save your changes and return to the Home Page. The tiles are displayed according to the choices you have made.
Browsing the Repository Content
SAP BI Launch Pad: Folder Tiles View
Icons used for file types have been aligned with the ones used in other SAP applications:
- : Adobe PDF
- : Microsoft Excel or CSV file
- : Microsoft PowerPoint
- : Microsoft Word
- : Text file
- : Agnostic file
- You can open an object contextual menu through right-click, and not only by clicking the More button ().
- The click area of an on object is its full row.
- An object can be moved into another folder through drag and drop.
Thanks for the detailed update Christian.
Christian AH-SOON thank you very much for this blog!
Have you got information about liveoffice 4.3 and 4.3 SP1? What’s new?
Some new options have been introduced in SAP Live Office in SAP BI 4.2 SP6 and SP7 (like the comments or the positions of the imported blocks)
In SAP BI 4.3, apart from platform support, performance issues, defects correction and compliance with SAP technical policies, there were in fact very little room for innovations in SAP Live Office.
Awesome blog, as always Christian!!
Still no standalone Webi Rich Client login?
No unfortunately, this is not yet in SAP BI 4.3 SP1.
Thanks for sharing
Thank you for taking the time to share this information Christian. I hope we see more features in the next SP's
Thank you. Yes, unless changes in SAP plans, you can expect additional catchup features and some exciting innovations in SAP BI 4.3 SP2, planned Q42021.
Thanks for compiling.
I want to have Default Category and Tile View when user logins.
Default category is possible through Fiori BILP Settings, but tile view and category together is not there. which is still missing.
This is indeed something we should add in SAP BI 4.3 SP2.
"Local Text data sources (as well as local Excel data sources) are not yet supported in Web Intelligence Rich Client."
This is a big problem, in our environment we have many .wid files arond the network and on many PC, with link to many local files!
We need to wait for the SP2 in Q4 2021 or a later version?!
For us is impossible to change to 4.3 I'm sorry.
We know this is a common use-case but unfortunately we have not been able to make it for SP1.
The support of local Text and Excel file in Web Intelligence Rich Client should be part of SAP BI 4.3 SP2. At that time, when you'll upgrade to 4.3, you'll have an even better 4.3 🙂
Thanks a lot !!!!!!
This SP1 is very usefull and now we can really recommend to our SAPBO4.2 customers
Webi Development Team,
I'm really disappointed to see the Improvement Requests taking forever to bring in features that should've been taken care of (if all the scenarios were thought through) even before implementing. I'm talking about Intra-Document Link, there have been some updates to it, which is good, but why not update the feature to filter, instead of just using it as an option to Navigate to a different tab? Here is the idea I created for it, for which last decision about Planned long term was made around 2 yrs ago.
Also, for the Chart Animation, there should be an option to animate only specific chart(s) or blocks which were affected by a selection in Input Control or Element linked blocks, checkout the idea here, and the frustrating part is, the idea has been Under Review for over 2 years.
Thank you for the fair feedback. We have spent these last releases to implement the new SAP UI5 interface, and with the SAP focus on SAC, it takes us more time to expected. This catch-up should be completed in SAP BI 4.3 SP2 with the support of Shared Element, Freeze Headers and more features you already know…
Fortunately, in SAP BI 4.3, we have only one single interface and we won’t have to develop a feature in different client versions (DHTML, Java Applet, Rich Client and even Web Intelligence Interactive Viewer), as it was the case in SAP BI 4.2. This should help us to reduce our development time.
About the two ideas you are referring to, we prefer to remain cautious and not commit too fast.
The status on the Influence web site is not always accurate (Web Intelligence is one of the SAP products that receive the largest number of requests); but be assured we have reports to monitor the requests that are posted there.
Thank you for your support!
Appreciate your detailed response a lot!
We understand that maintaining multiple client versions is taking up a lot of resources, so it makes sense to have only one client version and have most of the dev team to work on it.
I'll be eagerly waiting for SP3 to see the new features and also keep my fingers crossed on 2 of my ideas to be implemented, which will help us to create compelling Dashboards in Webi.
Christian AH-SOON , I'm glad that 2 of the ideas I've listed in my above comment have been Accepted, hoping to see them in the next couple of SPs to be released.
Christian AH-SOON & SAP Developers,
Appreciate your effort to add the Intra-Document Link Input Control feature I requested!
Thanks for the detailed update Christian.But we have an issue when we click on a Tile of Analysis Office 2.8 Workbook it does not open the Excel instead we receive a Error Msg like this:
404 Missing Page
The page you requested is not available on this web server for one of the following reasons:
After verifying that the error is not the result of a bad address or web application problem, perhaps the page you tried to access may no long exist or can not be generated. Report this problem to the webmaster or the administrator.
If you are the webmaster or the administrator of this web server, refer to the SAP Business Intelligence Suite Error Messages Explained Guide for more suggestions.
If the problem still persists, please:
We need a solution for that! Can anyone help?
Thanks a lot!¨Kind regards
Thank you Adrian,
Are you running SAP BI 4.3 SP1?
In case this is a configuration issue, would you please try to redeploy the boe web application?
If this is still not working, you might create a case to support.
i have solved the Problem with a workaround.
Change the Settings to "Open in a new Window" then its working, and with 4.3 SP01 Patch 11 should be solved this stuff.
We are currently in 4.3 sp01 patch 07.
Is there any option to hide save button to specific user group