How to hide rows in analysis view -JasperServer CE

[maxirenna]

Hi,

I’m using jasperserver Community Edition and I Want to hide the rows where “all” are shown (those that are marked in yellow in the picture below), because it modify the scale of my graph (the result i really want to show don’t take them into account).

Could you help me?

Some additional information in Code Section.

Code:

Cube<Cube name="Lotes" cache="true" enabled="true">    <Table name="fact_lotes">    </Table>    <Dimension type="StandardDimension" foreignKey="articulo_id_articulo" name="articulo">     <Hierarchy hasAll="true" primaryKey="id_articulo">       <Table name="articulo">       </Table>       <Level name="articulo" column="nombre" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">       </Level>     </Hierarchy>    </Dimension>    <Dimension type="StandardDimension" foreignKey="subrubro_id_subrubro" name="subrubro">     <Hierarchy hasAll="true" primaryKey="id_subrubro">       <Table name="subrubro">       </Table>       <Level name="subrubro" column="nombre" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">       </Level>     </Hierarchy>    </Dimension>    <Dimension type="TimeDimension" foreignKey="tiempo_id_tiempo" name="Tiempo">     <Hierarchy hasAll="true" allMemberName="All Periods" primaryKey="id_tiempo">       <Table name="tiempo">       </Table>       <Level name="Anio" column="anio" type="Numeric" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">       </Level>       <Level name="Cuatrimestre" column="trimestre" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">       </Level>       <Level name="Mes" column="mes" type="Numeric" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">       </Level>     </Hierarchy>    </Dimension>    <Measure name="Cantidad" column="cantidad" datatype="Integer" aggregator="count">    </Measure>    <Measure name="Volumen Compra" column="volumenCompa" datatype="Numeric" formatString="#,###.00" aggregator="sum">    </Measure>    <Measure name="Dias Entre Compra" column="prom_dias_entre_compra" datatype="Numeric" aggregator="avg">    </Measure> </Cube>MDX Queryselect {[Measures].[Cantidad],       [Measures].[Volumen Compra],       [Measures].[Dias Entre Compra]} ON COLUMNS,       {([subrubro],[articulo],[Tiempo])} ON ROWS  from   [Lotes]

[mespub]

hi,

 

you have to specify for the hierarchy in your schema :

hasAll="false"

 

regards

[maxirenna]

Thanks for your answer,

but it's possible to hide that bar ('all') in the graph, and continue having it into the table? because i need the group but i don't want to show the bar to keep the scale of the graph.

Thanks again,