Query builder query to find the path of the report

[Former Member]

Hi All,

Can somebody please suggest me to write a query using query builder for getting the following details,

Webi Report Path

Frequency of report run(daily/weekly/monthly)

Export Format

Would be great if somebody help me with this query!!

thanks in advance for u r help

Regards,

AA

[former_member1250444]

@Jawahar can you share the steps to fetch report path through SDK?

[anne-petteroe]

Hello Riya,

While we're happy that you've come to SAP Community to get an answer to your question, you posted your question as an answer in an old thread.

I've converted your answer to a comment, but even so -- posting in older threads is not the best way to get guidance.

If you're looking for help, you should ask a new question: https://answers.sap.com/questions/ask.html.

Here are some tips to help you craft an effective question for our community: https://community.sap.com/resources/questions-and-answers, https://developers.sap.com/tutorials/community-qa.html, https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-a....

I hope you find this advice useful!

Kind regards,
Anne

[Joe_Peters]

There is an SI_PATH property, but it's only present on folders. To get the path of a WebI report, you either need to walk up the hierarchy, by re-querying on the SI_PARENTID property, or at least walk up until you get to a folder, at which point you can use SI_PATH.

[former_member185603]

You can get schedule reports information using below query

SELECT SI_ID, SI_NAME, SI_KIND, SI_NEXTRUNTIME, SI_SCHEDULEINFO FROM CI_INFOOBJECTS WHERE SI_RECURRING = 1

Getting path is not possible if you are using query builder. You need to use SDK to extract this information.

Using this 3rd party tool, to export to excel.

http://bukhantsov.org/2012/03/query-builder-with-export-to-excel/