Search code examples
ssasmdxweek-numberdatepart

SSAS MDX datepart iso_week

In T-SQL I can retrieve ISO week number using dateprat function:

 select datepart(iso_week, sysdatetime())

Is there an equivalent in MDX? I have troubles to find it. I can retrieve number of week in MDX e.g. like this:

with member Measures.Test as (Format(now(), "yyyy") + cstr(datepart("ww", now())))
select  Measures.Test on columns
from    MyCube

But how about iso_week? Thanks, Petr

Solution

  • Please try below:

    WITH
MEMBER [Measures].[Iso_week] AS Datepart("ww",NOW()-WeekDay(NOW(),2)+4,2,2)
SELECT [Measures].[Iso_week] ON 0
FROM [Some_cube]

    More help here: http://www.snb-vba.eu/VBA_ISO_weeknummer_en.html