Interview Preparation mode beta
Funny Facebook Status Funny Facebook Status
Enter your email address

How do you write MDX query that uses execution date/time as a parameter, in SSAS?

Nice?Vote!

1 Answer

Nice?Vote!
SELECT {[Measures].[Internet Order Count]} ON 0, {StrToMember("[Date].[Date].[" + Format(now(), "MMMM dd, yyyy") + "]")} ON 1FROM [Direct Sales];
answered 1 year ago by R (19,530 points)

Related questions