Spefic aggregation doesn't improve execution

[Database Administrator]

I have a cube with few dimensions. I create a specfic aggregation on 3
attributes of my dimension (Year - Customer group and Product group). I
created these aggregation by using OlapQueury Log. I don't why but no
aggreation, or this specific aggreation doesn't improve anything !!

[Database Administrator]

can you describe your measures?
do you use DCount?
calculations?
how many rows do you have in the fact table? do you use partitions?
does your dimensions use rigid hierarchies?

you can also you the profiler to see if your queries hit the aggregations.

"MIB" wrote in message
news:8CD65B45-42AD-446B-BAF3-350759AA1E82@microsoft.com...
> I have a cube with few dimensions. I create a specfic aggregation on 3
> attributes of my dimension (Year - Customer group and Product group). I
> created these aggregation by using OlapQueury Log. I don't why but no
> aggreation, or this specific aggreation doesn't improve anything !!
>

[Database Administrator]

First thank you for your interest, and sorry for my English (I'm French !).
I have 3 fact table, with just one calculation wich is the sum of 3 measures
(one in each fact table). But when i have tested my cube, i didn't used
calculation.
We have only 500 000 lines in the first fact table, and 30 000 in the second
and the third.

We use flexible for tw o reason. The first we are not use when to use rigid
(stupid i know!), second we tought that rigid improve processing time but not
qeury.

Yes, by using the profiler we saw that the system use aggregation and cache.
I'm very surpised, because when we are using OlapqueuryLog (we are inserting
all the row, and not just 10%), we can see that time duration is not at all
linked to the time of execution in my profiler. For example for one qeury 4
lines are generated, and the sum of duration is arround 2 second, but my
queury in the profiler takes 6 minutes.

Thanks



"Jeje" wrote:

> can you describe your measures?
> do you use DCount?
> calculations?
> how many rows do you have in the fact table? do you use partitions?
> does your dimensions use rigid hierarchies?
>
> you can also you the profiler to see if your queries hit the aggregations.
>
> "MIB" wrote in message
> news:8CD65B45-42AD-446B-BAF3-350759AA1E82@microsoft.com...
> > I have a cube with few dimensions. I create a specfic aggregation on 3
> > attributes of my dimension (Year - Customer group and Product group). I
> > created these aggregation by using OlapQueury Log. I don't why but no
> > aggreation, or this specific aggreation doesn't improve anything !!
> >