MS SQL Server OLAP - Filtering using member key in mdx query

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Filtering using member key in mdx query

ktk

2005-04-21, 9:23 am

Hi,

I have a Customers Dimension with CustomerName as the Dimension Level.
The member key and member name property of the CustomerName level are
the Key field and Description field of the table.

I would like to know if it is possible to refer to the member key
column of the dimension member in the WHERE clause of an mdx query
using its member name column value?

E.g.

SELECT
{ } ON ROWS,

{ } ON COLUMNS

FROM TestCube

WHERE ([Customers].[CustomerName].[xxxxx])

where [xxxxx] should actually refer to the key field.

Appreciate any response to this!

thanks,
ktk

Sponsored Links