Calculated Measure Using Property Member

Last Post 27 Jan 2005 11:25 AM by typok. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

24 Nov 2004 06:16 AM
I have been looking for an answer for this, but I had no luck. I am building a simple calculated member. All that I want to do is to reach down to the property member capacity (which is square feet), show it as a calculated member. I get a blank. If I touch the store with the mouse, while in ProClarity, I see the capacity, so I know it is there. Can anybody show me an example in Food Mart?

VAL([Organization].[Org Type].&[Store].children.currentmember.Properties("Capacity"))

Thanks for your help.
New Member
New Member

27 Jan 2005 11:25 AM
here is the code fro my calculated member to display a property:

where Agents is a dimension, who's lowest member in hierarchy has property AgentMax

Acceptable Use Policy