the strtomember worked perfectly when i changed the date with the dynamic date (someone pointed that out for me).

the problem that i encounter with that was when i needed to put together two dynamic type of dates.

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 [Measures].[VOID] As

CROSSJOIN({strToMember("[CHB Date].[Year - Month - Period - Date].[Date].&[" + Format(dateadd("d",now(),-1), "yyyy-MM-T00:00:00") +"]") },

{ [Chargebacks].[CHB_Tree].[CHB Type].&[IRS VOID] }), [Measures].[Purchase - converted to USD]

select strToMember("[Time].[Year - Month - Period - Date].[Date].&[" + Format(dateadd("d",now(),-1), "yyyy-MM-ddT00: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

Basically this part doesn't work.

if i change the strToMember, with a date that is not dynamic it does work, but since the report needs to be run automatly on daily basis, all dates need to be dynamic.

member [Measures].[VOID] As

CROSSJOIN({strToMember("[CHB Date].[Year - Month - Period - Date].[Date].&[" + Format(dateadd("d",now(),-1), "yyyy-MM-T00:00:00") +"]") },

{ [Chargebacks].[CHB_Tree].[CHB Type].&[IRS VOID] }), [Measures].[Purchase - converted to USD]

:w00t: