BusinessObjects Board

SQL - CMS - BOXIR2SP1

sdk development
#1

Hello,
I would like to know if it is possible for BO XIR2SP1 of:

  • To recover the name of a document
  • To remove a document By using orders SQL directly in the repository.

Exemple in BO 5.*


UPDATE OBJ_M_DOCUMENTS SET OBJ_M_DOCUMENTS.M_DOC_N_LAT=1 WHERE OBJ_M_DOCUMENTS.M_DOC_N_ID IN ....

Thank you

Guillaume :fr: (BOB member since 2007-02-24)

#2

Hi Guillaume,

It is not possible or recommended to directly query the BO XI repository.

BO has created a tool named the Query Builder (available in the admin launchpad), which is a web application available at this URL capable to query the BO XI repository:

- Access on JAVA: http://<SERVER>:<PORT>/businessobjects/enterprise115/adminlaunch/
- Access on .NET: http://<SERVER>:<PORT>/businessobjects/enterprise115/WebTools/

It is not possible to use other SQL statement that SELECT.

You can find some interesting information about the Query Builder in the following post:
Repository tables in XI

The only way to rename and/or delete a document is to build your own application (using BusinessObjects XI R2 SDK) or to use:

  • CMC (Central Management Console)
    or
  • InfoView

Regards,
:twisted: NoNoDiabolo.

nonodiabolo :fr: (BOB member since 2006-09-12)

#3

Thanks :wink:

Guillaume :fr: (BOB member since 2007-02-24)