invalid MDX query?

[arpoodle]

I get the following error when trying to create an analysis view on jasperserver pro.

The following is not a valid MDX Query: Internal error: while parsing catalog repo:/corp/analysis_reports/analysis_schema

The same MDX query works fine, without error, in the schema workbench.

I've also tried deleting and re-importing the datasource, OLAP schema and client connection in case something was corrupted or broken in there.

The query is as  follows..

SELECT
{[Measures].[commission]} ON COLUMNS,
{[user].[all users]} * {[instrument name].[all instruments]} * {[time].[all time]} ON ROWS
FROM [commission_cube];

Is there anything obvious that I'm missing here?

tia

a

[swood]

Can you show the full stack trace? The error seems to be in the actual schema.

 

What version of JS Pro are you running?

 

Sherman

Jaspersoft

[chiptampa]

Code:

I also have the same problem.  Here is my error message:



The following is not a valid MDX Query: Internal error: while parsing catalog repo:/analysis/schemas/TIFix



I can create and modify the MDX query against my own Foodmart Mondrian connection, but not against my own mondrian schema.



I am using a SQL Server database, and I can verify that the analysis connection is good.  I tested the SQL version of the query under the SQL Server user using SSMS.  I can load the mondrian schema.



Here is my schema and query:



<Schema>

<Cube name="WorkOrderActivityFact">

<Table name="WorkOrderActivityFact"/>

<Dimension name="PriorityDim" foreignKey="PriorityDimId">

<Hierarchy hasAll="true" allMemberName="All Priorities" primaryKey="PriorityDimId">

<Table name="PriorityDim"/>

<Level name="Priority" column="Priority" uniqueMembers="true"/>

</Hierarchy>

</Dimension>

<Measure name="NewWorkOrderCount" column="NewWorkOrderCount" aggregator="sum" formatString="#,###"/>

<Measure name="ClosedWorkOrderCount" column="ClosedWorkOrderCount" aggregator="sum" formatString="#,###"/>

</Cube>

</Schema>



MDX Query

select {[Measures].[NewWorkOrderCount]} on columns from [WorkOrderActivityFact]



The following SQL query returns results against my database with the database user "jasper" that I defined in the connection. I am showing this in lieu of providing the tables and data.





SELECT SUM(NewWorkOrderCount) AS New

FROM WorkOrderActivityFact

JOIN PriorityDim ON WorkOrderActivityFact.PriorityDimId = PriorityDim.PriorityDimId



There must be something wrong with my schema?  I saved it both with DOS and Unix line endings to eliminate that.

[chiptampa]

Code:

My simple example is now working.  I included an XML comment, and I provided a name attribute for the schema XML element.  I am not sure that this is what is needed, but it was the last thing I did and I got success.  Anyway, don't waste your time fixing my problem, I am working. 



<?xml version="1.0"?>

<Schema name="TIStarSchemaFix">