SAP BusinessObjects (BO) BI 4 Platform has come with many improvements that have made the system more complex. Rep-Up-GraphWe, as BI 4 administrators, are required to know how this application works in order to apply the proper optimization improvements to the platform, when it is required. In this blog article, we will cover the most important concepts that need to be considered as a first step to increase the performance of the BI platform. It is very important for a good designer to understand the conceptual tiers in the BI Platform: Application Tier, Intelligence tier and Processing tier. We will refer to each one of them and we will nail down some optimization tips.
The Spanish installation of SAP BusinessObjects BI4 is said to frequently crash, and even when it does not, something is still wrong in the server side so SAP BusinessObjects installation administration console does not work as it should and certain formulas used in the front-end side malfunction. This article explains some tricks that can be applied when installing SAP BusinessObjects in Spanish so customers can successfully migrate to the new SAP BO BI4. Folders Security Configuration
When configuring the security for a folder in the SAP BusinessObjects administration console, an issue appears. This can be easily reproduced by installing the software in Spanish, proceeding to enter in CMC and start configuring security. The following error can be seen when entering in Folders Top Level Folder Security:
"A server error occurred during security batch commit: Request 0 of type 44 failed with server error : Plugin Manager error: Unable to locate the requested plugin CrystalEnterprise.ScopeBatch on the server. (FWB 00006) "
There is no other solution rather than to change the Regional Settings of the server from Spanish (Spain) to English (United Kingdom), then this issue is solved.
UserResponse Formula Use
An issue occurs in WebIntelligence when Preferred Viewing Locale is Spanish and Users refresh reports Prompts: A numeric prompt is interpreted as a text with a wrong scientific format when the =UserResponse() formula is used.
The issue can be reproduced taking one object from the official SAP “STS Southeast Demo” Universe, retrieving one object with a prompt and applying the UserResponse() formula as indicated below
In the example stated above the UserResponse() formula should be evaluated to “201010” instead of “2.0101e5”. This can cause serious issues as it is a change Vs. previous software versions because this could be included in many formulas and filters, and could cause a migration project with reports using this frequently used formula to be dramatically extended.
A workaround for this is, for the time being, to keep the Preferred Viewing Locale in English for every user who refreshes information.
So, summarizing, the pieces of advice proposed for a successful installation in Spanish language are:
- Keep your server with Regional Settings of the server in English (United Kingdom)
- Configure your BI LaunchPad users to keep the Preferred Viewing Locale in English
- Keep the BI LaunchPad users Product Locale property setting to Spanish (Spain)
As a result, users will visualise the whole front-end in Spanish language with no errors.
This solution has been tested in latest 4.0 SP4 which includes FeaturePack 3.
The benefit of these workarounds is to provide the market of Spanish language customers with the ability to start migrating to the new SAP BI4 platform with success, and enjoy the product in Spanish language with no bugs. Hope this helps. If you wish to leave your comment or opinion, please feel free to do so below!
The set up process for SAP BusinessObjects BI 4.0 when there is a firewall between the servers and the users it´s a bit different than the one from the previous SAP BusinessObjects releases. In this blog post I will walk you through this process.
In order to allow the users to work with the client tools we need to follow the steps below:
Open the ports 8080 on the firewall (or HTTP port you are using) and the range from 6400 to 6410 (you would normally only use the ports 8080,6400,6401,6402, 6403 and 6410, but it is recommended to open the full range, just in case). The ports need to be opened “bi-directionally”. In the advent that you are not using the default port (6410) for the Server Intelligence Agent (SIA) you would also need to open the port you are in fact using.
1- Login into the Central Management Console (CMC) as Administrator, then go to Servers - CMS - Properties. On Common Settings deselect the check-box Auto-Assign and on the text-box assign the port 6401. Save and close.
2- Go to Properties of the Input File Repository server. On Common Settings deselect the checkbox Auto-Assign and on the textbox assign the port 6402.
3- Go to the properties of the Output File Repository server. On Common Settings unselect the checkbox Auto-Assign and on the textbox assign the port 6403.
4- Finally, go to the properties of the Adaptive Processing server. On Common Settings unselect the checkbox Auto-Assign and on the textbox assign the port 6404.
5- The last step is to restart the SIA
You are done! After running this process the SAP BI 4.0 client tools should work for all the users in your network.
The risks of not hard coding the ports to certain servers as observed are: not being able to log in the BI platform from client or web access, not being able to manage content – objects such documents or universes and instances - and not being able to use the multi-Source engine for the new generation universes from the Information Design Tool.
If you have any doubts or would also like to share a tip on this topic please leave a comment below.