hi,

i did what you suggested and it worked perfectly. but then i tried to do the yesterday thingy and i got the following error 🙁

Executing the query ...

The Measures hierarchy already appears in the Axis0 axis.

Execution complete

but i dont understand why, cause i do put the measures on the rows and the yesterday thingy on the column 🙁

here is the code.

with

member [Measures].[Max] As

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

member [Measures].[Min] As

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

member [Measures].[Avg] As

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

member yesterday as dateadd("d",now(),-1)

select yesterday 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]