select [Measures].[Hrs] on
0,
Descendants(filter([D Date].[Hierarchy].[YEAR],[D Date].[year].currentmember.membervalue=YEAR(NOW())-1),[D
Date].[Hierarchy].[MONTH],LEAVES) on 1
from [Cube]
Read in the following link for more examples on How To Obtain the Current Day with a MDX Query or Expression in SQL Server
No comments:
Post a Comment