MDX filter on column value ?

[Exie]

Hi I have a cube that looks like so:

<Dimension name="Customers">
	<Hierarchy hasAll="true">
		<Level name="Customer Group" column="CUST_GROUP" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
		</Level>
		<Level name="Customer" column="PARENT_ID" nameColumn="PARENT_CUST_NAME" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" ordinalColumn="PARENT_CUST_NAME">
		</Level>
		<Level name="SubCustomer" column="CUSTOMER_ID" nameColumn="CUSTOMER_NAME" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
			<Property name="Customer Name" column="CUSTOMER_NAME" type="String">
			</Property>
		</Level>
	</Hierarchy>
</Dimension>

and I want to write and MDX query to select only data relating to member with PARENT_ID value of 20222

.. Something like:

select NON EMPTY { [Measures].[Total Value] } ON COLUMNS, 
   NON EMPTY {[Product].[All Products].Children } ON ROWS
from [Sales]
where [Customers].[All Customerss].[CR].value[20222]

At the moment, the square brackets represent the value of nameColumn ... but I want the actual column filed.

 

[IanWaterman]

I think it should be

select NON EMPTY { [Measures].[Total Value] } ON COLUMNS,
NON EMPTY {[Product].[All Products].20222 } ON ROWS
from [Sales]
where [Customers].[All Customerss].[CR]

Ian