Posts

Showing posts from April, 2013

Error RFC 00101 - No server was available to process the request

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

SAP BI 4 WebI - Connecting to a Bex Query with hierarchical data

Image
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

Dependent Prompts and Input Control on SAP BusinessObjects Mobile

Image
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

New Layout features in the SAP BusinessObjects Mobile BI Suite

Image
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 in WebI

#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

SAP BO Design Studio Integrated with SAP BusinessObjects BI Platform

Image
Integrating  SAP BO Design Studio   with SAP BusinessObjects BI Platform Enable application management on BI Platform allows: - Enable multi user-access to applications - Storage of applications and images - Embedded runtime on BI Platform - Central management of system connections The following image show how to Open and save applications on BI Platform How to manage  System connections on BI Platform SAP BO Design Studio satisfies different needs for each company role as follows Executive - Consume and interact with information using simplified BI templates - Analyze information on mobile devices Middle Management - Leverage BI applications for planning and forecasting scenarios - User product interoperability to share results with other BI clients Business Analyst - Leverage BI applications for planning and forecasting scenarios  - Create BI applications and design guided navigations Consumer - Use pre-built templates with guided step

SAP BusinessObjects Design Studio (a.k.a. ZEN)

Image
SAP  BusinessObjects  Design Studio  SAP BusinessObjects Design Studio   represents  BEx Web & BEx Web Application Designer successor. Design Stuido allows for intuitive design of centrally governable analytic content ranging from guided analytics to sophisticated OLAP applications and aggregated dashboards.  The product features iPad support, an  HTML5 User Interface, differents themes available for application and a WYSIWYG Eclipse-based designer, full & native support of BW BEx queries, direct connectivity to HANA as well as an advanced scripting engine. Available features in detail: - Intuitive WYSIWYG design environment for designers - Large set of design components (buttons, tabs, dropdown menus etc.) - Extend via scripting language (subset of JavaScript) - Enterprise Ready Life Cycle Management - Central Supportability - Theming & Customizing iPad Support built-in Apps are ready for immediate usage on standard web browsers and mobile

Error ERR_WIS_30270

 An internal error occured while calling 'getMap' API. (Error : ERR_WIS_30270). Environment BOE XI R3.1 SP 4 This is a generic error message,  in our case we had this error while we were applying  some changes to an old WebIntelligence report. By searching through SAP notes there are about 100's of notes on this error. The problems can range from bugs (as also stated in this thread) to configuration issues with universe to report design.  IF you are unable to resolve with the latest patch then open a case with the SAP BO. Solution In our case we saved the report we re-open it and we made some changes in the query pane and after this it was refreshed correctly. Other case: Considering four web intelligence reports, among these, for one report when i click on refresh list of values of a prompt i am getting the error  "An internal error occored while calling process DPCommands API (Error: ERR_WIS_30270) (Error.INF).  In order to solve thi