有没有人有蒙德里安和Kylin之间联系的有效例子?我发现mondrian上的独特版本可以在github上的这个报告中找到,它可以独立运行,远离pentaho/saiku的其他东西。
因此,我下载了war并将其移动到tomcat的webapps目录中,然后按照本网站的建议升级了一些jar。
问题是似乎什么都不管用。
我将数据源定义如下:
数据源-\kylin.xml
<?xml version="1.0"?>
<!--
http://mondrian.pentaho.com/documentation/installation.php#5_1_Describe_the_data_sources_in_datasources.xml
-->
<DataSources>
<DataSource>
<DataSourceName>test</DataSourceName>
<DataSourceDescription>test from kylin</DataSourceDescription>
<URL>http://localhost:8080/xmondrian/xmla</URL>
<DataSourceInfo>Provider=mondrian; Jdbc=jdbc:kylin://192.168.127.100:7070/Luca_test; JdbcDrivers=org.apache.kylin.jdbc.Driver; JdbcUser=ADMIN; JdbcPassword=KYLIN</DataSourceInfo>
<ProviderName>Mondrian</ProviderName>
<ProviderType>MDP</ProviderType>
<AuthenticationMode>Unauthenticated</AuthenticationMode>
<Catalogs>
<Catalog name="test">
<Definition>/WEB-INF/schema/test.xml</Definition>
</Catalog>
</Catalogs>
</DataSource>
</DataSources>
test.xml(模式)
<?xml version="1.0"?>
<Schema name="schema qualcosa" description="ancora di +" measuresCaption="bho" defaultRole="non lo so">
<Cube name="il nome del cubo" caption="non ho idea di cosa possa essere" visible="true" description="come sopra + esteso" cache="false" enabled="true">
<Table name="SAK_FACT_TRANSACTIONS" schema="UNIFIEDDATA_WORK" alias="transaction">
</Table>
<Dimension type="StandardDimension" visible="true" foreignKey="PRICE" name="SAK_FACT_TRANSACTIONS_PRICE">
</Dimension>
<Measure name="price" column="PRICE" datatype="Numeric" aggregator="sum" formatter="$#,##0.00" description="price come sopra" visible="true">
</Measure>
</Cube>
</Schema>
tomcat日志显示:
10:06:06,331 ERROR [XmlaServlet] Errors when handling XML/A message
mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover unparse results error
at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2904)
at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:671)
at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:507)
at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:318)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
at mondrian.olap.Util.readURL(Util.java:3243)
at mondrian.server.UrlRepositoryContentFinder.getContent(UrlRepositoryContentFinder.java:44)
at mondrian.server.FileRepository.getServerInfo(FileRepository.java:236)
at mondrian.server.FileRepository.getConnection(FileRepository.java:117)
at mondrian.server.MondrianServerImpl.getConnection(MondrianServerImpl.java:262)
at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:2976)
at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:177)
at mondrian.xmla.Rowset.populate(Rowset.java:219)
at mondrian.xmla.Rowset.unparse(Rowset.java:194)
at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2898)
... 27 more
该模式已验证到工作台模式中。任何帮助都将受到感激和欢迎。任何帮助。
暂无答案!
目前还没有任何答案,快来回答吧!