This forum is no longer active. Please post your questions to our new community site

Forums → JasperServer →

Error in MDX query

Subscribe to Error in MDX query 1 post, 1 voice

 
14 Jul, 2009 06:32 AM
Avatar retail 9 post(s)

Hi,

Can anyone tell me what is the problem with this MDX query:

select {[Measures].[Marks]} ON COLUMNS,
NON EMPTY Crossjoin(Hierarchize({[Department],[Student]})) ON ROWS
from [Student Analysis]

The error I got for this MDX query in jasper server version 2.1 is :
The following is not a valid MDX Query: Mondrian Error:All arguments to function ‘{}’ must have same hierarchy.
I used this schema:

<?xml version=“1.0”?>

<!-- Shared dimensions -->

<Table scheme =“College” name=“College”/> <Table scheme =“College” name=“Department”/> <Table scheme =“College” name=“Student”/> <Table scheme =“College” name=“Student”/>

<!-- <CalculatedMember name="Variance Percent" dimension="Measures" formula="([Measures].[Variance]/[Measures].[Budget])*100" /> -->

My Table Details:
Student table use CollegeCode and DeptCode as foreign Key
College table and Department Table are individual tables.
Forums → JasperServer →