Business Intelligence with SAP Business Objects 4.3

SAPPHIRE NOW from Orlando

An error has occurred: Unable to reconnect to the CMS.  The session has been logged off or has expired. (FWM 01002) Environment BO XI R 3.1 SP 4 In order to solve this issue we found a  SAP released note 1422296  1422296 - Error:' Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' with BusinessObjects XI 3.1. Symptom Not able to schedule WebIntelligence reports. Reports fail with error:'Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' Environment BusinessObjects XI 3.1. Reproducing the Issue Schedule a WebIntelligence report to run now. Reports fails with error:u2018Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' Resolution 1. From Central Configuration Manager, disable all the services and re-enable them. 2. Log into Central Management Console and go to the server area. 3. Go to the properties of Central Man

Error RFC 00101 -  No server was available to process the request. Please try again later. ( Error RFC 00101 ) (Error: INF ) Environment BO XI R 3.1 SP4 This error often happens during the peak business hours while scheduling WebI reports. In our case we solved the problem  increasing the Maximum connection perameter in WebIntelligenceProcessingServer on CMS. The  default value is 50 connections per one WebI Processing Server.  The best way is to create the new webi processing server from the CMS. In case of DeskI reports: Following solution might be helpful in resolving the issue. To resolve the error message Log on to the Central Management Console as administrator. Click Servers > Desktop Intelligence Report Server. Increase the following time-out parameters to at least twice the current value: Minutes before Idle connection is closed Minutes before an idle report job is closed Moreover if this solution does not work for you, you can checkthe followi

WebI - Connecting to a Bex Query with hierarchical data In WebI as you already know is possible to connect to SAP Bex as data source and taking advantage of hierarchy set up  with related dimensions in order to explore hierarchical data, this is also possible form WebI Rich Client (version 14.0.0; build 760). On the left side of the following  page you will select the Bex query with hierarchy while on the right you will select the quert with multiple hiearchies Then select the hierarchy  (1st pic)  and a measure (2nd pic) In the following picture you can see the query result, by clicking on the plus sign you can expand the customer type hierarchy By editing the query and clicking on the member selector list You can explode and then  select all the hierarchy levels by clicking on the specific button As you will see with this operation you will make visible all the hierarchy levels in the report tab: Read also rel

SAP BusinessObjects Mobile BI Suite  new layout features (4.2.x) SAP BusinessObjects Mobile Supports Query Filters Prompts defined on Webi Document to  enable end user to Filter the Document Data while refreshing the Document and also OpenDoc Linking  Prompts Support - All Data Types - All Operands - Single and Multiple Prompts - Dependent Prompts - Hierarchical Prompts - Prompt Properties – Prompt with List of Values – Select Value only from list – Optional Prompts – Set Default Values OpenDoc Support - sRefresh - sReport It's also possible using Cascading Prompt (Dependent prompts) or Hierarchicalon SAP BusinessObjects Mobile  See following image as example Input Control and Element Linking SAP BusinessObjects Mobile Supports Input Controls defined on Webi Document to enable end user to Filter the Report Data and also Element Linking Input Control Support - All Data Types (except Hierarchies) - All Operands - Single and Multiple In

SAP BusinessObjects Mobile BI Suite  new layout features (4.2.x) n SAP BusinessObjects Mobile BI Suite you can easly convert a WebI report into Mobile Report as you can see from the following images: In the latest SAP BI Mobile version are now supported different table types, such as: V-Table, H-Table and X-Table More  powerful Visualization – and more table Properties and Formatting SAP BusinessObjects Mobile Supports Table Properties and Formatting Options Like Text color, Background color and Embedded Images (with / without conditional alerts), Multiple Headers, Merged Cells and Headers and Breaks Moreover is possible to merge Headers and cells and apply breaks You can insert more kind of charts ( Bar, Stacked Bar, Grouped Bar, Line, Pie and Combined Bar and Line Chart with Single axis ) in one page,  and you can also customize colors. Now is also available accessing sections and section header and  formatting. Read also the

#DATATYPE ERROR Environment:  WebI  BO XI R3.1 SP 4  You got thi error when you are using a wrong data type .  For example if  your data is numerical but it is throwing char or date then Business Objects will  expose this error. Often it  happens, when you mix string and number or string and date/time data types.   If these data types are mixed, the function returns a string. As Date/time and number data types cannot be mixed  the results is a #DATATYPE error. Solution: In Webi  you must create a variable in which you have to convert and cast the data types in order to make them all homogeneous as datatype. Check also: Business Objects errors list