Post reply

Date Hierarchy CurrentMember returns Null, what am i doing wrong

  • September 19, 2014 at 11:06 am

    #311748

    When I run the following query, [Measures].[Previous Period] and [Measures].[X] are coming back with null.

    I tried changing the dimension type properties to time, date, etc but no joy

    WITH MEMBER [Measures].[Previous Period] as

    ( ParallelPeriod(

    [Date].[Fiscal].[Fiscal Month] -- Level to traverse

    , 1 -- How many members to go back on the Level

    ,[Date].[Fiscal].CurrentMember ))

    MEMBER [Measures].[X] as [Date].[Fiscal].CurrentMember

    SELECT

    {

    [Measures].[Previous Period], [Measures].[X]

    } ON COLUMNS,

    {[Date].[Fiscal].[Fiscal Month] } ON ROWS

    FROM [TOL Metrics Usage]

    where ( [Dim EVENTTYPE].[IASEVENTTYPEKEY].&[ET00000040], [Dim User Type].[User Type Key].&[2])

    Not sure what I am doing wrong....

  • September 22, 2014 at 2:28 am

    #1746958

    I'm not sure what you're trying to achieve with this query (ParallelPeriod is usually used in conjunction with an aggregation to give a value) but if you just need the measures to display what they are then you can append them with .Name, like so:

    WITH MEMBER [Measures].[Previous Period] as

    ( ParallelPeriod(

    [Date].[Fiscal].[Fiscal Month] -- Level to traverse

    , 1 -- How many members to go back on the Level

    ,[Date].[Fiscal].CurrentMember )).Name

    MEMBER [Measures].[X] as [Date].[Fiscal].CurrentMember.Name

    I'm on LinkedIn

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply