Hi,

I woudl like to know how to improve performances of query.

I have a cube, quite small with 8 dimensions and 2 measures. I also have 3 calculated members because i need avg aggregates on my measures. So 2 of my calculated measures are the simple measures but with avg aggregate. the third measure is the increase in percent between the 2 other measures.

I do use and browse my cube in Excel 2007. And the execution time of query is too long. I used the partition to design aggregates and optimize performances but it's still very low.

I saw that "scope" could bemore efficientthan calculated members but i dont know how it works.

Could someone tell me that?

Here is the code of one of my calculated members:

Avg(

Descendants(

[Manager 1].[Manager].Children

),

[Measures].[PA Salaire]

)

Hi,

if your goal is is performance improvement then use like that

WITH
   
   MEMBER [Measures].[Count]  as
   ([Geography].[Country].CURRENTMEMBER).count
   MEMBER [Measures].[Avg]
   as [Measures].[Internet Sales Amount]/[Measures].[Count]

SELECT {[Measures].[Count] ,[Measures].[Avg]
        } ON 0 ,
      [Customer].[Customer].[Customer] on 1
FROM [Adventure Works]

Regards,

Manish