Hi Astrid,

Your MDX is quite unusual and without access to your cubes I can't really say I've helped you but try the below MDX

I would say that:

If you want averages/max etc you can't do that in select part of MDX - it's either done in the "with" part of the MDX or in the cube's calculation script

The cube will auto-aggregate your data so there wasn't the need for the aggregate clause in your MDX

You only need to specify the datetime once - in the case on the rows. You don't need to do this in the where clause as well

with

member [Measures].[Max] As

max({[Hour Dim].[D Hour].[All]},[Measures].[Purchase - converted to USD])

member [Measures].[Min] As

min({[Hour Dim].[D Hour].[All]},[Measures].[Purchase - converted to USD])

member [Measures].[Avg] As

min({[Hour Dim].[D Hour].[All]},[Measures].[Purchase - converted to USD])

select {[Time].[Year - Month - Period - Date].[Date].&[2013-03-10T00:00:00]} on columns,

{[Measures].[Purchase - converted to USD],

[Measures].[Purchases_Count],

[Measures].[Site Pay User],

[Measures].[Free_signups],

[Measures].[free to site pay user],

[Measures].[click to site pay user],

[Measures].[Click Count],

[Measures].[Guests Logins Count],

[Measures].[Guests Unique Logged in],

[Measures].[Guests Credit Spent],

[Measures].[Max],

[Measures].[Min],

[Measures].[Avg]} on rows

FROM [Dw Virtual]

WHERE ([Sites Dim Vw].[Site Group Tree].[Site Group].&[ All],

[Device Name].[Device Name].[All])

Mack