Thread: Mdx
-
Mdx
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
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|