Posts

Showing posts from 2013

Error UNV0023 - Parse Failed: Invalid Definition (UNV0023)

Parse Failed: Invalid Definition (UNV0023) Environment BI 4 SP 8 We are working with Universe Design Tool  on universes  that require the same tables so after inserting the tables in one universe and creating classes/objects/meta data, we copied the same classes and objects into other universes as the tables are  the same. But when we  parse the objects in the table after copying we got  following error: Parse Failed:Invalid definition (UNV0023).  The only way to solve the problem was to go into each object and copy, delete and then past the table object name. So the advise  that in similar cases is:  first  you have  to add the tables  and then you can add relative objects and  not viceversa! 2nd case We got the error  in another case For an object with the following select: CASE WHEN @Select(PromptList\....) IN @Prompt('Code:','N','PromptList\ CatCode' ,multi,constrained) THEN @Select(PromptLis\generic) ELSE (SELECT LTRIM(MA

BI 4 Error - Index is not ready. Please try again later (PSS 01004)

Index is not ready. Please try again later (PSS 01004) Environment BI 4.0 SP 8 When we tried to find a document name in the search field the error above has been raised. Resolution Go to CMC->Application-> Right Click 'Platform Search Application'->Properties Go down in the page and select the option "Rebuild Index" , save and close. Let the index rebuild  and Restart the SIA Check also the SAP NOTE http://service.sap.com/sap/support/notes/1634413 See also BI 4.0 errors list

BI 4 Error - QTJ 00519 Refecence @select could not be resolved

After migrating an Universe from XI R3.1 SP 4 to BI 4 SP 8 and converting it in UNX format for a filter object the following error was erased  Riferimenti non risolti:  : @Select(OGGETTI SPECIALI\Cod Anno) it missed the root folder of the object Riferimenti non risolti:  :  @Select( ORDERS \OGGETTI SPECIALI\Cod Anno) so the solution was to replace the first string with the second! See also Sap BI 4.0 errors list

Information Design Tool - How to create a Native filter

Image
How to create a object filter in Information Design Tool Go in th Business Layer an click on insert object button selecting filter object Assign it a name flag the check 'Native' filter select it as Active object and select the where condition in SQL Assistant (check the prompt syntax on the bottom of image behind) Properties See also Bublish unx universe from IDT

Error WIS 10901 - A database error occured. The database error text is: (CS) "DBDriver failed to load : C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32x_x86\dataAccess\connectionServer\dbd_oci.dll (The specified module could not be found)

WebI Error WIS 10901 A database error occured. The database error text is: (CS) "DBDriver failed to load : C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32x_x86\dataAccess\connectionServer\dbd_oci.dll (The specified module could not be found) Environment BO XI 3.1 SP 4 We get this error when  to create a  Rich Client  report from a user's machine, against a universe with a connection to an oracle database . Solution This usually due to  incorrect ODBC configuration so in order to solve this issue try the following steps: 1.      Stop all the services from BO Central configuration Manager. 2.      Open odbc.sbo file located at "Program Files\Business Objects\BusinessObjects Enterprise    11.5\win32_x86\dataAccess\connectionServer\odbc" 3.     Go to parameter setting for "Generic ODBC datasource ". 4.     Change the value of "Transactional Available" parameter to No. 5.     Add this new parameter settin

Error ERR_WIS_30285 -The Web Intelligent server is running out of memory, your document has been closed. If the problem persists, contact your BusinessObjects administrator. (Error ERR_WIS_30285) while refreshing a large Webi report.

Error ERR_WIS_30285 -The Web Intelligent server is running out of memory, your document has been closed. If the problem persists, contact your BusinessObjects administrator. (Error ERR_WIS_30285)  while refreshing a large Webi report. Envirnonement BO XI R3.1 SP 4 This error was erased while scheduling or refreshing  a large Webi report. The cause is connections  timed out. Resolution File Repository Servers:- Input Server: Maximum Idle Time : 60 Minutes (CMC-->servers-->Input File Repository Server)                                                 Output Server: Maximum Idle Time : 60 Minutes (CMC-->servers-->Output File Repository Server) Universe - Timeout parameter limit in the Universe - set this in Designer Open the designer > import the universe. Click File > Parameters, select the controls tab, increase the Limit execution time to 60 minutes. WebIntelligenceProcessingServer Connection Timeout - This is set in the CMC > Servers > WebInte

BusinessObjects Environment Cleanup activity using Query builder

BusinessObjects Environment assessment using Query builder This includes identifying unused BI content (Users, Universes, reports,etc.). We are going to see more in detail about identification of unused objects using Query Builder in this document.   Let us see how to identify unused objects in each category listed below     1. User Community          a. Users not logged in for the past 6 months             SELECT TOP 1000 SI_NAME, SI_LASTLOGONTIME FROM CI_SYSTEMOBJECTS            WHERE SI_NAME NOT IN ('ADMINISTRATOR','GUEST') AND SI_KIND='USER'           AND SI_LASTLOGONTIME < '2013.06.30' ORDER BY SI_NAME          b. Users who never logged in to system              SELECT TOP 1000 SI_NAME, SI_LASTLOGONTIME FROM CI_SYSTEMOBJECTS            WHERE SI_NAME NOT IN ('ADMINISTRATOR','GUEST') AND SI_KIND='USER'             AND SI_LASTLOGONTIME IS NULL ORDER BY SI_NAME          c. Users not in any gr

SAP Business Objects Query Builder

Business Objects Query Builder Among Business Objects tools there is an application named Query Builder which can be used to query the Business Objects Meta Data repository in order to collect more information and details about your  Business Objects reporting system. Its url is: http://BOserver:port/AdminTools/ How to create a query Queries are created in a language SQL like. Unlike Sql language there are not a lot of functions supported (like nesting SQL statements, the GROUP BY clause or the DISTINCT function). Below the possible functions in Query Builder within the different clauses of a query are described: (SELECT, FROM, WHERE, ORDER BY). Some examples behind: A list of the Id and Name of all universes SELECT SI _ID, SI _NAME FROM CI _APPOBJECTS WHERE SI _KIND = 'UNIVERSE' Total num ber of Web Intelligence Reports SELECT COUNT(SI _ID) FROM CI _I NFOOBJECTS WHERE SI _KIND = 'WEBI ' A list of 10 0  Crystal Reports with all properties SELE

BI 4 - IDT error: ambiguous object path - Checking integrity from Information Design Tool shows an error parsing expression: ambiguous object path

On converting a unv universe in unx format in Indormation Design Tool with a generic error after tracing IDT we found the following error and solution: Checking integrity from Information Design Tool shows an error parsing expression: ambiguous object path Environment:  BI.4 - Information Design Tool - SP 5 on Windows Server 2008 R2 Cases: When a dimension and a filter has the same name in Information Design Tool, the Check Integrity returns an Ambiguous Object Path error. Or After converting the universe from UNV to UNX the check integrity gives Ambiguous Object path error. The issue is resolved on Support Package 5 with Patch 1 or Support Package 6. See Also: http://businessobjectsbi4.blogspot.it/2013/09/sap-bi-40-errors-list.html

How to publish an Unx from Information Design Tool (SAP BI 4.0)

Image
How to publish an Unx from Information Design Tool (SAP BI 4.0) In order to publish an UNX Universe  go to  Local Project  Select the .blx you want to publish  (right click)   do the check integrity  first  then select Publish in the repository as you can see in the following image: Read also Universe on Sap Hana

Err_WIS_30270 While exporting in Excel a report Webi - XI R3.1 SP 4

Image
Err_WIS_30270 While exporting in Excel a report Webi Environment XI R3.1 SP 4 This problem happened to an user which received a report WebI in the In box  when she tried to export it in xls format. Resolution We edited the advanced rights on favorite folder of this user as the rights to export in csv, pdf and xls were not specified and then in her case not allowed! So we granted them under WebI Report Content  as you can see in the following figure!

BI 4 Solution to: cannot see connections in Report Conversion Tool

Image
Cannot see connections in Report Conversion Tool Environment SAP BI 4 SP 5 In order to solve this problem I inserted the BO server name and its IP  in Hosts file under: C:\Windows\System32\drivers\etc Read also: BI 4 - How to download webi rich client Webi XI 4 - Changing query data source Sap BI 4 Webi-connecting to Bex query SAP BI 4.1 Supports SAP BusinessObjects Desktop Intelligence 3.1 SP6 FP 6.1 in viewing mode Disable automerge dimension on WebI X 4.0

How to download Webi Rich client in SAP BI 4.0

Image
How to download Webi Rich client in SAP BI 4.0  The Web Intelligence Rich Client can be installed from the BI Launchpad: In  BI Launchpad s elect Preferences  Select Web Intelligence.  Click on the (installation required) hyperlink next to Desktop or Desktop (Windows only).

SAP BI 4.0 Errors List

SAP BI 4.0 Errors List scheduling error - source file error. [Invalid argument]: [CrystalEnterprise.DiskUnmanaged] ERR_WIS_30271 - Maximum binary output size limit reached QTJ 00511 - Circular references : check your @select and @where calls Parse Failed: Invalid Definition (UNV0023) Index is not ready. Please try again later (PSS 01004). Error qtj 00519 reference @select SAP BI 4 Converting Unv in UNX- IDT error ambiguous object path FWM 01003 Server Not found or it may be down Business Objects XI R 3.1 Errors

SAP BI 4 - Error: Server not found or server may be down (FWM 01003) null

Error: Server not found or server may be down (FWM 01003) null Environment SAP BI 4.0 SP 5 First of all you can check if  your CMS is up an running from CMC. If the SIA is running, but not the CMS this usually means there is a problem with the connection to the CMS database. Reconfigure DSN for a normal connection, with username/password and retest. Read also related  SAP Notes:  1387464 - Error while logging to Central Management Console or Infoview "Error: Server domain:6410 not found or server may be down (FWM 01003) null" https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3133383734363426  1338496 - Error: Server xxx:6400 not found or server may be down (FWM 01003) null while login to Infoview or Central Management Console https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F

CMC - Not able to Delete User BI 4.0 SP5

Image
CMC  BI 4.0 - Not able to Delete User  Environment  BI 4.0 SP5 After migrating from XI R3.1 SP 4 to BI 4.0 SP5  logging on CMC as Administrator and  right clickeing on user there is no Delete on the menu .  The remove user or group from user group icon is greyed out. The Workaround for this issue (same for deleting groups) You need to go on the property of the user (as you can see from the image below there are no rights related to this user)  so in order to delete it you must give 'full control' to the Administrator  After this operation it was possible to delete it. You can do this operation to 'user groups' in order to obtain a widespread result.

WIS 10901 - Webi Rich Client error - DB Driver failed to load

WIS 10901 - Webi Rich Client error - DB Driver failed to load Environment BO XI R 3.1 SP4 This error occurred opening a LOV on refreshing a Rich client report. Solution If you're logging into rich client in 2-tier mode (system name with computer icon) then the TNSNAMES.ora will be picked from local machine( in this case you must have an Oracle client installation and an up to date Tnsnames) Instead when using 3-tier (system name with world icon) then the TNSNAMES.ora will be picked from the BOBJ server  So the server may not be configured properly if the latter option is used  This rule has to be applied on a DeskI application setup  Error wis-10901 database error occured Business Objects errors

FWB 00027- CMS system database is overloaded, please try again. If the problem persists, please contact the system administrator

 CMS system database is overloaded, please try again. If the problem persists, please contact the system administrator  Environment BO XI R 3.1 SP4 Please follow these steps 1. Check the database connectivity  2. Check the Logfile(s)   If everything is right, restart the SIA agent. This issue usually indicates problem with CMS database and this might also occur if CMS table entry is corrupted.

Connection or SQL sentence error. (DA0005) - DESKI

Image
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 (a.k.a. SAP Visual Intelligence)

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

SAP BI 4.1 Supports SAP BusinessObjects Desktop Intelligence 3.1 SP6 FP 6.1 in viewing mode

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

SAPPHIRE NOW from Orlando

FWM 01002 - Unable to reconnect to the CMS. The session has been logged off or has expired.

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

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