Where is the Last Execution Date stored for a Webi report?

sdk development
1

Where is the Last Execution Date stored for a Webi report? I need to create a list of all reports in the repository showing Update Date (saved) and Last Run Date (scheduled) and when it was last refreshed. I can’t find anything in query builder for SI_KIND = ‘WEBI’. I know this refresh date is out there somewhere because when I run a Webi report I include LastExecutionDate and it returns the correct date. Where is this date kept? Can’t find it in any of the properties in query builder and I can’t find it in the FRS. I’m using VBA/Excel to display this list.

ODPPOLL (BOB member since 2007-05-30)

2

You would need to use the Java SDK (up to XI3) or the REST API (BI4) to get that info.

Joe

joepeters :us: (BOB member since 2002-08-29)

3

OK but just where is that Last Execution Date stored or kept? Do you know the java command to access it?

ODPPOLL (BOB member since 2007-05-30)

4

In XI3, using the REBean API, it’s fairly straightforward. You first need to get a reference to the report engine:


ReportEngines reportEngines = (ReportEngines) enterpriseSession.getService("ReportEngines");
ReportEngine webiRepEngine = reportEngines.getService(ReportEngines.ReportEngineType.WI_REPORT_ENGINE);

Then open the document by ID (12345, for example):

DocumentInstance doc = webiRepEngine.openDocument(12345);

With the DocumentInstance, you can then get various properties from the report, including the last refresh date:

Properties propsDoc = oDoc.getProperties();
String lastrefresh = ((String)propsDoc.getProperty("lastrefreshdate"));

This kind of works in BI4, but it’s not supported.

The supported method in BI4 is the REST API. To use that, you’ll need about 10,000 lines of code to create, read, and parse HTML request and response packets in either XML or JSON. Also, the REST API doesn’t expose a document-level last refresh date. You’ll need to iterate through all data providers in the document to pick up the most recent one.

There are a few examples of how to use the REST API on SCN. here is one.

Joe

joepeters :us: (BOB member since 2002-08-29)

5

Outstanding Joe! Thanks, now this is something I can fiddle with.

ODPPOLL (BOB member since 2007-05-30)