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,

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]

Thank you for you answer, I could resolve it by making all conections and data source again.

Hi, I have recently start using jaspersoft community edition and i have a problem, I finished my OLAP cube (with workbench) and i have already filled the database with data using ETL, when I test an MDX Query using workbench, it works correctly. My problem starts when I want to run an Analysis View that I created using the same cube, and the same mdx Query. I get this mistake.. com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: java.security.PrivilegedActionException: com.sun.xml.internal.messaging.saaj.SOAPExceptionImpl: Bad response: (401No Autorizado I guess it's related to security but I don't know how to solve it Thanks,