mdx查询动态时间

with member mydate as now()
select {[Measures].[SaleAmounts]}
on 0,
{StrToMember("[时间].[日].&[" + Format(DateAdd('d',-1,CDate(mydate)), "yyyy年MM月dd日") + "]")}
on 1
from [多维数据集]

我是参考这篇文章的：