Reporting Services - Professional SQL Server Analysis Services 2005 with MDX - page 920

propriate permissions set on your Analysis Services database. If you want to
provide access to users whose security is managed only through Analysis
Services instance then choose the option Credentials supplied by the user
running the report. Specify the right permissions and then click on the Execu-
tion tab.
Figure 17-39
The Execution tab shows the various ways in which the report can be
rendered on the report server (see Figure 17-40 ) . You can have the report run
at the time when users access the report or schedule the report to be run
every 30 minutes or specific time interval. In this way data is cached on your
report server ensuring the reports are rendered immediately. If you do want
the most recent data then you should not cache the report. The query to re-
trieve data from the data provider (in this example it is Analysis Services) can
take a long time. You do have the option of specifying snapshots at which this
specific report or additional reports get rendered and stored on the report
server using the option Render the report from a report execution snapshot.
Report server provides you certain options in report execution to limit the
amount of time the report server should wait to retrieve the data. The last op-
tion under Report Execution Timeout is to define a specific timeout value. Use
the default settings for report Execution and then click on the Security tab.