Wednesday, April 29, 2009

MDX for searching dimensions members

I wrote a simple MDX to list out the Employees whose name contains 'RA' and get the corresponding Parent Key as well.
*************************************************************************
Select
Generate({Filter({[Employee].[Employees].members},Instr([Employee].[Employees].currentmember.Name,"RA")>0)} ,Ascendants( [Employee].[Employees].currentmember))
DIMENSION PROPERTIES [Employee].[PARENT_UNIQUE_NAME] on rows,
{} on columns
From [Adventure Works]
*************************************************************************

No comments: