We came across a similar type of an issue and used Modrian (Pentahoe BI) as the OLAP server. This is free and open source. It should provide you access to the OLAP cube from your VB code since Mondrian is also based on XMLA. Front end, as far as browsing the cube and running live mdx queries are concerned, you will need to come up with some solution (actually we are currently developing and integrating the capability to our own BI tool). But we were successful using Mondrian on a web based solution.
We (www.icCube.com) got a customer with similar setup regarding the data (volume and postgres).
Regarding the front-end and access via .Net: we're not specialist (we're from JAVA) but the OLAP driver (actually the same used by Excel) should be ok to access our cube via XMLA (and transparent for your programmers).
We're not free but I guess quite affordable compared to the big names in the BI market.
发布评论
评论（2）
我们遇到了类似的问题，并使用 Modrian (Pentahoe BI) 作为 OLAP 服务器。这是免费且开源的。它应该允许您从 VB 代码访问 OLAP 多维数据集，因为 Mondrian 也基于 XMLA。前端，就浏览多维数据集和运行实时 mdx 查询而言，您将需要提出一些解决方案（实际上我们目前正在开发该功能并将其集成到我们自己的 BI 工具中）。但我们在基于网络的解决方案上成功地使用了蒙德里安。
We came across a similar type of an issue and used Modrian (Pentahoe BI) as the OLAP server. This is free and open source. It should provide you access to the OLAP cube from your VB code since Mondrian is also based on XMLA. Front end, as far as browsing the cube and running live mdx queries are concerned, you will need to come up with some solution (actually we are currently developing and integrating the capability to our own BI tool). But we were successful using Mondrian on a web based solution.
我们 (www.icCube.com) 的一位客户在数据（卷和 postgres）方面具有类似的设置。
关于前端和通过 .Net 的访问：我们不是专家（我们来自 JAVA），但是 OLAP 驱动程序（实际上与 Excel 使用的相同）应该可以通过 XMLA 访问我们的多维数据集（并且对您的程序员来说是透明的） ）。
我们不是免费的，但我想与 BI 市场上的知名品牌相比，我们的价格相当实惠。
We (www.icCube.com) got a customer with similar setup regarding the data (volume and postgres).
Regarding the front-end and access via .Net: we're not specialist (we're from JAVA) but the OLAP driver (actually the same used by Excel) should be ok to access our cube via XMLA (and transparent for your programmers).
We're not free but I guess quite affordable compared to the big names in the BI market.