Re: Calculated Member using a Dimension Property

#1

Try descendants of just the current [UnitStatus]:

Quote:

SUM(FILTER(Descendants([UnitStatus].CurrentMember,

[UnitStatus].[Unit Status Description]),
[UnitStatus].CurrentMember.Properties("Code Val")="O"),
Measures.Units)

Quote:

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap