techs_massage Posted November 28, 2006 Share Posted November 28, 2006 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! Link to comment Share on other sites More sharing options...
techs_massage Posted November 28, 2006 Author Share Posted November 28, 2006 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now