How to find a general information about WEBI by API or Query Builder?

[former_member644368]

Hello!

I want to find a general information and statistics about WEBI by API or Query Builder?

Where is this information?

sap.png

[ayman_salem · Accepted solution]

use RESTful.

To get statistical information about the report:

List of active reports

http://<;server>:6405/biprws/bionbi/content/list/1

(The /1 at the end returns the active reports. If you omitted it, all inactive reports will be displayed)

output:

<entry>
<content type="application/xml">
<attrs xmlns="http://www.sap.com/rws/bip">
<attr name="cuid" type="string">xxxxxxxxxGxx_53o</attr>
<attr name="status_type" type="string">Active</attr>
<attr name="last_run" type="string">Nov 16, 2020 12:38 PM</attr>
<attr name="title" type="string">testOptionalPrompt</attr>
<attr name="type" type="string">Web Intelligence</attr>
<attr name="view_count" type="int32">4</attr>
</attrs>
</content>
</entry>

....

To get information about the report:

http://<;server>:6405/biprws/v1/documents/<document id>

output:

<content type="application/xml">
<attrs xmlns="http://www.sap.com/rws/bip">
<attr name="cuid" type="string">xxxxxxxxxxxLBGxx_53o</attr>
<attr name="keywords" type="string"></attr>
<attr name="parentcuid" type="string">CxxxxxxXfU2Ust.ltEwspg</attr>
<attr name="created" type="string">Nov 3, 2020 8:34 PM</attr>
<attr name="name" type="string">testOptionalPrompt</attr>
<attr name="description" type="string"></attr>
<attr name="id" type="string">6377</attr>
<attr name="type" type="string">Webi</attr>
<attr name="ownerid" type="int32">12</attr>
<attr name="updated" type="string">Nov 3, 2020 8:34 PM</attr>
<attr name="parentid" type="string">7857</attr>
</attrs>
</content>

....

For more information, see the "Business Intelligence Platform RESTful Web Service Developer Guide".

.....

To get the properties of the report:

http://<server>:6405/biprws/raylight/v1/documents/<document id>/properties

output:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<properties>
<property key="SI_CUID">Axxxxxx7.R95Bv_Bs</property>
......
<property key="lastsavedby">Administrator</property>
....
.....
<property key="lastrefreshdate">March 7, 2017 5:31:39 PM GMT+01:00</property>
....
....
<property key="modificationdate">April 13, 2018 12:22:51 PM GMT+02:00</property>
<property key="name">ZZ_Rio Games 2016</property>
<property key="createdby">Administrator</property>
....
....
<property key="creationdate">March 9, 2017 6:24:45 PM GMT+01:00</property>
....
....
</properties>

for more info, see "SAP BusinessObjects RESTful Web Service SDK User Guide for Web Intelligence and the BI Semantic Layer"

[ayman_salem]

1. by me the request works, maybe the reports you have are "inactive". The /1 at the end returns the active report. If you omitted it, all inactive reports will be displayed.

http://<;server>:6405/biprws/bionbi/content/list

<entry>
<content type="application/xml">
<attrs xmlns="http://www.sap.com/rws/bip">
<attr name="cuid" type="string">AZxxxxxxxxxUTC5I</attr>
<attr name="status_type" type="string">Inactive</attr>
<attr name="last_run" type="string"></attr>
<attr name="title" type="string">Chart Demo</attr>
<attr name="type" type="string">Web Intelligence</attr>
<attr name="view_count" type="int32">0</attr>
</attrs>
</content>
</entry>

....

2. use

http://<server>:6405/biprws/raylight/v1/documents/<docID)/properties

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<properties>
<property key="SI_CUID">Axxxxxx7.R95Bv_Bs</property>
......
<property key="lastsavedby">Administrator</property>
....
.....
<property key="lastrefreshdate">March 7, 2017 5:31:39 PM GMT+01:00</property>
....
....
<property key="modificationdate">April 13, 2018 12:22:51 PM GMT+02:00</property>
<property key="name">ZZ_Rio Games 2016</property>
<property key="createdby">Administrator</property>
....
....
<property key="creationdate">March 9, 2017 6:24:45 PM GMT+01:00</property>
....
....
</properties>

for more info, see "SAP BusinessObjects RESTful Web Service SDK User Guide for Web Intelligence and the BI Semantic Layer"

[former_member644368]

ayman.salem, thank you very much!!! http://<server>:6405/biprws/raylight/v1/documents/<docID)/properties - exactly 🙂

I have been looking for a solution for a long time and you helped a lot. Many thanks!!!

Request http://<;server>:6405/biprws/bionbi/content/list is not working for me because i checked on test server where auditing database was disabled 🙂

Ayman, thank you very much again!

[former_member644368]

ayman.salem, thank you.

1.

I don't understand why the request http://<;server>:6405/biprws/bionbi/content/list/1 does not return data

sap2.png

2. The reruest http://<;server>:6405/biprws/v1/documents/<document id> doesn't have an information about report according the screenshot

Author from screenshot is not the same an ownerid (ownerid is field analog from query builder SI_OWNERID ),

Create Date from screenshot is not the same an created (created is field analog from query builder SI_CREATION_TIME )

Date of last Update from screenshot is not the same an updated(updated is field analog from query builder SI_UPDATE_TS )

For example,

if you copy an existing report, created will be the current date. But, Create Date from screenshot will be another date, not current date

sap.png

[ayman_salem]

I updated the Answer