Post reply

USE MDX Query without using Linked Server- OpenQuery

  • January 9, 2015 at 6:30 am

    #150260

    Using Linked Server the query is taking too long to retrieve data. Is there any alternative way to hit

    the OLAP Cube. So that I can write directly a storedProcedure and retrieve the data directly from SSMS (SQL Server Management Studio box).

    Thanks and awaiting for response.

    VD

  • January 9, 2015 at 6:36 am

    #1769053

    my first google for "linked server analysis servers" looked good to me,: they both showed examples of crating the linked server and the open query command as well.

    select * from openquery(AdventureWorksOLAP, 'select [Measures].[Sales Amount] on columns from [Adventure Works]')

    http://sqlblog.com/blogs/stacia_misner/archive/2010/11/30/31193.aspx

    http://support.microsoft.com/kb/218592

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 12, 2015 at 12:42 am

    #1769406

    Thanks Lowell , but I am getting below error while executing the query.

    "Ad Hoc queries are not allowed to be execute directly".

    I don't know weather SQL Server provides any good way to do it.

    i referred the below link as well.

    http://blog.bansheetechnologies.co.uk/2009/02/ad-hoc-access-to-ole-db-provider-has.html

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

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