Skip to Content

List of all objects for a webi report in BO XI 4.1

Hi Team,

Is there any sample code available which can fetch all objects for webi report and also if user select object name it should fetch all reports associated with that object?



Please let me know.


Regards,

NK

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 17, 2016 at 10:31 AM

    Hi Naveen,

    I believe there is no readymade sample code present on this through RESTful web services.

    Also we can fetch all objects of a webi report through RESTful Web services SDKs, however I don't think there is a way to fetch all reports associated with that/any object-name.

    However you can develop your own code by implementing the below RESTful call sequences in your program:

    Step 1 - Get the list of Webi documents (This request will list you out the webi document present in your repository)

    URL: http://<server-name>:6405/biprws/raylight/v1/documents

    Method: GET

    Headers: Content-Type: application/xml

    X-SAP-LogonToken: "<Your Logon token within double quotes>"

    The response of above request will list you the Webi documents along with their SI_ID, SI_CUID, SI_NAME, SI_FOLDERID & its state.

    Step 2 - Get the list of data providers of a specific Webi document (This request will list you out the data providers that a webi document is using)

    URL: http://<server-name>:6405/biprws/raylight/v1/documents/{SI_ID-of-a-Webi-document}/dataproviders

    Method: GET

    Headers: Content-Type: application/xml

    X-SAP-LogonToken: "<Your Logon token within double quotes>"

    The response of the above request will list out the number of dataproviders i.e. query bound to Webi document. The above request also shows the ID of all dataproviders, name of the dataprovider/query & its last updated time.

    Step 3 - Get the list of objects used in dataprovider (This request will list you out all the objects used for that particular query)

    URL: http://<server-name>:6405/biprws/raylight/v1/documents/{SI_ID-of-a-Webi-document}/dataproviders/{data-provider-ID}

    Method: GET

    Headers: Content-Type: application/xml

    X-SAP-LogonToken: "<Your Logon token within double quotes>"

    The response of above request will provide you data provider id, name, dataSourceId, data source type(i.e. unx, unv, bex, excel, or fhsql), data source prefix(used as prefix for data source object IDs of .unv universes only), last updated time(the date and time of the last update), rowCount(the number of rows) & each semantic object dictionary with their id, name, description, data source object ID, formula language Id, used as key for data filters. The dataType, qualification, and high precision of objects are present as attributes of expression.

    Step 2 & Step 3 are iterative as Step 1 will gives you the list of Webi document.

    Step 2 should run number of times, depends on the count of the Webi report. Step 3 should run number of times, depends on the count of data provider of a Webi document.

    Hope the above information helps you.

    Thanks,

    Shailendra

    Add a comment
    10|10000 characters needed characters exceeded

    • hi Shailendra,

      You're welcome 😊 The idea of reading the error stream in case of HTTP code different from 200 is that we (try to) return useful information in it in case something does not work as expected. Moreover, in case of something we didn't anticipate, the stack trace (in case you activated it through the CMC) will also be returned there.

      Best regards,

      eric

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.