Programmatically dumping report cache: How?

[apaulos]

I’m working on recoding a Perl script to Java that runs on a Solaris server and submits ‘publishing’ requests to a local install of NetGenesis (web analytics solution that leverages MicroStrategy). The NetGenesis engine interacts with a MicroStrategy server to run off reports and documents. The issue I’m having is that the NetGenesis piece no longer appears to force MicroStrategy to run fresh reports. The issue started after applying a recent NetGenesis bug fix release. Specifically, the reason for the issue with pulling cached reports instead of fresh is that we have a one to many relationship between reports and documents ( i.e. the reports have a filter which feeds off a table whose contents are changed/updated between jobs ).

Simply disabling cache doesn’t appear to be an option since the cached version of the reports are temporarily needed for the documents. Is there some way of having all report executions overwrite cache ?

Or, an approach for forcing reports in cache to expire? to be deleted? from a script running on a separate machine ( via the web interface )? Is deleting the cache files an option between jobs w/o restarting the MicroStrategy server?

Appreciate any and all comments and/or suggestions. Thanks, Paul

 

[apaulos]

Cont'd from orignal post... I just re-read every single post. Seems like, I can simply do the cache 'purge' via the API. Does anyone have any API docs or manuals they could share? I've got a few MicroStrately PDF's but nothing strictly related to the IServer API. The only one that comes close is the Web Dev Guide.

or perhaps some sample code ( any language is fine ).

Thxs, Paul

 

[entaroadun]

Check the knowledge base. There is plenty there. With the IServer API, the safest way is to pass in DSSReportFresh for the Flags argument when executing the report instance:

Call IDSSReportSource.Execute(IDSSReportInstance, DSSReportFresh)

This forces the report server to ignore cache completely, for both resolving the report definition (if it has prompts), and for populating the base template.

If you want the report server to use cache for resolving the report definition, and only to re-execute SQL and analytical functions for populating the base template, then there's some other flag. All flags are part of the EnumDSSReportFlags data type.

As for IServer API doc, it is included with the 7.2 install. In the Start Menu -> Microstrategy 7 folder, there is a Product Manuals html link. In the bottom section of that page are pdfs for IServer and Web API common functions and IServer advanced functions.

 

[chael]

yeah, entaroadun is correct that you have to pass the proper execution flag(s) when running the report. What does your report execution look like?

You could also look into using Command Line Manager to do some of the work for you (i.e., for help invalidating cache).

 

[apaulos]

Thank you both for your suggestions. I can't modify the NetGenesis application to invalid cache as it runs each job. But since I'm manually kicking off the NetGenesis jobs with Java, the ideal solution for me would be to interact directly with microStrategy to dump any report cache before I submit my job to NetGenesis.

The NetGenesis install actually installs MicrStrategy 7.1.2 and some of the manuals. But not any of the API/SDK pdf's. So I've got as part of the install the two microStrategy jars for the Java/WEBAPI but no manuals. Even worse I can't kind find my eval copy of MicroStrategy and the mStrat site is serving up 500's when I try to go thru the download process.

I'll be calling into mStrat first thing Monday morning...

Thanks again for responding. Rgrds, Paul

 

[chael]

Also try looking in Program Files\Common Files\MicroStrategy\Documentation at any of the .pdfs there.

If you own the SDK then sample files would be in Program Files\MicroStrategy\SDK
Sounds like you are SOL until the AM.

Chael