MDX query works in WorkBench not in JasperServer

[fostermj]

Hello - I'm a newbie and, The following MDX query works in my Jasper Workbench, but not in JasperServer (yes, I've reloaded everything too).

SELECT {[Measures].[Quantity], [Measures].[sales]} ON COLUMNS,
{([Channel], [Product Category])} ON ROWS
FROM [Channels]

The following is my Schema - Can someone find my error?

- <Schema name="MJ2">

- <Cube name="Channels" cache="true" enabled="true">

  <Table name="PIECE_TYPE_AGG1" schema="CHRIS" />

- <Dimension type="StandardDimension" foreignKey="ORDER_TYPE_ID" name="Channel">

- <Hierarchy hasAll="true" allMemberName="All Channels" primaryKey="ORDER_TYPE_ID">

  <Table name="ORDERS" schema="CHRIS" />

  <Level name="Channel Descr" column="ORDER_TYPE_ID" type="Numeric" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" />

  </Hierarchy>

  </Dimension>

- <Dimension type="StandardDimension" foreignKey="PROD_CATEGORY_ID" name="Product Category">

- <Hierarchy hasAll="true" allMemberName="All Prod Categories" primaryKey="PROD_CATEGORY_ID">

  <Table name="PRODUCT_CATEGORY" schema="CHRIS" />

  <Level name="Prod Category Descr" column="DESCR" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" />

  </Hierarchy>

  </Dimension>

  <Measure name="Quantity" column="QTY" aggregator="sum" visible="true" />

  <Measure name="Sales" column="SALES" aggregator="sum" visible="true" />

  </Cube>

  </Schema>

 

[swood]

You don't say what the error is.

 

Did you see the answers here http://jasperforge.org/projects/jasperserver/tracker/view.php?id=4247 ?

 

have you tried the new release candidate?

 

Sherman

Jaspersoft