[quoted text, click to view] "Jeff A. Stucker" <jeff@mobilize.net> wrote in message
news:ObO2eFJ2EHA.1396@tk2msftngp13.phx.gbl...
> Sounds like you may have answered your own question. If there is
> aggregation (summing) happening in your report that's not in your sample
> application, that's probably the culprit. Reporting Services is having to
> churn through quite a bit of data to get to the results.
Thanks for your response, Jeff.
Actually, after posting my question, I tried something new. I created a copy
of my report, and deleted the subtotal and total calculations. And... the
report now used 6 minutes to display a result. So somehow I don't think it's
the subtotal calculation that is the problem.
[quoted text, click to view] > If the report design is fixed (i.e., you don't have flexibility to
> rearchitect the thing), you might be able to pre-run the report and pull
it
> from cache/history/snapshot. (See the books online for how to do this.)
The report is sort of fixed. It has to display all clients and all projects
for these clients, that an employee has registered hours working for. I've
tried doing it in two different ways, one where everything is loaded into a
report in one go, and one with "nested" (?) reports. Unfortunately, the
nested reports take at least the same amount of time that the one where you
load everything at once, so I don't think that's a very good solution.
Also, I haven't found a way to make snapshots out of these reports. They are
based on the AD user, and if I try to fix a snapshot the usual way, it says
it can't because one of the parameters is User!UserID. I'm going to try to
figure out how to create snapshots. I hope I can just run a job that can
take a list of users, and create a snapshot of the report for each user. Is
this possible?
Kaisa
[quoted text, click to view] > --------------------------------------
> "Kaisa M. Lindahl" <kaisaml@hotmail.com> wrote in message
> news:%23uBh6wH2EHA.1408@TK2MSFTNGP10.phx.gbl...
> > Are there any tricks to speed up the rendering of a report that is based
> > on
> > a OLAP-cube?
> >
> > When I query my OLAP cube with the MDX Sample Application, it takes
about
> > 1
> > minute to return the results. But when I run the same query through
> > Reporting Services, it uses 4-5 minutes.
> >
> > My report shows work hours registered by the various employees in a
firm.
> > The report shows the hours registered for one employee during one month.
> > I'm
> > using a matrix, and the matrix has two groups, Customer and Project. One
> > customer can have many projects, and one employee can have many
customers.
> > The drilldown starts with the total for the employee, then shows the
total
> > for each customer, and then ends with the values for each project for
the
> > chosen customer.
> >
> > I'm wondering why the report takes so long to render. Could it be the
> > total
> > and subtotal? The MDX Sample Application doesn't show this. (Is it
> > possible
> > in MDX?) Are there any smart things I should try to speed it up a bit?
> >
> > All help appreciated!
> >
> > Kaisa M. Lindahl
> >
> >
>
>
