count of webi Reports published in repository

[Former Member]

Can anyone share the query builder query how to get the count of webi reports published in repository?

[former_member182521 · Accepted solution]

Jawahar,

Go ahead and execute the below query in QB

SELECT count (SI_ID)  FROM CI_INFOOBJECTS

WHERE SI_KIND = 'WebI'

Let me know how it goes

Regards

Mani

[Former Member · Accepted solution]

Mani,

Thanks. Does it give all the reports count including the scheduled reports?

Wafa,

Thanks for SAP note.

[former_member182521 · Accepted solution]

Jawahar,

This will give you all the Webi reports whether it is scheduled or adhoc report along with all the instances

If you want to have only reports excluding instance add a instance=0 clause in where clause with the query above.

Regards

Mani

[Former Member · Accepted solution]

if i want to eliminate reports in the personal folders from the count, si_owner filter is correct filter?

[Former Member · Accepted solution]

Thanks Mani. We got it resolved finally.

[Former Member · Accepted solution]

Hi Mani/Jawahar,

  Is there any way we can get the number of recipients processed  by period. My intention is to find it out number of users are getting benefited with out accessing the SAP BO.

Thanks for your help in advance.

Regards,

Maruthi

[former_member182521 · Accepted solution]

Hi Maruti,

Please create a separate discussion thread going forward.

For your requirement

We cannot always accurately determine the benefited users if they do not access BO directly.

The users could be

- Email recepients

- Accessing published reports from a file system/Sharepoint

- Accessing from FTP

Thanks

Mani

[Former Member]

Hi,

Can you check this note : "1395695 - How to find the number of Web Intelligence and Desktop Intelligence reports in the BusinessObjects Enterprise using Query Builder."

http://service.sap.com/sap/support/notes/1395695

Best regards,

Wafa