way to generate a schema for olap?

[techs_massage]

Hi - I have JasperIntelligence running and have created a cube to access through an olap view. I have manually built the schema file that Jasper asks for, but was wondering if there is a way to have the schema file generated automatically somewhere to avoid any typos. I am currently using Microsoft Analysis Services to create my cubes and I am getting an error when I try to create my MDX query for the olap view. The error reads that it cannot find [Measures].[Pototal] in my cube.

 

It does however exist in the cube so I'm thinking maybe my schema file is typed wrong somewhere.

 

Thank you!

[techs_massage]

I have found a great site that explains schemas step by step and have created what I know is a good schema now. The site is here: http://mondrian.pentaho.org/documentation/schema.php#What_is_a_schema

 

I am still wondering if there is a tool that can create a good schema automatically from an existing cube.

Post edited by: techs_massage, at: 2006/12/02 13:55