Home Forums Data Warehousing Analysis Services SSAS RelativeCalendar CurrentYear CurrentMonth RE: SSAS RelativeCalendar CurrentYear CurrentMonth

  • July 14, 2016 at 1:55 am

    #1890013

    bkaurelien (7/13/2016)

    I PB_BI

    thanks for you reply.

    but i don't want to use time intelligence.

    when you say i can use scope it is like this

    scope([Annee en cours]);

    this = StrToMember ("[Date].[Calendar].[Calendar Year].&[" + Format(Now(),"yyyy") + "]" )

    end scope;

    Thanks

    Apologies, I wasn't clear. SCOPE is only required if you need time intelligence. The problem with your MDX is that you are creating a set and then using StrToMember. You need to use StrToSet instead.

    I'm on LinkedIn