[Mondrian] Measure visible=false

[Manuel Darveau]

Oh, sorry about that, I searched for a user mailing and could not find one
and tough that it was appropriate for mondrian at pentaho.org.

I found any issue open about measures returned in XMLA even if visible=false
http://jira.pentaho.com/browse/MONDRIAN-727. I guess I was fast on the
trigger.

Again, sorry for this post.

Manuel

On Fri, May 21, 2010 at 3:25 PM, Julian Hyde <jhyde at pentaho.com> wrote:

>  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].[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
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20100521/cba4e012/attachment.html