Skip to Content
author's profile photo Former Member
Former Member

Querying CMS database in SAP BOBJ 4.1 SP2

Hello All,

We are currently using SAP BOBJ 4.1 SP2 in our environment.

We are using the default database Sybase SQl anywhere for CMS databse.

Using Query Builder I tried the below query and it is properly giving me the output.

select SI_NAME,SI_DESCRIPTION,SI_CREATION_TIME,SI_KIND from CI_SYSTEMOBJECTS where SI_KIND='User';

Where as When I tried the same query by connecting to Sybase SQL Anywhere I am getting the error as

"No table found with the name 'CI_SYSTEMOBJECTS'"

What is the difference between the Query browser and CMS database?

Query browser also connects to CMS database and retrieve the data.

Please help me in this issue.

Regards

Prasad Ambati

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Oct 23, 2014 at 07:32 PM

    The BOEnterprise SDK exposes three logical tables named CI_INFOOBJECTS, CI_SYSTEMOBJECTS, and CI_APPOBJECTS. It is important to note that the BOEnterprise SDK tables are not the same physical database tables found in the CMS database. Instead, they are logical tables created in CMS memory that enable users to query from the property types. Some of the object types for each table are listed below.

    CI_INFOOBJECTS

    The info object table allows users to retrieve folder, report, and report instance information from the CMS InfoStore.

    CI_SYSTEMOBJECTS

    The system object table allows users to retrieve information regarding servers, users, groups, destinations, and events from the CMS InfoStore.

    CI_APPOBJECTS

    The application object table allows users to retrieve information regarding Business Views, Business View Connections, Universe Connections, Universes, List of Values, Command Objects, Repository Objects, and Business Objects Applications.

    Hope this helps,

    Jin-Chong

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 23, 2014 at 08:30 PM

    Moved to BI platform space

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 24, 2014 at 02:13 PM

    Hi Prasad,

    Also check out this very nice blog that lists different query techniques.

    http://scn.sap.com/community/bi-platform/blog/2012/10/11/businessobjects-query-builder-queries

    Jacqueline

    Add a comment
    10|10000 characters needed characters exceeded

    • To be clear on this point, the Query Builder allows you to read this content, and the SDK allows you to read and manipulate that content.

      You should not ever attempt to report off of the database itself directly. The majority of the content is stored in binary fields for general security reasons anyway, but also to avoid directly reporting against it and especially trying to make any changes to it.

      SDK all the way...

      Hope that helps

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.