参考原文，略作修改：http://www.cnblogs.com/avivaye/p/4881106.html
以上链接文章的思路是正确的，有略微的遗漏，saiku-beans.properties中也存在与用户相关的H2数据库配置，并且在id为“userDaoDataSource”的bean中有用到，为了避免出现问题，将其一并替换，并修改原文中部分配置到配置文件中
<code class="hljs"><context-<span class="hljs-built_in">param</span>> <<span class="hljs-built_in">param</span>-name>db.url</<span class="hljs-built_in">param</span>-name> <<span class="hljs-built_in">param</span>-<span class="hljs-built_in">value</span>>jdbc:h2:../../data/saiku;MODE=MySQL</<span class="hljs-built_in">param</span>-<span class="hljs-built_in">value</span>> </context-<span class="hljs-built_in">param</span>> <context-<span class="hljs-built_in">param</span>> <<span class="hljs-built_in">param</span>-name>db.user</<span class="hljs-built_in">param</span>-name> <<span class="hljs-built_in">param</span>-<span class="hljs-built_in">value</span>>sa</<span class="hljs-built_in">param</span>-<span class="hljs-built_in">value</span