ORM 之于 RDBMS 就像 xxx 之于 OLAP 多维数据集一样？ xxx存在吗？
是否有用于查询 OLAP 多维数据集/数据仓库的 ORM 类似物？ 我对 .NET 世界特别感兴趣，但一般对任何事物都感兴趣；-)
Is there an ORM-analogue for querying OLAP cubes / data-warehouses? I'm specifically interested in the .NET world, but generally interested in anything ;-)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我启动了一个开源项目 Kona 来包装 ADOMD.Net 库，并尝试将 ADOMD.Net 引入 21 世纪。 您可以在 http://www.codeplex.com/kona 获取它，但它确实需要更多的爱和关注。
将 lambda 转换为 MDX 的任务并不小，所以我还没有尝试过这样做。 我试图鼓励 MSFT 编写 LINQ to MDX 提供程序，但考虑到很少有 .Net 开发人员实际上尝试使用 OLAP/SSAS（在 SSRS 空间之外），我认为它不会受到任何人的欢迎。目前的优先列表。 但这并不意味着停止尝试。 我一直在本地用户组和代码训练营中进行“.Net Guy 的 BI”演讲，试图传播这种爱。
I've started an open source project, Kona, to wrap the ADOMD.Net lib, and try to bring ADOMD.Net into the 21st Century. You can get it up at http://www.codeplex.com/kona, but it does need some more love and attention.
The task of converting lambdas to MDX isn't a small one, so I haven't even tried to to that, yet. I've tried to encourage MSFT to write a LINQ to MDX provider, but considering how few .Net developers are actually trying to work with OLAP/SSAS (outside of the SSRS space), I don't think it will be high on anyone's priority list at the moment. But that doesn't mean to stop trying. I've been doing my "BI for the .Net Guy" talk at the local user groups and Code Camps, trying to spread the love.
ADOMD 会让您自己动手。 我还没有看到任何好的库可以在其上运行并为结果集提供简单的 API，也许是由于 Analysis Services 和 MDX 的性质？
http://msdn.microsoft.com/en-us/library/ms123483。 aspx
我一直在寻找更好的方法，所以如果有人有任何解决方案，我会洗耳恭听。 目前，为了快速开发，我使用 SQL Server 通过链接服务器将 MDX 查询发送到 SSAS，然后将其作为存储过程输出从 SQL Server 返回，因为任何人都可以处理它。 我遇到的问题是缺乏调试，如果行丢失就会出错，所以 TRY/CATCH 特定的错误号，如果没有则重新抛出。
ADOMD will let you roll your own. I haven't seen any good libraries that sit on it and provide an easy API for result sets, perhaps due to the nature of Analysis Services and MDX?
http://msdn.microsoft.com/en-us/library/ms123483.aspx
I've looked for better, so I'm all ears if anyone has any solutions. Currently for quick development I'm using SQL Server to send MDX queries through a linked server to SSAS, then returning that as stored procedure output from SQL Server, as anyone can then deal with that. Problems I encountered were the lack of debugging, and if the rows are missing it errors, so TRY/CATCH for specific error numbers and a rethrow if not.