Business Intelligence with SAP Business Objects 4.3

Database error occur. The error message is : (CS) "DBDriver failed to load : Installdir\win32_x86\dataAccess\connectionServer\dbd_oci.dll  (the module cannot be found)". (WIS 10901) Environment: Business Objects XI R 3.1 DB Oracle 11g When opening a Webi report on infoview, the above error is generated,while Webi rich client  works fine. Cause The problem can be explained because the WebI Rich Client uses your local connection settings while infoview uses those on the Business Objects server. So you need to check  that the server has same DB access of your local machine. Besides  you need to  keep in mind that the permissions depends  by the service account, so if your service runs under local account then you need to check the security policy on this account. Solution You need to check the following points: 1. If you have not an Oracle client on your client You need to install it 2. Set the ORACLE_HOME 3. Check whether TNS.ORA is set up properly an

Let's see how create a  simple Sales Dashboard  which has as main component the Accordion menu which allows to have a multiple level hierarchical filtering. This means that you can first select the top level hierarchy dimension in our case the 'Country' and then you can choose one of the ' Products' sold in the selected country: The columns chart shows the sales for that kind of bike in the months of the year. In the following image you will see how data changed when you select an other kind of product Below  you can see how create the Excel file in order to create this dashboard. In the yellow are will be drilled the months sale data after selecting the two hierarchical dimensions. Under this line there are different tables for each Country that can be selected which contains sales data per product for each months. Below is detailed how to set the Accordion Menu You can find the related files on SAP COMMUNITY NETWORK, in the

Max character file size limit exceeded. The document is too large to be processed by the server. Contact your BusinessObjects administrator. (WIS 30272) Cause: When you view a Web Intelligence document in HTML format, the Web  Intelligence server generates character based output, which is then interpreted by your web browser. This errors occurs, if the size of the  character output is greater than the maximum size specified by your administrator for the Web Intelligence server. Solution The administrator can change the parameters set for Maximum character output on the Administration Console.  Please note that however, increasing the maximum  binary output can affect performance. Log  on  CMC -> servers -> Web Intelligence Report Server -> Properties  Maximum Binary File Size:  Maximum Character File Size: The Binary file size shold be  for PDF; the character size is for webi reports.  You have to increase you current limits unt

Account Information Not Recognized: The CMS system database is not available. This error cannot be rectified by the end user. Report this error to your system administrator or database administrator. (FWM 02088)  Environment XI R3.1 Cause The CMS database is unavailable. Solution Check if all the servers including CMS are running and enabled in CCM on BOBJ server. If yes,  r estart the SIA, it always works! See also: BUSINESS OBJECTS ERRORS LIST

Universe data connection could not be found. Either the connection has been deleted or you do not have the rights to use it. The universe data connection is not available, either because it has been deleted or because you do not have the right to access it. Solution: The Business Objects Administrator must  give to a specific users group (user)   the right to access to the universe and its related connection. See also: BUSINESS OBJECTS ERRORS LIST

In order to learn how to create  a Transportation dashboard   you can  study this  dashboard example.  Here you can choose  between 'Company Total' page  and 'Top 5 What if analysis' pages. Let's see the first page   'Company Total' : On the right you can select six labels which corresponds to  different analysis: ABC  2006 Acme 2006 XYX  2006 Total  2006 Total  2005 Same week 2005. All the tabs acts have the same functions. Besides selecting one of the Top ten customer  you will see the drill of related data in the bottom bar charts for each analysis type, follows the image about selecting the 7th customer: The second page is about 'Top 5 What if analysis'  On the left panel, you can see the What if analysis that is you will see all the values and gauges changing on moving the indicator  on the upper graduated bar. Follows the Excel sheet images that provide  data to the dashboard: TOP 200 sheet (Company

 HTTP 404 errors in Business Objects XI R 3.1 The HTTP 404 error may happen for one of the following reasons: 1. The requested page was deleted in error. Check the deployment folder of the web application to make sure that the requested page exists. 2. The web application is not properly configured. Try to access other pages in this web application. If there are other pages in this web application that are not accessible, then there is a problem with the web application configuration. Consult the web application deployment instructions to check that the configuration files are valid, or redeploy the web application. 3. A system setting is incorrect. For example, the memory limit was reached or an ODBC DSN was not correctly configured. As a result, an exception was thrown and the expected page was not generated. Check the web server log or the web application log for error or exception records. 4. An environment variable is not properly set. This environment variable can