[Mondrian] Measure visible=false

Manuel Darveau manueldarveau at gmail.com
Fri May 21 15:16:31 EDT 2010


Hi,

For some reason even if I set visible=false on my measures they gets
displayed in excel.

Ex:
    <Measure name="AverageNbDocks_sum" column="nbDock" datatype="Numeric"
aggregator="sum" visible="false">
    </Measure>
    <Measure name="AverageNbDocks_count" column="nbDock" datatype="Numeric"
aggregator="count" visible="false">
    </Measure>
    <Measure name="MinNbDocks" column="nbDock" datatype="Integer"
aggregator="min" caption="Min Nb Docks" visible="true">
    </Measure>
    <Measure name="MaxNbDocks" column="nbDock" datatype="Integer"
aggregator="max" caption="Max Nb Docks" visible="true">
    </Measure>
    <Measure name="AverageNbBikes_sum" column="nbBike" datatype="Numeric"
aggregator="sum" visible="false">
    </Measure>
    <Measure name="AverageNbBikes_count" column="nbBike" datatype="Numeric"
aggregator="count" visible="false">
    </Measure>
    <Measure name="MinNbBikes" column="nbBike" datatype="Integer"
aggregator="min" caption="Min Nb Bikes" visible="true">
    </Measure>
    <Measure name="MaxNbBikes" column="nbBike" datatype="Integer"
aggregator="max" caption="Max Nb Bikes" visible="true">
    </Measure>
    <Measure name="AverageNbFreeDocks_sum" column="nbEmptyDock"
datatype="Numeric" aggregator="sum" visible="false">
    </Measure>
    <Measure name="AverageNbFreeDocks_count" column="nbEmptyDock"
datatype="Numeric" aggregator="count" visible="false">
    </Measure>
    <Measure name="MinNbFreeDocks" column="nbEmptyDock" datatype="Integer"
aggregator="min" caption="Min Nb Free Docks" visible="true">
    </Measure>
    <Measure name="MaxNbFreeDocks" column="nbEmptyDock" datatype="Integer"
aggregator="max" caption="Max Nb Free Docks" visible="true">
    </Measure>
    <Measure name="AverageNbProblematicDocks_sum" column="nbNotOkDock"
datatype="Numeric" aggregator="sum" visible="false">
    </Measure>
    <Measure name="AverageNbProblematicDocks_count" column="nbNotOkDock"
datatype="Numeric" aggregator="count" visible="false">
    </Measure>
    <Measure name="MinNbProblematicDocks" column="nbNotOkDock"
datatype="Integer" aggregator="min" caption="Min Nb Problematic Docks"
visible="true">
    </Measure>
    <Measure name="MaxNbProblematicDocks" column="nbNotOkDock"
datatype="Integer" aggregator="max" caption="Max Nb Problematic Docks"
visible="true">
    </Measure>
    <Measure name="AverageFullPercent_sum" column="fullDockPercent"
datatype="Numeric" aggregator="sum" visible="false">
    </Measure>
    <Measure name="AverageFullPercent_count" column="fullDockPercent"
datatype="Numeric" aggregator="count" visible="false">
    </Measure>
    <Measure name="MinFullPercent" column="fullDockPercent"
datatype="Numeric" aggregator="min" caption="Min Full %" visible="true">
    </Measure>
    <Measure name="MaxFullPercent" column="fullDockPercent"
datatype="Numeric" aggregator="max" caption="Max Full %" visible="true">
    </Measure>
    <Measure name="AverageEmptyPercent_sum" column="emptyDockPercent"
datatype="Numeric" aggregator="sum" visible="false">
    </Measure>
    <Measure name="AverageEmptyPercent_count" column="emptyDockPercent"
datatype="Numeric" aggregator="count" visible="false">
    </Measure>
    <Measure name="MinEmptyPercent" column="emptyDockPercent"
datatype="Numeric" aggregator="min" caption="Min Empty %" visible="true">
    </Measure>
    <Measure name="MaxEmptyPercent" column="emptyDockPercent"
datatype="Numeric" aggregator="max" caption="Max Empty %" visible="true">
    </Measure>
    <Measure name="AverageFullPercent_sum" column="fullDockPercent"
datatype="Numeric" aggregator="sum" visible="false">
    </Measure>
    <Measure name="AverageFullPercent_count" column="fullDockPercent"
datatype="Numeric" aggregator="count" visible="false">
    </Measure>
    <CalculatedMember name="AverageNbDocks" caption="Average Nb Docks"
formula="[Measures].[AverageNbDocks_sum]/[Measures].[AverageNbDocks_count]"
dimension="Measures" visible="true">
    </CalculatedMember>
    <CalculatedMember name="AverageNbBikes" caption="Average Nb Bikes"
formula="[Measures].[AverageNbBikes_sum]/[Measures].[AverageNbBikes_count]"
dimension="Measures" visible="true">
    </CalculatedMember>
    <CalculatedMember name="AverageNbFreeDocks" caption="Average Nb Free
Docks"
formula="[Measures].[AverageNbFreeDocks_sum]/[Measures].[AverageNbFreeDocks_count]"
dimension="Measures" visible="true">
    </CalculatedMember>
    <CalculatedMember name="AverageNbProblematicDocks" caption="Average Nb
Problematic Docks"
formula="[Measures].[AverageNbProblematicDocks_sum]/[Measures].[AverageNbProblematicDocks_count]"
dimension="Measures" visible="true">
    </CalculatedMember>
    <CalculatedMember name="AverageFullPercent" caption="Average Full %"
formula="[Measures].[AverageFullPercent_sum]/[Measures].[AverageFullPercent_count]"
dimension="Measures" visible="true">
    </CalculatedMember>
    <CalculatedMember name="AverageEmptyPercent" caption="Average Empty %"
formula="[Measures].[AverageEmptyPercent_sum]/[Measures].[AverageEmptyPercent_count]"
dimension="Measures" visible="true">
    </CalculatedMember>
    <CalculatedMember name="AverageFullPercentCalc" caption="Average Full
Percent Calculated"
formula="[Measures].[AverageFullPercent_sum]/[Measures].[AverageFullPercent_count]"
dimension="Measures" visible="true">
    </CalculatedMember>

Manuel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20100521/5c1b6617/attachment.html 


More information about the Mondrian mailing list