WHERE Clause in MDX

  • Hi, I was wondering how to do a WHERE clause in MDX, where the results are based on a search box. When the user enters customer data in the text box a list of matching customers appear:

    Here is the begining of my query:

    WITH

    MEMBER [Measures].[UniqueName] AS

    [Op].[Key].CurrentMember.Unique_Name

    MEMBER [Measures].[Caption] AS

    [Op].[Key]CurrentMember.Member_Caption

    SELECT

    NON EMPTY

    {

    [Measures].[UniqueName]

    , [Measures].[Caption]

    } ON COLUMNS,

    {[Op].[Key].Children

    } ON ROWS

    FROM [Test]

    any help will be much appreciated.

    Thanks

  • hi,

    Where condition is the last part of the select statement in MDX statement.GIven below the modified sample of yours...

    WITH

    MEMBER [Measures].[UniqueName] AS

    [Op].[Key].CurrentMember.Unique_Name

    MEMBER [Measures].[Caption] AS

    [Op].[Key]CurrentMember.Member_Caption

    SELECT

    NON EMPTY

    {

    [Measures].[UniqueName]

    , [Measures].[Caption]

    } ON COLUMNS,

    {[Op].[Key].Children

    } ON ROWS

    FROM [Test]

    where

    Cheers

    vijay

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

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