Business Intelligence with SAP Business Objects 4.3

Geomap report on the latest SAP BI MOBILE APP 4.4.18 Environment BOE XI 3.1 SP 4 compared to the SAP BI Mobile app Vers 4.4.12 the last version 4.4.18 has a great improvement  because supports many functions witch were not before. You can Enable alerters (for geo-analysis) by adding the suffix “ca1” in the table (report block) Name.  For example, if  the block Name in Web Intelligence is map_lt3_lo4_poi2_od5; you need to update the name  to: map_lt3_lo4_poi2_od5_ca1. So in this version you can assign to a measure a specific colour in order to remark different measures  (as you can see from the following images) The Webi Report sholud have the following structure: assigning a different colour to each indicators will be displayed in Ipad as POI that change colour on selecting a different measure: You can also regroup all the measures related to the POI by adding  the suffix  “gp1” in the Name of the report part (

Working on BI Mobile Geomap for Ipad on BOE XI R3.1 SP 4 APP VERSION 4.1.2 Supportef for iOS 5.1. Creating simple reports on WebI with a specific Syntax name of block you create let you have pretty cool report to be used on Mobile device, in our case IPad but the result (except layout) is the same also on Android tablets. In the following image you can see a geomap report with two measures, you can switch between them   using the pop up that is open on cliccking on the firts measure exposed : Quantity and Amout on supplier pricelist Moreover  you can add open document to a Google map POI, so if you tap on one of the POI a link will pop up and selecting it you will open another SAP BI mobile report. Ahead I will show how do to this on WebI. Read related posts: Geomap on latest sap bi mobile Ipad App Opendoc syntax in Sap Bi mobile Sap BI mobile guide

Internal error  [ RCIRAS0216 ] (Error: INF ) Please contact your system administrator. Environment BOE XI 3.1 Deski report with Zabo  on Windows 2008 R2  Case: We had this exception after changing from Zabo a Deski option on saving the report, we checked the option 'Refresh on opening' the report. After exporting in the CMS the report on opening it we had the above exception Solution We imported the report on Deski,  choosig the BO system with  (J2EE Portal) ,  we save it  again by checking the option 'Refresh on opening'  and we re-exported it. After this the issue was resolved. See also: Errors list - Solutions

SAP Mobile BI Server and the new  BI 4.1 New features CMC & Launchpad Integration: Allows Configuring Secury Policies via CMC ( Before you needed a config file in the application server now settings are in CMC) You can enable mobile documents through Launchpad properties; right click on the document to get mobile properties dialog, including “time to live”. Allows Configuring Categories for Content Management via CMC Ability to Mobile Enable and Management Document Properties via Launchpad Support for Auditing user actions from Mobile devices Enhancement to Logging Framework and Perfomance Improvements SAP BO MOBILE Connectivity Options Read aslo: http://businessobjectsbi4.blogspot.it/2013/03/sap-bi-mobile-security-concepts.html http://businessobjectsbi4.blogspot.it/2013/03/dashboards-on-businessobjects-mobile-bi.html http://businessobjectsbi4.blogspot.it/2012/09/sap-bi-mobile-guida-pratica.html

Finally has arrived: BusinessObjects Mobile BI 4.4 wich allows to access to Dashboards on Mobile device and so on IPad and Android Tablet and phones. Dashboard for SAP BI Mobile supported features: Connectivity: through Query Panel on Universes on Query Bex (SAP BW) on Hana Universes Components: Labels Images component Combo box Label based Menu Radio button Scorecard List View Icons Slider Progress Bar Toggle button Push button Charts: Column Chart Bar Chart Pie Chart Line Chart Combination Chart Stacked Bar Chart Stacked Column Chart Gauge Containers: Tab Set Canvass Container Component Groups Please Note that at the moment Prompt component is not available. You will find not compatible components and features on the Compatibility Panel. Keep following the blog for further details and update! Read also Sap Dashboards for ipad Sap BO Dashboards 4 new features

SAP BI MOBILE SECURITY DMZ and Firewall Support in the Mobile System Infrastructure A DMZ, or “De militarized Zone”, is a physical or logical subnetwork that contains and exposes an organization's external services to a larger untrusted network, usually the Internet. The purpose of a DMZ is to add an additional layer of security to an organization's local area network (LAN).  The SAP BusinessObjects Mobile server supports deployments in the DMZ environment.   The SAP BusinessObjects Mobile client on the extranet interacts with the SAP BusinessObjects BI platform server on the intranet using the DMZ environment. To enable this deployment, perform the following steps: 1. Configure the -requestPort and -port parameters for the following servers: • CMS (for authentication, querying InfoStore, and browsing the repository) • Web intelligence report server • Adaptive processing server 2. Open the listening ports (-requestPort parameter) for the se

Err WIO 00002 - Cannot open the hyperlink Environment BOE XI R3.1 SP 4 Cause The URL in the hyperlink is incorrectly constructed. The hyperlink references a document in a “CMC”. Documents in a “CMC” are not always accessible from Web Intelligence Rich Client for two reasons: The hyperlink does not specify the name of the server hosting the document because the Use complete URL path to build document hyperlink setting is not selected. Incomplete URLs are invalid when used outside InfoView. The hyperlink builds the complete URL, but the server specified in the URL is not accessible from the computer running Web Intelligence Rich Client. Action We corrected the hyperlink syntax as follow http://BOserver:8080/ OpenDocument/opendoc/openDocument.jsp?iDocID=AXMjJh.aOSZGpYx29mOaSmU&sIDType=CUID&sRefresh=Y&lsSNazione=FRANCIA

 Set connection for SAP BI MOBILE in IPAD in order to access to mobile reports. Envirnoment BO XI R3.1 SP 4 In order to connect SAP BI MOBILE on BO server you need to go on Connection  and set: Connection Name Server Url: (BO server IP  insert also the port number) CMS Name Authentication: Enterprise  Read also: Sap Bi mobile security concepts Sap Bi mobile reports

WebI Query Panel -JRE error with Firefox 3.6.28 on Windows 7 on opening WebI Query Panel Environment  BO XI R3.1 SP 4 Client:  Windows 7 In order to resolve this issue:  go in the Java Control Panel and set the options as in the following images Enable Java system

WIS 30286 You do not have access to one or more data providers; only the ones to which you have access will be refreshed. Do you want to continue? Environment XI R 3.1 SP 4 Cause: The problem is due to the missing  access rights to the universe for a specific user  Solution: We solved this issue by giving to the user  the right to access to related Universes !

 WIS 30951 -The document can't be retrieved from the File Repository Server. Contact your System administrator Environment BO XI R3.1 SP 4 Solution: 1. You can try to  restart Tomcat  and BO Servers and this operation  could resolved the  error. 2. The problem was due to the low available space on the disk where FRS is. So after freeing the disk space this problem was solved.

How to enable/disable automerge demension on WebI report Envirnonment BO XI 3.1 SP 4 In edit mode, right click in the report and go to document properties. Check if Auto merge dimension option is selected or not. Also check that if you have right to merge dimensions or not (See the following image). Moreover you should checked on CMC that  the related security in Access Levels in the CMC  option is enabled. I want to know if there are special requirements for the dimensions to be able to be auto-merged, next to having the same name and being of the same type. Keep in mind that: Webi Intelligence can merge dimensions automatically in the following cases: • The dimensions have the same name • The dimensions have the same data type • The dimensions are in the same universe 

WIS 10083 - The qualification of the variable  '......' cannot be changed. Error Messages Explained The qualification of the variable '%1%' cannot be changed. (WIS 10083) Cause You cannot change the qualification of the variable. (For example, you cannot change a measure to a dimension if its definition includes an aggregate.) Action Create a new variable with the appropriate qualification. Envirnonment: BO XI 3.1 SP 4 WebI Our customer variable with the above error : =[Rank_tab].[Anno]+"-"+[Rank_tab].[Region]+"-"+ConteggioCumulato([Nazione Cliente]) Is composed by text type and the last part wich is an numeric type. We solved the problem creating a second variable for the measure: ConteggioCumulato([Nazione Cliente]) and then we concataneted the first variable with the above one. See also: Business Objects errors list

Error: Microsoft Office XP and later applicatations: Excel, Word, Outlook or PowerPoint must be pre-installed. Environment  BO XI 3.1 SP 4 Xcelsius 2008 SP 4 Live Office XI 3.1 SP 4 If you need to install Live Office on a pc with Office 2010 already installed you will get the following warning: In can bypass this error with a  a workaround wich aims to avoid that MS installer checks if Office is installed. In order to do so you need an MSI editor, we suggest http://www.instedit.com/ So follow these steps: Create a copy of   Lifeoffice.msi file located in the Package folder. Open with InstEd the  Lifeoffice . msi file and select the “Tables” tab and click on LaunchCondition; Then delete the row which refers to Office ( “EXCELl10 OR OUTLOOK10″) and save the file. Then run this modified  Lifeoffice.msi,  previous error will not appear any more and you will accomplish your installation! Please note that this Workaround can be used with Xcelsius.msi

'WIH 00013 - Invalid Session'  error returning when our user ran  Deski reports through infoview. Environment BOXI R 3.1 Windows Server 2008 R2 Tomcat Webapplication Server Solution We changed timeout-settings for Infoview increased to 120 minutes. However as we left an web intelligence document idle for more than 20 minutes the same error came again. We increased the idle connection timeout and idle document timeout settings for the WebIntelligenceProcessingServer using the CMC  but it was not sufficientto be neccessary) As Webi reports are not handled by the InfoView application   the timeout settings from InfoView are not helpful. We had to change the timeout settings for the AnalyticalReporting Application  BOInstallDir\Tomcat55\webapps\AnalyticalReporting\WEB-INF\web.xml See similar post: ERROR WIS 30280 BUSINESS OBJECTS ERRORS LIST

ERROR WIS 30280 We had a problem on opening all Webi reports. We found that the error message appears because the Web Intelligence server stresses the memory resources when processing many reports containing a large amount of data. Solution To resolve the error message, it is necessary to increase the memory heap size value.  Follow these steps:  Open  the regedit ( Registry Editor) Go to the HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Session Manager. Click Subsystems > right-click Windows key > click Modify. Edit the SharedSection value from 1024,3072,512 to 1024,3072,1024. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.5\default\WebIntelligence\Server\Admin\SwapTimeOut. Update  this value to 1500 seconds. Otherwise you could set this to a value higher than the Web Intelligence Report Server connection time out value found in the Central Management Console. This value is expressed in minutes.( default is 20). Restart the Web Inte

Error WIJ 20006 - One or more data sources are unavailable for queries  Environment: BOXI R3.1 SP4  with WebIntelligence The universe connection is working fine. This error came while a user was editing a Webi query. Solution: We resolve the problem by assigning the user to the group with access rights to the universe on which the report pointed. See also related posts: Error DA0005 CONNECTION or SQL SENTENCE ERROR - ORA-12154 BUSINESS OBJECTS ERRORS LIST

Environment: Business Objects XI R 3.1 - Desktop Intelligence/ Rich Client We had this error CONNECTION or SQL SENTENCE ERROR (DA0005) ORA-12154: TNS:could not resolve service name :-12154 just  for one a client in another site of our customer. We checked this  problem by typing  in CMD tnsping Oracle SID  for example: tnsping oracledatabase. The problem was that int the tnsname on the client under the path : C:\app\username\product\11.2.0\client_1\network\admin had not the same Oracle SID. Another  solution  could also be that the tnsping does not respond so the listener could be down. Similar case: On another Desktop Intelligence client with the same issue (error code) the problem was due to a double Oracle installation and a double Business Obects Intallation. Solution: In this case we unified the two different TNSNAMES in only one ! For other error see also: BUSINESS OBJECTS ERRORS LIST

Let see another case of the error: [repo_proxy 13] SessionFacade:openSessionLogon with user info has failed(Transport error: Communication failure.(FWM 00001) (hr=#0x80042a01) related to the error : Cannot access the repository (USR0013) Using Rich Client  (or Desktop Intelligence)  in a Business Objects XI R3.1 with Enterprise authentication on the System NOT USING J2EE system. As I wrote before  SYSTEM:6400(J2EE) means you are using 3 tier Deski which happens through web works fine as there is no firewall in between. while using SYSTEM:6400 we are in case of 2 tier login and your firewall is blocking the connection. In order to solve the problem you need to open some ports in the firewall for detail please read FWM 00001 - openSessionLogon with user info has failed If this operation does not solve the problem you can edit the REGEDIT - Registry Editor  (after making a copy of it in order to recover it in case of problem) then go to: HKEY_LOCAL_MACHINE KE

Before importing an universe in Translation Manager    the Best practise I feel to suggest is to make a local back up of the universe using BO Designer  you need to translate!! In this case  if after exporting the translated universe on CMS you will find the Universe is in some way corrupted you can recover it quicky form  the Designer! Read also related posts: Business Objects Translation Manager Translation Manager Exporting documents How to use Translation Manager Translation Manager Substitution mechanism

[repo_proxy 13] Session Facade::openSessionLogon with user info has failed(Transport error: Communication failure. (FWM 00001) (hr=#0x80042a01) Environment: Business Objects XI R 3.1 Enterprise SP 4 Desktop Intelligence client from extranet site cannot access to the BO Server. We used the right credentials, we checked our firewalls. Our firewall is open for the ports 6400 and 8080 (as default). The log shows that the network packages are sent between the client and server. The request is reaching the CMS as 6400 (BO server port) is enable but the Clients are not getting the response back as the request port is not enabled on the Firewall. On CMS there are two ports: one is Name Server port the other is the Request Port , by default the name server port is assigned the port 6400 and the request will reach the CMS when the name server is enabled on the firewall. The problem is that Web/client application cannot communicate as the Request port is unaware and the f

Environment BO XI R 3.1 SP 4 On logging on Desktop Intelligence,  the following error occurs:  SessionFacade::openSessionLogon with user info has failed(Transport error: Communication failure.(FWM 00001) Cause The client could not talk to the Server . This is the main  reason.  1)SYSTEM:6400(J2EE) means you are using 3 tier Desktop Intelligence which happens through web works fine as there is no firewall in between.  2)SYSTEM:6400 is 2 tier login and your firewall is blocking the connection.  The first one is a key that gets created when you modify or create a new Desktop Intelligence document from Infoview, that is 3-tier. The second one is you entering manually the information for 2-tier. Others Possible causes of the problem are: The server may be down. There may have been a network communication problem. The request my have timed out. Could be also a database connectivity issue between the CMS server and the Repository database. In order to

How to add a link in a dashboard  in order to open a document in SAP BI 4 platform First of all I wish you all HAPPY NEW YEAR! Let see how to insert a link to a document  that has been already published on SAP Business Objects 4 platform. Go to Web Connectivity menu in SAP Dashboards  as shown in the following image Select the  URL Button and drag an drop it  in the chosen position on the canvass Then select button Property tab  assign a name to button label  and then insert the appropriate URL in the following format http://BI4Servername:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=..... In this way, after publishing the dashboard on BILaunchpad  when you will click on the Open Workspace url Button  the related document will be opened: Please read related post: SAP BO 4.0 Open Document