在本地多维数据集上执行 mdx 和 sql 查询
我试图从本地多维数据集获取一系列 ID，以摆脱动态安全性，但我似乎不知道如何做到这一点。我尝试过 openquery，但是当我尝试时，我收到一个错误，该错误
对于链接服务器“coop3-t3500”不是很有用 OLE DB 提供程序“SQLNCLI10”返回消息“语法错误、权限冲突或其他非特定错误”。
消息 7321，级别 16，状态 2，第 2
行 准备查询时发生错误
我尝试运行的查询是这样的：
SELECT * FROM dbo.table WHERE ID IN (SELECT * FROM openrowset([servername], MDX query)
我是否做错了什么，或者有更好的方法来执行此操作？
I am trying to get a series of ids from a local cube to piggy back off of the dynamic security, however I can't seem to figure out how to do this. I have tried openquery, but when I try that I get an error that is not very useful
OLE DB provider "SQLNCLI10" for linked server "coop3-t3500" returned message "Syntax error, permission violation, or other nonspecific error".
Msg 7321, Level 16, State 2, Line 2
An error occurred while preparing the query
The query I am trying to run is something like this:
SELECT * FROM dbo.table WHERE ID IN (SELECT * FROM openrowset([servername], MDX query)
Is there something I am doing wrong, or a better way to do this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我刚刚让它工作，看来因为我在 SSAS 服务器上有两个分析服务项目，所以它只连接到第一个。
I just got it to work, it appears that because I had two analysis services project on the SSAS server, it was only connecting to the first one.