Home > SSRS Expert > SSRS #48 – Reporting Services Data Cache in Development

SSRS #48 – Reporting Services Data Cache in Development

If you have developed a few SSRS reports in BIDs, you must have noticed that BIDs uses a data cache to speed up your development work. Your design-preview-design-preview cycle is fast enough that you probably have never complained . Not yet.

One of my reporting Services reports is still in development phase. After receiving a Success email notification from my ETL job in the morning, I opened up the BIDs, and tried to preview my report. I was expecting data from yesterday, but I didn’t see it.

Issue

I am using BIDs 2008. The SSRS report is accessing an Analysis Services database using MDX. I checked my fact table which has data from yesterday. I know my cube processing was successful. Browsing the cube in SQL Management Studio also showed data from yesterday. However, in BIDs, when previewing the cube, I didn’t see my data from yesterday.

A Quick Solution

I understand the data cache feature. So I didn’t panic. right click on the dataset, select Query.

image

On the Query Designer, click the link to execute the query.

image

This will pull fresh data from the back-end data source. Now I see data from yesterday on Preview.

Another Even Quicker Solution

After I published this post the first time, Mark W, a regular reader, pointed out that the Refresh button is an even quicker way to retrieve the most recent data from the back-end data source.  Thanks Mark!

clip_image002

Reasons for this blog

There are three reasons for this post. One is for the benefit of new SSRS report developers who might be unaware of the data cache feature in BIDs.

Second I am still not sue if BIDS 2008 behaves differently from BIDS 2005 in terms of data cache, or it behaves differently when accessing a cube.

Third reason is to give you a link to this blog post Disable Reporting Services Data Cache in Development. In this blog, the author pointed out that you can permanently disable the data cache feature in BIDs. I personally will not do this, because I really like the data cache feature.

In case somebody wants to give it a try, here is what the author suggested.

Find the config file that controls the Report Designer in BIDS. For SQL Server 2008 SSRS, this should be:

C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\RSReportDesigner.config

Then change CacheDataForPreview to “false”.

image

  1. Mark Wojciechowicz
    May 27, 2011 at 12:39 pm

    Hi sherry, Nice tip on how to turn off caching. You can also hit the refresh button in the report viewer window. This will re-execute the query.
    Mark

    Like

  2. Sherry Li 李雨
    May 27, 2011 at 3:21 pm

    Thanks Mark! I’ve incorporate your even quicker solution into the post.

    Sherry

    Like

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: