WHERE Clause in MDX

• VB-839659

  SSC Enthusiast

  Points: 145

  More actions

  August 12, 2008 at 2:49 am

  #123012

  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

• elegantkvc

  SSCommitted

  Points: 1910

  More actions

  September 9, 2008 at 12:05 am

  #868858

  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