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">

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.