Jasper analysis:Exception while drilling down.

[syntel]

 

 

Hi ,

I am trying to create an analysis view with JasperServer 2.1 version.I am able to open my analysis view but when I try to drill down I am getting the below mentioned exception.

Code:

 

 

My Schema file and MDX query are as follows,for your information:

 

Schema:

<?xml version="1.0"?>

 

<Schema name="CollegeSchema">

<!-- Shared dimensions -->

<Dimension name="College">

<Hierarchy hasAll="true" allMemberName="All Colleges" primaryKey="CollegeCode">

<Table scheme ="College" name="College"/>

<Level name="College" column="CollegeName" uniqueMembers="true"/>

</Hierarchy>

</Dimension>

<Dimension name="Department">

<Hierarchy hasAll="true" allMemberName="All Departments" primaryKey="DeptCode">

<Table scheme ="College" name="Department"/>

<Level name="Department" column="DeptName" uniqueMembers="true"/>

</Hierarchy>

</Dimension>

<Dimension name="Student">

<Hierarchy hasAll="true" allMemberName="All Students" primaryKey="StudentId">

<Table scheme ="College" name="Student"/>

<Level name="Students" column="StudentName" uniqueMembers="true"/>

</Hierarchy>

</Dimension>

<Cube name="Student Analysis">

<Table scheme ="College" name="Student"/>

<DimensionUsage name="College" source="College" foreignKey="CollegeCode"/>

<DimensionUsage name="Department" source="Department" foreignKey="DeptCode" />

<DimensionUsage name="Student" source="Student"/>

<Measure name="Marks" column="Mark" aggregator="sum" formatString="#,###.00"/>

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

</Cube>

</Schema>

 

 
 

 

MDX Query:

Select {[Measures].[Marks]} ON COLUMNS,

{([College],[Department],[student])} ON ROWS

from [student Analysis]

 

Any help please?

 

Thanks.

 

 

Post Edited by syntel at 07/13/2009 13:44

[jfields]

I have the same issue, and don't have an answer on how to fix.

Some notes that i have learned though.

1.  Per cube, try not to exceed more than 16 dimensions.  JS cant handle it.

2. Make sure dimensions to fact table are all indexed.

Doing both of those and monitoring the database for 'hung threads' has gotten this error to occur less often.

We see it most often when the db gets stressed more and it seems like the query returns no data and you get the 'results' error.

 

That is all I have learned about this error.

Maybe some of my knowledge will help.

Jeremy

[kumarsrs]

I also got the same error  when i use the MDX Query as

SELECT
[Measures].AllMembers ON COLUMNS,
Hierarchize(([Dim_Curr].[All Dim_Currs].Children * [Dim_Name].[All Dim_Names].Children)) ON ROWS
FROM [sales]

then i changed the MDX Query  as

select {[Measures].[invoiced_Amount], [Measures].[Qty_Ordered]} ON COLUMNS,
  Hierarchize(([Dim_Curr].[All Dim_Currs].Children * [Dim_Name].[All Dim_Names].Children)) ON ROWS
from [sales]
 

I can  view the analyis, but  drill is not shown.