astrid 69000 (3/15/2013)

---

hi,

i have another question (or two) :)

1) i want the mdx to always return the data from yesterday without choosing the data, can someone please tell me how to do it? everything i tried doesnt work
2) also the mdx returns the measures for the data i asked on the first column, how do i go iif i want different dates on different columns to return the data

WITH MEMBER [Measures].[Yesterday] AS 
   ""+ FORMAT(Now()-1,"MM/dd/yyyy") +""
SELECT {[Measures].[Yesterday]} ON COLUMNS
FROM [AdventureWorks];

StrToMember("[Time].[Year - Month – Period - Date].[Date].&[" + Format(dateadd("d",now(),-1), "yyyy-MM-ddT00:00:00") +"]")

{StrToMember("[Time].[Year - Month – Period - Date].[Date].&[" + Format(dateadd("d",now(),-1), "yyyy-MM-ddT00:00:00") +"]").Lag(13):StrToMember("[Time].[Year - Month – Period - Date].[Date].&[" + Format(dateadd("d",now(),-1), "yyyy-MM-ddT00:00:00") +"]")}

{null:StrToMember("[Time].[Year - Month – Period - Date].[Date].&[" + Format(dateadd("d",now(),-1), "yyyy-MM-ddT00:00:00") +"]")}