The CURRENTMEMBER function expects a hierarchy expression for the 0argument. A member expression was

[RPou0830]

I have a dimension dimZoneProduct with a hierarchy
Zone – Product
. Zone
.. Product

I want to know what percentage has each product by zone

Zone A 20000 100%
Product 1 15000 75%
Product 2 5000 25%

I have the following dmx expresion
With Member [Measures].[ZoneProductPer] as
'([Dim Zone Product].[Zone - Product].[Zone].currentmember,[Measures].
[Sales])
/([Dim Zone Product].[Zone - Product].[Product].CURRENTMEMBER,
[Measures].[Sales])',
FORMAT_STRING = 'Percent'
SELECT NON EMPTY { [Measures].[Sales], [Measures].[ZoneProductPer] }
ON COLUMNS,
NON EMPTY {[Dim Zone Product].[Zone - Product].[Zone].MEMBERS, [Dim
Zone Product].[Zone - Product].[Product].MEMBERS }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM [Sales]
The column [Measures].[ZoneProductPer] shows the error
The CURRENTMEMBER function expects a hierarchy expression for the 0
argument. A member expression was used.

 

[Marc Soester [MVP]]

Hi,

you may want to post this question into the project server developer formum.
You will probably be more lucky for feedback there.
thanks

 

[Paul Conroy]

Instead of using a MDX expression have you considered using a calculated
value in the report/view. This way you could use the IIF function to check
for a zero value.
--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com