none
Dynamic Named Set not Evaluating in Current Context in Cube but works in Query

    Question

  • Hello,

    I have a problem where Named set works perfectly in the MDX Query Editor but when defined as Dynamic named set in SSAS Cube it doesn't evaluate the Where clause or Filter in cube browser.

    I tried using EXISTING to force the current context but to no avail.

    Here's the query which works in MDX Query Editor.

    WITH SET [NewSet] AS

    Filter(
    NONEMPTY
    (
    {
    [Machine].[Machine Serial Number].[Machine Serial Number].Members *
    [Machine].[Effective Date].[Effective Date].Members *
    [Machine].[Expiration Date].[Expiration Date].Members
    },[Measures].[Cash Played] 
    )


    ,([Machine].[Effective Date].CurrentMember.MemberValue <= [Date].[Business Date].CurrentMember.MemberValue AND
    [Machine].[Expiration Date].CurrentMember.MemberValue >= [Date].[Business Date].CurrentMember.MemberValue
     )

    )


    SELECT 
    [Measures].[Cash Played] ON 0,
    [NewSet] ON 1

    FROM VGT
    WHERE 
    ([Locations].[d Location ID].&[223],[Date].[Business Date].&[2013-01-01T00:00:00])

    Any suggestions in right direction will be really helpful!

    Thanks

    Tuesday, September 24, 2013 7:33 PM

Answers