PropertyExpression

[DMurray3]

Hi all,

According to the Mondrian Documentation (http://mondrian.pentaho.org/document...A_XML_elements)

Mondrian has a <PropertyExpression> element.

I am trying to use said element like:

<Level name="NombresCompletos" table="dim_clientes_scd2" column="fullname" uniqueMembers="false">
        <Property name="Personeria" column="personeria" type="Numeric">
            <PropertyExpression>
                <SQL dialect="mysql">
                    (If(coop_presenta_dim_clientes_scd2.personeria = 'F', 3, If(coop_presenta_dim_clientes_scd2.personeria = 'J', 1, 
                        If(coop_presenta_dim_clientes_scd2.personeria = 'N', 2, 99))))
                  </SQL>
            </PropertyExpression>
        </Property>
    </Level>

My two questions are: does in fact Mondrian handle the PropertyExpression; and if so, is the above example code correct?

I have tried numerous times to use the mentioned property but after having failed miserably, resorted to use the <Property> and include the "IIfs..." in a Calculated Measure..

I am working with Mondrian 3.0 on PCI

1.7.0.1062

Thanks in advance for your assistance,
Regards, DMUrray3

[jhyde]

I think I made a mistake while reworking the documentation to describe various places that expressions can be represented as sub-elements. PropertyExpression is not a valid element, and never has been. It would be nice if mondrian supported it, but it doesn't.

[DMurray3]

Thanks anyway....

BTW the mistake in the documentation is on the XML Elements detail at the end of the documentation...

Regards, DMurray3

[microdisney]

And much to my dissapointment, it is still there and still not valid.