Calculated Measure Using Property Member

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

--
24 Nov 2004 07: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.
TC
typok
New Member
New Member

--
27 Jan 2005 12:25 PM
here is the code fro my calculated member to display a property:
[Agents].CurrentMember.Properties("AgentMax")

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


Acceptable Use Policy
---