Mdx

[victor_msj]

See this sample, I create in MDX Sample Application:

WITH
MEMBER
Measures.[Store SqFt]
AS
'[Store].CURRENTMEMBER.PROPERTIES("store name")'
SELECT
{ [Measures].[Store SQFT], [Measures].[Store Cost], [Measures].[Unit Sales] }
ON COLUMNS,
[Store].[Store Name].MEMBERS
ON ROWS
FROM Sales

The column Store SqFt, show message #ERR

[Island1]

Try this:

WITH

MEMBER [Measures].[Store SQFT]

AS

'Val(Store.CurrentMember.Properties("Store Sqft"))'

SELECT

{ [Measures].[Store SQFT], [Measures].[Store Cost], [Measures].[Unit Sales] } ON COLUMNS,


{[Store].[Store Name].MEMBERS} ON ROWS


FROM

[SALES]


NOTE: Be sure you parse the above corrrectly. The Forum editor might have misaligned it (some editors attempt to squeeze out empty spaces ...).

If you want to handle the nulls that ensure in the rollups, and so forth, see my article at:

http://www.databasejournal.com/featu...0894_3107081_1

I do everyting you are attempting here, and more.

Good Luck.

Bill