PDA

View Full Version : properties



mondrian_jnicho02
07-18-2003, 01:58 AM
can properties be accessed yet? if so, could you show me an example MDX please? is it something like:
select {[Promotion Media].[All Media]} ON columns,
NON EMPTY {[Customers].[All Customers].[USA].[CA].[Berkeley]} DIMENSION PROPERTIES [Name].[Gender]
ON rows
from [Sales]

jhyde
07-18-2003, 08:01 AM
You can get properties just by calling Member.getPropertyValue(<propertyName>).
You don't even need to specify the DIMENSION PROPERTIES clause -- we support that clause just for compatibility, but don't do anything with it.
This behavior may change if we find that transmitting all properties affects performance (in the XML for Analysis API, for example).

mondrian_jnicho02
07-23-2003, 09:39 PM
maybe it's because i'm sending my MDX from JPivot, but I couldn't get the syntax right....do you have an actual example query that would work in the jpivot mondrian test query?