Business Intelligence with SAP Business Objects 4.3

In order to refresh the structure of the universe in the Information design Tool Open the Data Foundation  Click on detect button and select Refresh Structure as you can see in the following image See also Publishing Universe with IDT

Circular references : check your @select and @where calls (QTJ 00511) Environment BI 4 SP 8 Cause An @Select or @Where call in the script refers to itself. This is not allowed. Action Check the declaration of the @Select and @Where calls and correct or modify the script. See also: Sap BI 4.0 errors list

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

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

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

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

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