Caching & Archiving 1

[Catadmin]

Hey,

Does anyone know for sure if report caching and report archiving works the same between RS 2000 and RS 2005?

I can't find any data on how it works in RS 2000, but I have plenty of resources with describing it in 2005, so I'm trying to figure out if this is one of those things set in concrete or if MS changed it from when they put out the original RS.

Thanks,



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[Sheco]

I don't know about 2005, but in 2000 the term "cache" refers to a temporary copy of the report that is held for a defined period of time.

I have a reporting "warehouse" that is only updated once per day at 1AM... today's warehouse has yesterday's data and tomorrow's warehouse will contain today's data.

Since the data is only updated once per day, queries against this database will give exactly the same results at 8AM as they do at 5PM on any given day because the database is not "live."

I made a shared schedule for every day at 6AM... Reports that use this particular warehouse database have caching that expire on this schedule. This means that reports run against this database will only actually query the database once per day. All subsequent requests for the same report will be served up the cached version... unless the report parameters are changed by the user.

Reports rendered from cache are displayed a lot faster than when the database is queried.

For the reports that I know will be used by someone almost every day, I can set up an execution snapshot to run on the schedule. Like reports rendered from cache, users will see execution snapshot reports much faster than when the database is actually queried. Since my schedule runs at 6AM, even the 1st guy to work will see this report quickly... if it was merely cached then the first guy would need to wait for execution and the following peeps would get it fast.

In RS 2000, the archive is known as "History." This is a separate thing from the cache... but related to the execution snapshot... you can configure report manager to save all execution snapshots into History... or you could just save history manually with a button... or you could create history according to a schedule.

 

[Catadmin]

Sheco,

Thanks. I already know that part of the information. The problem isn't in using Report Manager to do the Snapshots and the History archiving. The problem is that we're trying to call everything in a WebService method via VB from the actual Report Server databases (not the IE interface) and there is NO DOCUMENTATION on this for RS 2000.

<Excuse me while I tear my hair out. @=/ >

I found a book on RS 2005 which describes all sorts of methods like SetReportHistoryOptions and ListReportHistory, etc. What I really need to know is if these methods are available in RS 2000 (which is what we currently have) and if anything in the actual internal processes (invisible to us DBA types) has changed in the new version or if I can go off this 2005 book and everything will work okay.

If the methods are the same, and the Report Server databases are the same and the engine we can't see is the same, then I'm good to go. If, however, a datatype has changed, or a column name has changed or certain methods are not available, then I need to locate information on this for RS 2000.

Thanks,




Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[Sheco]

I haven't tried that but I do have a big object model poster that shows objects and their interfaces for Reporting Services 2000...

It looks like a Report object has the following:[tt]
SetReportDefinition
GetReportDefinition
SetReportDataSources
GetReportDataSources
GetReportDataSourcePrompts
SetReportParameters
GetReportParameters
SetCacheOptions
GetCacheOptions
FlushCache
SetExecutionOptions
GetExecutionOptions
[highlight]SetReportHistoryOptions
GetReportHistoryOptions
SetReportHistoryLimit
CreateReportHistorySnapshot
DeleteReportHistorySnapshot
ListReportHistory[/highlight]
CreateSubscription
CreateDataDrivenSubscription
ListSubscriptions
Render
RenderStream
GetRenderResource
SetReportLink[/tt]

 

[Catadmin]

AHA!!!!

That might help. Thanks!

I'd give you a cookie, but I'm out. How about a star? @=)



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[Sheco]

Thanks!

I plugged those highlighted ones into google and got this:

http://msdn.microsoft.com/library/d...us/RSPROG/htm/rsp_prog_soapapi_intro_6xo9.asp

And then a link on the top of that page seems to be the missing documentation:

http://msdn.microsoft.com/library/d...us/RSPROG/htm/rsp_prog_soapapi_intro_27ty.asp