OpenQery上的TDS03006 - 如何让GDR忽略这一点？ [英] TDS03006 on an Openquery -- how can I get the GDR to ignore this?

问题描述

我刚刚将一系列2008数据库导入GDR，直至我的LAST编译错误。 我有一个视图，其中包含对本地SSAS多维数据集的openquery链接服务器调用。 在此视图中，我使用OPENQUERY将MDX查询包装到
允许查询多维数据集，就好像它是本地SQL表一样。 问题是我得到了一个"未解决的参考"。从GDR编译错误。 我无法创建对多维数据集的数据库引用，因此无法进行编译。 我尝试将
欺骗它，将其编码为$（SSAS_LOCAL）并指向指向MSDB的数据库引用（由$（SSAS_LOCAL）别名），但它仍然不起作用。 

I've just imported a series of 2008 databases into the GDR and am down to my LAST compile error.  I have a view that contains an openquery linked server call to a local SSAS cube.  In this view, I wrap an MDX query using OPENQUERY to allow for querying the cube as if it was a local SQL table.  The problem is that I get an "unresolved reference" compile error from the GDR.  I can't create a database reference to a cube, so I can't get this to compile.  I tried to trick it by coding this as $(SSAS_LOCAL) and pointing to a database reference pointing to MSDB (aliased by $(SSAS_LOCAL)), but it still doesn't work. 

是否开放给GDR支持的链接服务器？ 如果是这样，我如何解析/忽略指向非SQL数据库的数据库链接？

Is OPENQUERY to a linked server supported by the GDR?  If so, how do I resolve/ignore the database link that's pointing to a non-SQL database?

谢谢！

 

SELECT

...

...

FROM OPENQUERY

FROM OPENQUERY

 

 

（SSAS_LOCAL， '

(SSAS_LOCAL, '

 

SELECT

...

FROM< cube>

'）

推荐答案

我也遇到了同样的问题。如果有任何帮助我会很感激。

I'm having the same problem as well. Would appreciate any help on how to resolve it.

谢谢。

这篇关于OpenQery上的TDS03006 - 如何让GDR忽略这一点？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！