Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
Ashok_R
Product and Topic Expert
Product and Topic Expert
15,512
This document summarizes the planned enhancements in the next SAP BI 4.2 Support Package 6 for BIPlatform.

SAP BI 4.2 SP06 is now generally available. Please refer the below blog for more details:

https://blogs.sap.com/2018/07/30/sap-businessobjects-business-intelligence-suite-4.2-sp06-sp6-releas...

Following the enhancements brought in SAP BI 4.2 and its Support Packages (see here for more details), SAP keeps investing in the most popular and used Analytics tool in the SAP Portfolio.

SAP BI 4.2 SP6 delivers many awaited features and incremental enhancements so as to create the foundation for all follow-up releases and meeting the high expectations of our large customer base.

 

Below are the New features for BI 4.2 SP06 release from BIPlatform:


1. Decoupling BIP RestSDK stack out of WACS for WebSphere


2. SAML 2.0 Enhancements:



  • Email support in SAML Integration to BI Platform

  • SAML 2.0 support for Central Management console.

  • SAML 2.0 authentication Support for BI Platform thin Clients (BILP, FBILP, OpenDocument and CMC) with Websphere Application Server.

  • SAML 2.0 integration in BIPlatform with SHA-2 support

  • Simplify the SAML authentication configurations in BI Platform.

  • logonNoSso.jsp is now supported for SAML 2.0 SSO


3. Lumira documents are now supported in BIworkspace.


4. BI platform supports OData services for the integration between the Fiori Launchpad and SAP Enterprise Portal


5. BI Platform now supports OData Services in NetWeaver application server


6. Disabling the GDPR Popup Message


7. What's New in Fiorified BI Launch Pad:



  • You can now remove an item from your list of Favorites by choosing the * icon on the item previously marked as favorite.

  • You can now delete custom images you added to a category.

  • Destination rights in Fiori BILP


8. Sharepoint 2016 support.


9. Introduction of Date placeholder


10. Licensing enhancement - Number of core information on servers


11. TLS 1.2 Support for LDAP


12. Audit DB Changes


 

1. Decoupling BIP RestSDK stack out of WACS for WebSphere :


In BI 4.2 SP05, the BIP RESTful web services can also be deployed in the default Tomcat application server. For more information please refer the below blog.

From BI4.2 SP06 onwards, BIPRestful web services can additionally be deployed on the supported websphere application server.

 

1.1 Configuring RESTful Web Services for WebSphere Server: 


If you are using a non-WACS server such as WebSphere, you can set the RESTful Web service parameter values as part of server configuration.

To configure the RESTful web services for WebSphere application server, follow the procedure given below:

  1. Stop the WebSphere server.

  2. Access the file propertiesin the following file-path: <WebSphere-location>\webapps\biprws\WEB-INF\config\custom.

  3. Specify the values of following parameters in the file based on your custom requirements and save the file.



  • <Default_Number_Of_Objects_On_One_Page>

  • <Enterprise_Session_Token_Timeout_In_Minutes>

  • <Session_Pool_Size>

  • <Session_Pool_Timeout_In_Minutes>

  • <Log_Level>

  • <Log_Location>


4. Restart the WebSphere server.

Note:

The default version of biprws.properties is available at <WebSphere-location>\webapps\biprws\WEB-INF\config\default and your configuration for above listed parameters in custom file path overrides the default settings once you restart the server.

 

2. SAML 2.0 Enhancements:



2.1 Email support in SAML Integration to BI Platform :


Cloud applications are HTTP friendly as almost everything happens on that protocol. And hence, same is true for SAP Analytics cloud, SAP Analytics Hub which all support SAML as authentication mechanism.

From BI 4.2 SP05 onwards, Service provider implementation in BIPlatform supports SAML integration to BIPlatform for tomcat application server. However, the identity propagation is done though the User IDs.

Refer: https://blogs.sap.com/2017/11/17/saml-authentication-for-boe-on-tomcat/

Most of the cloud applications (SAP Analytics Cloud/SAP Analytics Hub) Login are based on Email. Hence, Now BIPlatform supports Email Authentication for SAML 2.0 integration.

Configuration steps for configuring Email authentication for SAML 2.0 integration to BIPlatform:

Edit the properties file by adding below fields and also Refer the filenames and its location below:

 

saml.enabled=true

saml.isUseEmailAddress = true 

saml.authType = secEnterprise

 

The second parameter takes Boolean values and the third parameter denotes the authentication type of the user/alias details with which the login is expected to happen.

The email feature can be handled individually for each application stated above.

If saml.isUseEmailAddress is set to false , then the exception is that login will happen based on the name parameter.

If set to true , then the exception is that login will happen based on the email parameter.

The purpose of the third parameter is to check for duplicity in the system , which ensures no two aliases of same authentication type can have the same email address as in this case , there is a conflict of which authentication type to use to authenticate and create session.

If in case , if any duplicity exists in the system , "alias name or email is not unique error" will be thrown at the interception screen.

 

  1. For BI Launch Pad, go to <INSTALLDIR>\tomcat\webapps\BOE\WEB-INF\config\customand edit the properties file.

  2. For Fiorified BI Launch Pad, go to <INSTALLDIR>\tomcat\webapps\BOE\WEB-INF\config\customand edit the properties file.

  3. For Open Document, go to <INSTALLDIR>\tomcat\webapps\BOE\WEB-INF\config\customand edit the properties file.

  4. For CMC, go to <INSTALLDIR>\tomcat\webapps\BOE\WEB-INF\config\customand edit the properties file.


 

Note:

  1. For CMC, you should set another property sso.supported.types = trustedSession in the CMCApp.properties file.

  2. If the application does not contain the custom properties file, create a new one.


 

Note: 

Set up the following prerequisites to use the SAML authentication feature to login via the email address of:

  • Third-party users: 


          Use the command line parameter “-importtpemailduringsync” to enable the import of email                 addresses from a third-party system:

          1. Add the parameter “-importtpemailduringsync” to CMS -->properties -->Command Line       Parameters 

     2. Restart the CMS

     3. Do the third-party authentication update of the third-party whose user’s email you want to use for login. The supported third-party authentication types for this feature are SAP, LDAP and WinAD.

  • For Enterprise users Refer to SAP note 2642247 .


 

If you are using SAP cloud Identity provider, Below are the steps to Configure for EMAIL support :

 

Refer the below link for more details: 

https://help.sap.com/viewer/6d6d63354d1242d185ab4830fc04feb1/Cloud/en-US/1d020e3a3ba34c43a71fde70bfa...

 

  1. Access the tenant's administration console for SAP Cloud Platform Identity Authentication service by using the console's URL.


Note:

The URL has the https://<tenant ID>.accounts.ondemand.com/admin pattern.

Tenant ID is an automatically generated ID by the system. The first administrator created for the tenant receives an activation e-mail with a URL in it. This URL contains the tenant ID.

  1. Choose the Applications


This operation opens a list of the applications.

  1. Choose the application that you want to edit.


Note: 

Type the name of the application in the search field to filter the list items, or choose the application from the list on the left.

If you do not have a created application in your list, you can create one. For more information, see Create a New Application.

  1. Choose the Trust

  2. Under SAML 2.0, choose Name ID Attribute.

  3. Select the name ID Attribute from the following:


        E-Mail

  1. Save your selection.


Once the application has been changed, the system displays the message Application <name of application> updated.

 

Tip: 

Import all the IDP users with the E-mail address to BIPlatform and now if you access any of the SAML 2.0 configured BIPlatform applications (BILP, Fiori BILP, Open document, CMC) it redirects to IDP logon page.

Once the E-mail address and Password credentials are valid, It will provide the access to BIPlatform resources.

 

Note :

Generate and upload the service provider metadata: 


Go to http://host:port/BOE/BI/saml/metadata. The XML file gets downloaded automatically after navigating to the above URL.Upload the XML file to the identity provider.  Upload this in IDP using the relevant IDP’s feature support.

if SP metadata file end-point is always generates with http or localhost and you need to generate with FQDN and with https then below are the steps to achieve this:

  1. For the first time, if you are generating the SP Metadata.xml with FQDN and http then it will continue always with FQDN name and http only even if you try with localhost/vmname or https. Since it will be cached in the tomcat work folder.

  2. If you want the name to be populated with the actual name, then the possible solution to clean the tomcat work folder and generate the SP meatdata.xml.

  3. if above steps are not working then Full Restart on all systems might solve this issue.


 

2.2 SAML 2.0 support for Central Management console:


In BI 4.2 SP05 release, SAML 2.0 Service provider implementation for Tomcat Application Server using SAML 2.0 is supported for BIPlatform thin Clients (BILP, FBILP, OpenDocument).

Now, BI 4.2 SP06 onwards, Central Management console Application is also supported.

Configure SAML 2.0 integration to BIPlatform. Refer the below blog for more details.

https://blogs.sap.com/2017/11/17/saml-authentication-for-boe-on-tomcat/

 

For CMC, go to <INSTALLDIR>\tomcat\webapps\BOE\WEB-INF\config\custom and edit the CMCApp.properties file.

 

Ex:

saml.enabled=true

sso.supported.types = trustedSession

Note:

For CMC, you should set another property sso.supported.types = trustedSession in the CMCApp.properties file.

2.3 SAML 2.0 authentication Support for BI Platform thin Clients (BILP, FBILP, OpenDocument and CMC) with Websphere Application Server:


Using the Spring SAML implementation and SP configuration from BIPlatform, SAML 2.0 is supported for all BIP thin clients (BILP, FBILP, OpenDocument, CMC) for websphere application server.

Note:

  • SAML 2.0 implementation is supported for websphere 9.

  • The steps mentioned below use SAP Cloud Identity Provider as the default identity provider.


  

The topic contains instructions to configure the WebSphere application server for SAML 2.0 authentication.

 

Follow the steps below:

  1. Add the SAML WebSphere service provider jars.



  • Copy the SAML jars present in to <BOE Install Dir>\WebSphere\webapps\BOE\WEB-INF\lib<BOE Install Dir> \SAP BusinessObjects Enterprise XI 4.0\SAMLJARS.

  • Stop WebSphere.

  • Delete the Workfolder from <BOE Install Dir>\WebSphere.

  • Restart WebSphere.


2. To configure trusted authentication with web session, follow the steps below:

  • Add the global.properties file under the custom folder <INSTALLDIR>\SAP BusinessObjects\WebSphere\webapps\BOE\WEB-INF\config\custom. Following is the content for global.properties:


 sso.enabled=true

           trusted.auth.user.retrieval=WEB_SESSION

           trusted.auth.user.param=UserName

  • Go to CMCAuthentication  Enterprise.

  • Enable Trusted Authentication.

  • Set the Validity.

  • Choose New Shared Secret.

  • To download the generated shared secret, choose Download Shared Secret.


The TrustedPrincipal.conf file is downloaded.

  • Paste the TrustedPrincipal.conf file in <INSTALLDIR>\SAP BusinessObjects Enterprise XI 4.0\win64_x64and <INSTALLDIR>\SAP BusinessObjects Enterprise XI 4.0\win64_x64

  • Go to CMCAuthentication  Enterprise and choose Update.

  • Restart WebSphere.



  1. If you are using SAP Cloud Platform Identity Provider, export all the users and then import them to the BI platform. Refer How to import users in bulk from Central Management Console


To export SAP Cloud Platform users to CSV, refer

Export Existing Users of a Tenant of SAP    Cloud Platform Identity Authentication Service

  1. Edit the xmlfile located at <INSTALLDIR>\WebSphere\webapps\BOE\WEB-INF.


In securityContext.xml file, locate the SAML entry point in the XML code as below:

 

Sample Code:

<security:http entry-point-ref="samlEntryPoint" use-expressions="false">

<!-- Comment/Uncomment for Launchpad-->

<security:intercept-url pattern="/BI" access="IS_AUTHENTICATED_FULLY"/>

<!-- Uncomment for Opendocument-->

<!--<security:intercept-url pattern="/OpenDocument/**" access="IS_AUTHENTICATED_FULLY"/>-->

<!-- Uncomment for Fiori Launchpad-->

<!--<security:intercept-url pattern="/BILaunchpad" access="IS_AUTHENTICATED_FULLY"/>-->

<!-- Uncomment for CMC-->

<!--<security:intercept-url pattern="/CMC" access="IS_AUTHENTICATED_FULLY"/>--><security:custom-filter before="FIRST" ref="metadataGeneratorFilter"/>

<security:custom-filter after="BASIC_AUTH_FILTER" ref="samlFilter"/>

</security:http>

  • For OpenDocument, uncomment <security:intercept-url pattern="/OpenDocument/**" access="IS_AUTHENTICATED_FULLY"/>

  • For Fiorified BI Launch Pad, uncomment <security:intercept-url pattern="/BILaunchpad" access="IS_AUTHENTICATED_FULLY"/>NoteThe XML tag for Classical BI Launch Pad is enabled by default..

  • For CMC, uncomment <security:intercept-url pattern="/CMC" access="IS_AUTHENTICATED_FULLY"/>



  1. Edit the properties file by adding enabled=true. Refer the filenames and its location below:



  • For BI Launch Pad, go to <INSTALLDIR>\WebSphere\webapps\BOE\WEB-INF\config\custom and edit the properties file.

  • For Fiorified BI Launch Pad, go to <INSTALLDIR>\WebSphere\webapps\BOE\WEB-INF\config\customand edit the properties file.

  • For Open Document, go to <INSTALLDIR>\WebSphere\webapps\BOE\WEB-INF\config\custom and edit the properties file.

  • For CMC, go to <INSTALLDIR>\WebSphere\webapps\BOE\WEB-INF\config\customand edit the properties file.NoteFor CMC, you should set another property sso.supported.types = trustedSession in the CMCApp.properties file.


Note:

If the application does not contain the custom properties file, create a new one.

6. Activate the XML tags in the web.xml file.

  • Go to <INSTALLDIR>\WebSphere\webapps\BOE\WEB-INF.

  • Open xml.

  • Search for filter in the xml file.

  • Uncomment filter to enable SAML.

  • Search for filter-mapping in the xml file.




  • Uncomment filter-mapping to enable SAML.




  • Similarly, search for context-param and listener.

  • Uncomment context-param and listener.




  • Save the file.


 

7. To update the IDP metadata in SP, download the IDP metadata from the respective IDP service          providers. Copy the metadata file to <BOE Install Dir>\WebSphere\webapps\BOE\WEB-INFand        rename it to idp-meta-downloaded.xml .

For more details on downloading the IDP metadata, refer Tenant SAML 2.0 Configuration

     Note: A new algorithm SHA-256 is now supported for the SAML integration.

8. Restart the WebSphere application server.

Note :

If BOE is deployed on any Non -Windows machine, the path seperators in filepath to the IDP metadata under the bean FilesystemMetadataProvider should be changed in securityContext.xml under <BOE Install Dir>\WebSphere\webapps\BOE\WEB-INF.

i.e <value type="java.io.File">/WEB-INF/idp-meta-downloaded.xml</value> has to be changed to<value type="java.io.File">\WEB-INF\idp-meta-downloaded.xml</value> .

 

To generate keystore for enabling SAML 2.0 (optional)

This step is applicable only if you want to use your own keystore file.

SAML exchanges involve usage of cryptography for signing and encryption of data. A sample self-signed keystore sampletestKeystore.jks is packaged with the product and is valid till October 18, 2019. sampletestKeystore.jkshas an alias name Testkey and password Password1. You can now generate a self-signed keystore file using the JAVA utility keytool. Follow the steps below to generate a keystore file:

  • Navigate to <INSTALLDIR>\SAP BusinessObjects Enterprise XI 4.0\win64_x64\sapjvm\bin.

  • Run the command: keytool -genkeypair -alias aliasname -keypass password -keystore samplekeystore.jks -validity numberofdays
































Command Description
-alias Enter the alias name of the certificate
-keypass Enter the certificate’s password
-keystore Name of the keystore file
-validity Validity of the certificate
numberofdays Number of days for which the self-signed certificate is valid.



  • The following questions are prompted after executing the command:

    • Enter keystore password: *****

    • Re-enter new password: *****

    • What is your first and last name? : Ashok Rajashekar

    • What is the name of your organizational unit? : BusinessObjects

    • What is the name of your organization? : SAP

    • What is the name of your city and locality? : BLR

    • What is the name of your State and Province? : KA

    • What is the two-letter country code for this unit? : IN



  • Stop the WebSphere application server.


The keystore file is generated at <INSTALLDIR>\SAP BusinessObjects Enterprise XI 4.0\win64_x64\sapjvm\bin.

  • Move the keystore file to <INSTALLDIR>\WebSphere\webapps\BOE\WEB-INF

  • Edit the xmlfile located at <INSTALLDIR>\WebSphere\webapps\BOE\WEB-INF with the new alias name, password, and keystore file name. Refer the XML code below:


Sample Code:

<bean id="keyManager" class="org.springframework.security.saml.key.JKSKeyManager">

<constructor-arg value="/WEB-INF/sampleKeystore.jks"/>

<constructor-arg type="java.lang.String" value="Password1"/>

<constructor-arg>

<map>

<entry key="aliasname" value="password"/>

</map>

</constructor-arg>

<constructor-arg type="java.lang.String" value="Testkey"/>

</bean> 


































Refer the table below for understanding the arguments:
  XML Tag Description
 <constructor-arg value="/WEB-      INF/sampleKeystore.jks"/> Locates the keystore file.
<constructor-arg type="java.lang.String" value="Password1"/> Password for the keystore file.
<entry key="aliasname" value="password"/> Alias password
<constructor-arg type="java.lang.String" value="Testkey"/> Alias of the default certificate


9. Generate and upload the service provider metadata.

Note:

You can use the default service provider metadata file spring_saml_metadata.xml located                   at<INSTALLDIR>\WebSphere\webapps\biprws\WEB-INF instead of generating it manually. You         must replace the XML tag <replace_withip> with the IP address or hostname of the machine               based on your network, and <replace_withport> with port number of the WebSphere application         server. Replace HTTP with HTTPS if you have enabled HTTPS in WebSphere.

10. If you are using SAP Cloud Identity, to create a SAML application in IDP and upload the SP xmlin the IDP for configuring the SAML SSO to BIPlatform, refer Configure a Trusted Service Provider.

11. Restart the WebSphere application server.

   Note:

The latest service provider metadata must be generated after the keystore file is modified.

Tip:

To check if SAML integration is successful, once you launch the SAML configured application (BI launch pad, Fiori BI launch pad or OpenDocument), you are redirected to the IDP.

 

2.4 SAML 2.0 integration in BIPlatform with SHA-2 support:


SAML integration to BIPlatform delivered in BI 4.2 SP05 release works only with SHA-1 certificate.

From BI 4.2 SP06 onwards, SHA-2 certificate is supported for SAML 2.0 integration to BIPlatform using ADFS/SAP cloud Identity providers.

 

2.5 Simplify the SAML authentication configurations in BI Platform: 


As part of BI 4.2 SP05 release, SAML integration into BI platform is supported using Open SAML 2.0 for tomcat application server.

In one of the confirmation steps, SAML related Jars has to be manually copied into the BOE/WEBI-INF/lib folder.

Copying all Jars manually will increase the Configuration process and time.

For BI 4.2 SP06 above steps are simplified and all the SAML related Jars are copied automatically during the BOE default installation with Tomcat application server.

 

2.6 logonNoSso.jsp is now supported for SAML 2.0 SSO:


From BI 4.2 SP06 onwards, logonNoSso.jsp is supported for BIP thin clients (BILaunchpad, Fiori BILaunchpad and CMC) using SAML 2.0 SSO. This is mainly used to login to BIPlatform without SSO and by entering the credentials manually.


 

3. Lumira documents are now supported in BIworkspace: 


Till BI 4.2 SP05 release, BI workspace doesn't support Lumira documents.

Most ask from the customers is to have a support of Lumira documents in BIworkspace.

From BI 4.2 SP06 release, Modules and BIworkspace can be created and be viewed in BILaunchpad successfully for Lumira documents.

 



 

4. Support of BIPlatform Personal folders and Inbox in NW Fiori Launchpad Enterprise portal:


BI platform key user creates new BI reports for the end users on Fiori LaunchPad (FLP) on SAP NetWeaver Enterprise Portal (EP). The reports are visible on FLP on EP without a delay and an additional effort EP administrator side.

 

In BI 4.2 SP04 release, BIPlatform public folders content in Fiori Launchpad is integrated to SAP NetWeaver Enterprise Portal by exposing Odata services.

 

Refer below links for more details :

https://blogs.sap.com/2017/05/15/bi-platform-odata-service-for-sap-fiori-launchpad/

 

https://blogs.sap.com/2017/05/14/business-objects-enterprise-integration-with-sap-fiori-launchpad-on...

 

From BI 4.2 SP06 onwards, Odata services implemented to support BIPlatform Personal folders and Inbox contents.

 



 


5. BI Platform now supports OData Services in NetWeaver application server:


 

Currently OData Services can only be deployed in Tomcat Application server.

From BI 4.2 Sp06 onwards, OData war file can be deployed in SAP NetWeaver application server.

 

6. Disabling the GDPR Popup Message:


 

In BI 4.2 SP05 GDPR Data protection Pop up message is mandated for all users as part of GDPR regulations for Data protection when logging to BILaunchpad, CMC, Fiori BILaunchpad and Open Document.

 



 

The Data Protection pop-up should not, and cannot be disabled proactively.  To ensure compliance with EU GDPR, all users of these applications must actively accept this message before proceeding.


 


By knowing GDPR Data protection message is mandate and still if customers want to disable this message then they will have an option to disable this Data protection Pop up from BI 4.2 SP05 Patch 3 and BI 4.2 SP06 onwards.


Please refer the below blog for more details :


https://blogs.sap.com/2018/05/16/how-to-disable-gdpr-data-protection-pop-up-message-in-cmc-bilaunchp...


 

7. What's New in Fiori BI Launch Pad:


 

7.1 Customize the list view Would like to « unfavorite » a document by clicking on the star:


 From BI 4.2 SP06 onwards, Fiori BILaunchpad now has an option to remove favorites by clicking on the star for the tile view and list view in Home page.

 



 

7.2 Option to delete the custom images added in the category Tile view:


In BI 4.2 SP05 release, Adding custom images for categories are supported. But there is no option to delete these custom images.

From BI 4.2 SP06 onwards, FBILP categories supports deleting the custom images in Tile view. Default category images are applied once the custom images are deleted.


7.3 Destination rights in Fiori BILP:


From BI 4.2 SP06 release, Fiori BILP supports additional rights for scheduling destinations. Ie., we can now control the rights of scheduling destination individually i.e. for

FTP,

SFTP,

SMTP,

File system

BI Inbox
Today if administrator has enabled any destination in job server, then for any user having the right to schedule, can select any of the destinations.

8. Microsoft SharePoint 2016 Support in BI Platform:


SharePoint 2013 is in end of life mode and IOMS is now supports SharePoint 2016.

From BI 4.2 SP06 release, IOMS is certified and supports Microsoft SharePoint 2016.

All existing supported BOE web parts in IOMS with SharePoint 2013 is now can be deployed successfully in SharePoint 2016.



 


9. Introduction of Date placeholder :


When Scheduling a report, there are multiple placeholders allows the scheduler to append a piece of metadata to the name of the report being exported.

Currently we have Datetime placeholder which is translated as: %SI_STARTTIME%.

When Date Time is added as a placeholder, it will add data and time like "2018-19-03-27-21".

There is no option if user wants only Date but not time.

In BI 4.2 SP06 release, A new placeholder for Date, %SI_DATE% has been introduced.

When this placeholder is used, it translates to Date in the runtime

 

For Ex:

%SI_DATE% - 2018-05-30

      

10. Licensing enhancement - Number of core information on servers:


 A new property has been added to get the number of cores per CPU.

 



 

11. TLS 1.2 Support for LDAP:


In BI 4.2 SP06 release, Started supporting TLS 1.2 communication from BOE to LDAP servers.

It supports all platforms except Linux this will work out of the box.

Note :

For Linux, customer needs to manually replace the ldap binaries from collateral folder. Please refer Note 2623529

 

Wireshark traces for BI 4.2 SP06:


12. Audit DB Changes:


12.1 SQL Anywhere:  



  • Event_Detail_Value column in the Audit BD was previously set as NVarchar, data beyond 32K Character gets truncated

  • In BI4.2 SP6 the Event_Detail_Value column was changed to long NVarchar which can accommodate 2gb. This is for GDPR compliance.


 

12.2 Sybase ASE and Oracle CMS DB:



  • Some concerns on performance degradation and CMS DB deadlocks reported on Sybase ASE and Oracle reported.

  • In BI4.2 SP6, added primary keys in Oracle and Sybase ASE which internally supports unique index to the corresponding tables (CMS_INFOOBJECT7, CMS_SESSIONS7,CMS_LOCKS7 and CMS_RELATIONS7)


Important Links: 

  • SAP Notes (2552129 - BI performance degradation, slowness and CMS DB deadlocks reported)


 

Learn More:


https://blogs.sap.com/2017/11/07/sap-bi-4.2-sp05-decoupling-of-bi-platform-restful-web-services-from...

https://blogs.sap.com/2017/11/06/sap-bi-4.2-sp05-whats-new-in-fiori-bi-launchpad/

https://blogs.sap.com/2017/05/18/fiori-bi-launchpad-administrator-configurations-and-settings/

https://blogs.sap.com/2017/12/19/sap-analytics-hub-saml-sso-to-biplatform-content/

https://blogs.sap.com/2018/05/16/how-to-disable-gdpr-data-protection-pop-up-message-in-cmc-bilaunchp...

 

 
28 Comments
denis_konovalov
Active Contributor
0 Kudos
Could you please clarify which official guides describe following :
4. BI platform supports OData services for the integration between the Fiori Launchpad and  SAP Enterprise Portal

5. BI Platform now supports OData Services in NetWeaver application server

Besides 2 blog posts, I cannot find anything on this in actual deployment/install/integration or admin guides on this.
Ashok_R
Product and Topic Expert
Product and Topic Expert
0 Kudos
Hi Denis,

Thanks for your question.

Please find the below official documents which talk about the Fiori Launchpad and SAP EP Integration.

https://help.sap.com/viewer/2e167338c1b24da9b2a94e68efd79c42/4.2.5/en-US/644fbc357fe34dcea86fd3de517...


https://help.sap.com/viewer/f2f3f4b4543a4803b9023e8c31f1e72a/7.5.7/en-US/5f9248fa1d224c6ca783344a3e9...


 

Most of the integration on the SAP NW side and all the complete configurations will be in NW guide.

But however, we are making sure that above points will be reflected in SP06 BIPlatform admin guide.

Thanks,

Ashok R

 
denis_konovalov
Active Contributor
0 Kudos
Thank you for that, but I'm confused - this should fall squarely into the realm of what SAP Integration Kit documentation covers, yet there we still have age old iviews and KM only....
Shouldn't all integration options between SAP NW portal and BOE be in one place ?
Ashok_R
Product and Topic Expert
Product and Topic Expert
0 Kudos
Hi Denis,

Portal integration Kits are also updated with the latest information and planned to be available in SP06 guides.

But this is entirely new settings and completely different from the old ones. so its better to keep it separately.

Thanks,
Ashok R
former_member193885
Contributor
0 Kudos
Hi Ashok,

Great blog!

Bullet point 4 mentioned we have the ability to read the personal folders, is this using the same ODATA service below? Can this be consumed directly from a custom Fiori app (not via SAP EP).

http://<host>:<port>/bipodata/

Does the ODATA service support SAML authentication?

Thanks.

 
Ashok_R
Product and Topic Expert
Product and Topic Expert
0 Kudos
Thanks Deepu for your question.

Yes. To read personal folders and Inbox content uses the below odata service:

http://<host&gt;:<port>/bipodata/

Odata services are delivered as APIs and can be used in any supported applications if that application understand our Odata API responses.

Currently Odata Services doesn't support SAML authentication.

 

Thanks,

Ashok R
0 Kudos
The following are the recommendations to be followed while importing the Third-party Users to perform SAML based authentication using email.

In case of Third-party (TP) user import, please follow the below step as this is marked as a pre-requisite for Third-party user import starting 4.2 SP06.

For TP users:

For users imported through the third-party plugins, the import of email address doesn't happen at the import of users workflow. So, we have a provided a command line argument "-importtpemailduringsync" to enable or disable the insertion of email addresses to the CMS_ALIASES7 table.

For customers who want to perform trusted SAML SSO using the email address of Third-party users, the pre-requisite is to add the command line argument to CMS and before performing the Third-party user sync.

This is already shared in the admin guide

https://help.sap.com/http.svc/rc/ec7df5236fdb101497906a7cb0e91070/4.2.6/en-US/sbo42sp6_bip_admin_en....

Please refer the Section 9.2.4.1 for more detailed information.

For the Enterprise Users, who are Older than 4.2 SP06, In case we wish to support this functionality, there is an script which need to be explicitly ran and the steps are mentioned in the

SAP Note: 2642247    https://launchpad.support.sap.com/#/notes/2642247

Best Regards,

Sateesh.
Ashok_R
Product and Topic Expert
Product and Topic Expert
0 Kudos
Thanks Sateesh for the information.
former_member572431
Discoverer
0 Kudos
Hi Ashok,

Great Doc.

Just want to know if you have integrated your BI 4.2 sp06 platform with SAML2.0 authentication using email addresses which is associated with your SAP BW account and it is working well, what changes we need in order to achieve the same for BO mobile app for ios devices.

Regards,

Sonu Pandita
kannan_andireddi
Product and Topic Expert
Product and Topic Expert
0 Kudos
Hi Sonu Pandita,

SAP BI Mobile Application is not supported SAML2.0 authentication as email addresses. We have the backlog item to Support SAML 2.0 to support Email Address from Mobile App also,

Regards,
Kannan
former_member572431
Discoverer
0 Kudos
Hi Kannan,

 

Thanks for your update. Any timeline when it is going to support.

 

Regards,

 

Sonu Pandita
former_member186327
Active Participant
0 Kudos
Nice article, Ashok!

Best,

Sathish
Ashok_R
Product and Topic Expert
Product and Topic Expert
0 Kudos
Thanks Satish

Regards,

Ashok R

 
mario_panzenboeck
Contributor
0 Kudos
Thanks for the blog!

Is it necessary to use tomcat SSL when upgrading to 4.2 SP6 or can we still go with http while accessing BI Launchpad / CMC.

 

Thanks!
Ashok_R
Product and Topic Expert
Product and Topic Expert
0 Kudos
HI Mario,

Thanks for your question.

For accessing BILaunchpad and CMC you can use both Tomcat SSL and Http as well.

 

Regards,

Ashok R

 

 
zeiserpa
Participant
0 Kudos
Hi Ashok,

in the BILP how is it possible to deactivate the search field? CSS? Setting?



Background is that our users open a Lumira dashboard and try to search customers, materials ... over the search field. Of coure I know we can search objects from the BILP over the search field, but it's confusing for our users.

Greetings

Patrick
zeiserpa
Participant
0 Kudos
ashok.rajashekar

Is there a possibility to hide the search panel?

Greetings

Patrick
Ashok_R
Product and Topic Expert
Product and Topic Expert
Hi Patrick,

Thanks for your question. Currently there is no option to hide the search box in the Fiori BILP.

we respect your ask and request you to add this requirement in our below Influence Portal link.

Based on the no.of votes we will prioritize this in the future releases.

https://www.sap.com/about/customer-involvement/influence-adopt.html

Regards,


Ashok R
zeiserpa
Participant
0 Kudos
Hi ashok.rajashekar ,

currently we are on BOE 4.2 SP6 Patch 0.

Is it possible in the Launchpad to get a direct URL to open a Lumira dashboard (not the openDoc URL) embedded in the Launchpad.

When I run a dashboard, I just see the same URL so when I enter this URL I will land on the startscreen, and not in the dashboard.

To achieve more distribution for the Launchpad this would be great (in our case we would paste the direct link in C4C and after click on the C4C-Tile the dashboard and also the Fiorified BI-Launchpad opens)

Best regards

Patrick

 
Ashok_R
Product and Topic Expert
Product and Topic Expert
Hi Patrick,

I believe you are expecting a hyperlink object to be opened within the Launchpad ie., in the unified viewer.  This is currently planned in the upcoming release.

 

Thanks,

Ashok R
zeiserpa
Participant
0 Kudos
Exactly!

Great news, this means it is currently planned for SP07?

Thanks

Patrick
Ashok_R
Product and Topic Expert
Product and Topic Expert
0 Kudos
Hi Patrick,

Currently it is planned for BI 4.2 SP07 release.

Thanks,

Ashok R
zeiserpa
Participant
0 Kudos
Hi ashok.rajashekar ,

many thanks for your answer.

I recognized that the Web Assistant can be greyed out in the Launchpad. Is there a possibilty to restrict the search function and greyed this also?

If yes, which user right is it?

Regards

Patrick
Ashok_R
Product and Topic Expert
Product and Topic Expert
0 Kudos
Hi Patrick,

As i mentioned in the above, currently there is no option to grey out or hide the search box.

Thanks,

Ashok R
mhf
Active Participant
0 Kudos

Hi Ashok,

is SAML via E-Mail adress also possible with 4.2 SP05 ? For example via downloading the required jars from a 4.2 SP06 installation or somewhere else?

Thanks & BR,

Michael

Ashok_R
Product and Topic Expert
Product and Topic Expert
0 Kudos
Hi Micheal,

 

SAML email is supported only from BI 4.2 Sp06 release as it has some code changes and will not work for BI 4.2 SP05.

 

Thanks,

Ashok R

 
atchutha_chekuri
Explorer
0 Kudos
Hi Ashok,

We are on BI4.2 SP05 P900 upgrading to BI4.2 SP07 P800.

Can you point us to differences in BOE.war for classic Launchpad, we have some customization code for single sign on which works fine with BI4.2 Sp05 P900, it's not working with BI4.2 SP07 P800.

When deployed with our changes and login to classic launchpad, I only see headers no content is displayed.

Ashok_R
Product and Topic Expert
Product and Topic Expert
0 Kudos
Hi Atchutha,

Thanks for posting the question.

Could you please let me know the customization you have applied for BILP?

Regards,

Ashok R