HostWeb Forums » Microsoft Databases » microsoft.public.sqlserver.olap » Analysis Services 2005 SP2 Aggregation Manager
Topic: Analysis Services 2005 SP2 Aggregation Manager
Hi,
I have a very large cube with 20% aggregation.
Even then, there were few queries that are taking very long time to return
back. I am planning to install the SP2 Agg Manager and build pinpoint aggs.
My question is, if i build specific aggs using SP2 Agg Manager, will it over
write the regular aggregations created earlier by the Analysis services
wizard? How do we check that? Will there be some thing in the XMLA file.
Thanks.
Replies below ↓
Replies
Re: Analysis Services 2005 SP2 Aggregation Manager
On Jun 6, 11:03=A0am, Prasad <Pra...@discussions.microsoft.com> wrote:
> Hi,
>
> I have a very large cube with 20% aggregation.
>
> Even then, there were few queries that are taking very long time to return=
> back. I am planning to install the SP2 Agg Manager and build pinpoint aggs=
.
>
> My question is, if i build specific aggs using SP2 Agg Manager, will it ov=
er
> write the regular aggregations created earlier by the Analysis services
> wizard? How do we check that? Will there be some thing in the XMLA file.
>
> Thanks.
I'd recommend to try querying it at the "all leaf" level just to be
sure that the aggregations are actually the issue. Then alter the
query going up one level at a time with 1 dimension and see how the
response fares. make sure to re-set your SSAS server inbetween each
test to make sure that you're not retrieveing from cached results on
the server or that will muck up hat you're trying to test (assuming
you're having issues with cold cache, or pure ad hoc querying).
-thomas