Saiku2.6 Saiku315 链接SQL的JDBC字符串

Saiku26

type=OLAP
name=CloudConn
driver=mondrian.olap4j.MondrianOlap4jDriver
location=jdbc:mondrian:Jdbc=jdbc:sqlserver://DESKTOP-6VF91N9:2433;databaseName=LANHAIV72;Catalog=res:saiku-datasources/FinSchema.xml;JdbcDrivers=com.microsoft.sqlserver.jdbc.SQLServerDriver;
username=sa
password=kingdee

Saiku315

type=OLAP
name=CloudConn
driver=mondrian.olap4j.MondrianOlap4jDriver
location=jdbc:mondrian:Jdbc=jdbc:sqlserver://DESKTOP-6VF91N9:2433;jdbc.databaseName = LANHAIV72;Catalog=mondrian:///datasources/FinSchema61.xml;JdbcDrivers=com.microsoft.sqlserver.jdbc.SQLServerDriver;
username=sa
password=kingdee
security.enabled=false

发现差异没:

 

databaseName = LANHAIV72

变成了

jdbc.databaseName = LANHAIV72

 

Catalog=res:saiku-datasources/FinSchema.xml;

变成了

Catalog=mondrian:///datasources/FinSchema61.xml;

 

修正,其实2.6的databaseName = LANHAIV72前面也要加jdbc.前缀,否则查询的时候会出现

尽管表是存在的

 

posted on 2019-03-06 22:55  Neo0820  阅读(271)  评论(0编辑  收藏  举报

导航