question

dfswart avatar image
dfswart asked

Linked Server/Open Query

I created a Linked server to Analysis Services. This has got more than one "Database". In the create I only specified one in the @Catalogu statement, but it brought all the "databases" ss csatalogues in the Server. ***Script to create Linked Server*** EXEC sp_addlinkedserver @Server = 'AW' ,@srvproduct = '' ,@provider='MSOLAP' ,@datasrc ='LocalHost' ,@catalog='Adventure Works DW 2008R2' ***Results:*** AW Catalogs System Catalogs Adventure Works DW 2008R2 GT_BSC GT_Time As you can see there is other databses (GT_Bsc & GT_Time). How can I access cubes from these database (eg specify catalog) via open query, If I sepcify the the cube name it tells me it can not find the cube. Or do i need to change something when createing the Linked server?
linked-serverlinked
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Usman Butt avatar image
Usman Butt answered
I guess you need to have separate linked servers for each. OR as an alternative, try using OPENROWSET.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Pavel Pawlowski avatar image Pavel Pawlowski commented ·
+1 As @Usman Butt wrote, you have to create separate linked server for each SSAS Database to be able to use OPENQUERY to EXECUTE an MDX against cubes from particular database. The open query executed the MDX only against the DefaultCatalog which you ahve specified in the Create Linked Server.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.