Descendants and current year
-
Wednesday, January 09, 2013 4:04 AM
how do i make following SET dynamically take current year (2013)
SET [TwelveMonths] AS Descendants ( [Start Dt].[StartYearMonth].[Year].[2012], [Start Dt].[StartYearMonth].[Month] ,BEFORE)
Thanks
V
All Replies
-
Wednesday, January 09, 2013 4:49 AMtry:
SET [TwelveMonths] AS Descendants (filter([Start Dt].[StartYearMonth].[Year],[Start Dt].[StartYearMonth].[Year].currentmember.membervalue=YEAR(NOW())) , [Start Dt].[StartYearMonth].[Month] ,BEFORE)- Edited by Butmah Wednesday, January 09, 2013 5:11 AM
-
Friday, January 11, 2013 3:03 AMModerator
Hi Vaishu,
We can use the following snippets of code to get current year:
StrToMember
(
"[Start Dt].[StartYearMonth].[Year].&["
+ VBAMDX.Format(VBAMDX.Now(),"yyyy") + "]"
)For more information, please refera to the article below:
http://sqlblog.com/blogs/mosha/archive/2007/05/23/how-to-get-the-today-s-date-in-mdx.aspxIf you have any feedback on our support, please click here.
Regards,
Elvis Long
TechNet Community Support
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Friday, January 18, 2013 1:24 AM
.png)
