Business Intelligence with SAP Business Objects 4.3

Connection or SQL sentence error. (DA0005) Cause Connection Server can generate a connection or SQL sentence error after the date format has been changed in the relevant .sbo file. This can occur if the format set in the .sbo file does not agree with that set in the database. Action Verify that the Oracle NLS_DATE_FORMAT parameter is set to the date format that you have set in the data access .sbo file. Check your Oracle documentation for more information. See the "Data Access Guide" for information on parameters defined in the .sbo files, and how to modify them. Cause Your Oracle data access drivers have been moved, deleted, renamed, or damaged. Action Re-install the Oracle data access driver

The new SAP Lumira aims to  let you tap into your data- big and small - and discover answers. This application allows to: - Deliver faster time to insight in a repeatable, self-service way - Maximize business knowledge with a combination of big picture insights and granular details - Accelerate decision making with immediate, fact-based answers to complex business questions - Increase self-service data usage without adding to your IT department's workload - Visualize any amount of data in real time – with SAP HANAOne - Organize and navigate data the way you want to - quickly and visually without using a single line of code or additional modeling layer.  SAP Lumira's interactive visualizations let you analyze data quickly to discover unique insights that you can share throughout your organization. With the software's ability to connect to the SAP HANA platform, business users get access to real-time answers buried in massive amounts of data. For SAP Visual Inte

BIG NEW: In SAP BI 4.1 Supports SAP BusinessObjects Desktop Intelligence 3.1 SP6 FP 6.1  in viewing mode Web Intelligence is the way forward Scope   Consumption of DeskI content in BI 4.1 using Desktop Intelligence 3.1 client SAP BusinessObjects Enterprise 3.1 SP6 FP6.1 will provide the Desktop Intelligence client the capability to connect to a BI 4.1 CMS SAP BusinessObjects Enterprise 3.1 EoL timelines are still applicable on Desktop Intelligence Key benefits Important and critical Desktop Intelligence documents can  be stored in BI 4.1 Customers gain additional time to convert Desktop  Intelligence documents while on BI 4.1 Reduced TCO, as customers can retire SAP  BusinessObjects Enterprise 3.1 completely. Read also related post: SAP BO BI 4

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