[Mondrian] Measure visible=false

[Julian Hyde]

Manuel,
 
This is too much detail for the developers list. Please post this issue to
the forums. If you don't get satisfactory answers there, consider getting a
Pentaho subscription.
 
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Manuel Darveau
Sent: Friday, May 21, 2010 12:17 PM
To: Mondrian developer mailing list
Subject: [Mondrian] Measure visible=false


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].[AverageNbPro
blematicDocks_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].[AverageEmptyPercen
t_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/014eccfe/attachment.html