Post reply

Creating an SP for MDX using openquery

  • May 17, 2012 at 4:38 am

    #261158

    I've been tasked with writing an SP for some MDX currently residing in SSRS. Have come across a few issues:

    SSAS and SQL server are both of the same physical instance of a server, openquery does not seem to like this.

    Obviously I can create a linked server but it's the same place - and it complains to this end.

    Is it possible to do this? Should I be even attempting to do this? 😀

  • May 17, 2012 at 7:53 am

    #1489027

    Well, there's no fundamental barrier to creating an SSAS linked server to the same server as the RDBMS instance, you just have to give the linked server a different name, but this sounds a bit pointless. SSRS already has a direct connection to SSAS, but you want to send it via the Database Server and through a linked server?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply