Cashing a report through COM SDK

[243dotZero]

I am currently writing a front end application using Visual Basic and the MS COM SDK. I can run a report that resides within a MS project, but afterwards the report is not cached (i.e., it does not show up in the Cache Monitor when I visit the project as an administrator through Desktop). As a result, the next instance of the report takes almost as long to run as the first instance did.

I found that there are execution flags that can be set to manage the cache. I tried to set some but still no luck. Here is the command that executes the report:
objReportServer.Execute objReportInstance, DssActionExecuteAll, DssReportRunSynch + DssReportUpdateAllCache + DssReportUseAllCache

Does this look right? Does anyone know how I can get MS to perform the caching of reports that I call through the SDK?

Thanks for your thoughts.

 

[chael]

I think the EnumDSSReportActions flag can be either more explicitly set here, or not set at all...try using [red]DSSActionAllCache[/red]...or just leave it blank and let MicroStrategy use the default actions for the report.

My thinking is that the execution flag is more important here than the result flag...

Chael

 

[243dotZero]

Thanks Chael,

I would agree with your suggestion but unfortunately it didn't work. I've tried every cache-related action flag Enum and still no dice. It is my understanding that MS should cache the report by default (go figure).

If I run the report through desktop, it caches fine, but still the SDK application will not hit the cashed report.

Any other suggestions would be appreciated.

Thanks.

 

[entaroadun]

What version of MSTR are you using? In 7.2.2+ the code you have caches the report properly.

 

[243dotZero]

I'm using 7.2.0. I think the tech support people are beginning to reach the same conclusion but I'm still waiting on the verdict.

Thank you for validating that for me.

 

[243dotZero]

Ok, I installed Desktop (SDK) 7.2.2 and my code works with the 7.2.0 server. Looks like a bug in the 7.2.0 SDK.

Thank you all for your help!