Knut Staring ha scritto: > Hi, > > You can test your cubes and queries with REX or Mondrian Workbench: > http://sourceforge.net/projects/whex
in order to use REX my connection URL must be that one in the datasources.xml file? |<URL>http://localhost:8080/mondrian/xmla</URL> It doesn't work on 8180 port! | > http://mondrian.pentaho.org/documentation/workbench.php > > Unfortunately, Tequila does not give very informative error messages > (just null pointers). We are actually in the process of removing the > dependency on Tequila for now (perhaps to be replaced later by another > ESB like Mule). > > Knut > > > On Tue, Nov 4, 2008 at 5:19 PM, Fabio D'Ovidio <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > When OH try to query my new cube (cubo2): > > http://127.0.0.1:8180/openhealth-fp/prototype/olap/query/cubo2?columns=[Prenotazioni].Members,[OK].Members&rows=[Data.Data].[Tutto],[Provincia.Province].[Tutte%20le%20Province]&aggregate=&filter=&slicer=&_dc=1225815268234 > > <http://127.0.0.1:8180/openhealth-fp/prototype/olap/query/cubo2?columns=%5BPrenotazioni%5D.Members,%5BOK%5D.Members&rows=%5BData.Data%5D.%5BTutto%5D,%5BProvincia.Province%5D.%5BTutte%20le%20Province%5D&aggregate=&filter=&slicer=&_dc=1225815268234> > > It seems to fetch data because all POST requests like > /levelmembers...., /members..... are done, > but on GET request the error is: > * INFO 17:14:28,250 > > cube=cubo2;columns=[Prenotazioni].Members,[OK].Members;columnsNonEmpty=null;rows=[Data.Data].[Tutto],[Provincia.Province].[Tutte > le > Province];rowsNonEmpty=null;aggregate=null;filter=null;slicer=null > (SimpleOlap.java [http-8180-1]) > * INFO 17:14:28,250 > > cube=cubo2;columns=[Prenotazioni].Members,[OK].Members;columnsNonEmpty=null;rows=[Data.Data].[Tutto],[Provincia.Province].[Tutte > le Province];rowsNonEmpty=null;aggregate=null;slicer=null > (SimpleOlap.java [http-8180-1]) > * INFO 17:14:28,250 Invoking generateMdxQuery with > > cube=cubo2;columns=[Prenotazioni].Members,[OK].Members;columnsNonEmpty=null;rows=[Data.Data].[Tutto],[Provincia.Province].[Tutte > le > Province];rowsNonEmpty=null;aggregate=null;filter=null;slicer=null > (MondrianOlapQueryProcessor.java [http-8180-1]) > * INFO 17:14:28,250 GenerateMdxQuery returns with value: SELECT > NON EMPTY > { > Crossjoin ({ > [Prenotazioni].Members} > ,{[OK].Members} > ) > } ON COLUMNS, > > NON EMPTY > { > Crossjoin ({ > > [Data.Data].[Tutto]} > ,{[Provincia.Province].[Tutte le Province]} > ) > } ON ROWS > FROM [cubo2] > (MondrianOlapQueryProcessor.java [http-8180-1]) > * INFO 17:14:28,250 Invoking executeMdxQuery with argument: SELECT > NON EMPTY > { > Crossjoin ({ > [Prenotazioni].Members} > ,{[OK].Members} > ) > } ON COLUMNS, > > NON EMPTY > { > Crossjoin ({ > > [Data.Data].[Tutto]} > ,{[Provincia.Province].[Tutte le Province]} > ) > } ON ROWS > FROM [cubo2] > (MondrianOlapQueryProcessor.java [http-8180-1]) > * INFO 17:14:29,218 ExecuteMdxQuery returns with value: null > (MondrianOlapQueryProcessor.java [http-8180-1]) > 4-nov-2008 17.14.29 org.apache.catalina.core.StandardWrapperValve > invoke > GRAVE: Servlet.service() for servlet tequila threw exception > java.lang.NullPointerException > at > > org.tequilaframework.core.web.view.renderer.StringRenderer.render(StringRenderer.java:53) > at > > org.tequilaframework.core.web.controller.TequilaDispatcher.handleRequest(TequilaDispatcher.java:112) > at > > org.tequilaframework.core.web.controller.integration.springmvc.SpringMVCTequilaController.handleRequestInternal(SpringMVCTequilaController.java:51) > at > > org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) > at > > org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) > at > > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:857) > at > > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:792) > at > > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:461) > at > > org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:416) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > at > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) > at > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) > at > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > at > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > at > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) > at > > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584) > at > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) > at java.lang.Thread.run(Thread.java:619) > > -- > Fabio D'Ovidio > Geospatial solutions > > INOVA s.r.l. > Web : http://www.inovaos.it > Tel.: 081 197 57 600 > mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > My new qury will be this one: > > browse.html?cube=cubo2&columns=[Prenotazioni].Members,[OK].Members&rows=[Data.Data].[Tutto],[Provincia.Province].[Tutte > le Province]&aggregate=&filter=&slicer= > > Knut Staring ha scritto: > > On Tue, Nov 4, 2008 at 12:45 PM, Fabio D'Ovidio > <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > <mailto:[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>>> wrote: > > Hello. > I want now to try change cube... > I change my cubes.xml and my DB connection in the following > files: > > * datasources.xml > * hibernate.properties > > what about the other xml files in /WEB-INF/calsses > directory such as > openhealth.xml? > > > openhealth.xml is just an old cube definition file. You > control the name of your cube definition file in datasources.xml. > > Knut > > > Thanks > > -- > Fabio D'Ovidio > Geospatial solutions > > INOVA s.r.l. > Web : http://www.inovaos.it > Tel.: 081 197 57 600 > mail: [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> > > _______________________________________________ > Dhis-users mailing list > [email protected] <mailto:[email protected]> > <mailto:[email protected] <mailto:[email protected]>> > http://www.hisp.info/mailman/listinfo/dhis-users > > > > > -- > Cheers, > Knut Staring > > ------------------------------------------------------------------------ > > _______________________________________________ > Dhis-users mailing list > [email protected] <mailto:[email protected]> > http://www.hisp.info/mailman/listinfo/dhis-users > > > > -- > Fabio D'Ovidio > Geospatial solutions > > INOVA s.r.l. > Web : http://www.inovaos.it > Tel.: 081 197 57 600 > mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > > _______________________________________________ > Dhis-users mailing list > [email protected] <mailto:[email protected]> > http://www.hisp.info/mailman/listinfo/dhis-users > > > > > -- > Cheers, > Knut Staring > ------------------------------------------------------------------------ > > _______________________________________________ > Dhis-users mailing list > [email protected] > http://www.hisp.info/mailman/listinfo/dhis-users > -- Fabio D'Ovidio Geospatial solutions INOVA s.r.l. Web : http://www.inovaos.it Tel.: 081 197 57 600 mail: [EMAIL PROTECTED] _______________________________________________ Dhis-users mailing list [email protected] http://www.hisp.info/mailman/listinfo/dhis-users
