Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  LINKSERVER issues

Author  Topic  Digital Starting Member 8 Posts Posted - 2009-03-24 : 12:20:36 hi it set up a linkserver and its not letting me execute mdx code that i know works ERROR: LINKSERVER NAME: CUBESERVER2 Msg 7321, Level 16, State 2, Line 1 An error occurred while preparing the query "WITH MEMBER [measures].ViewBySelect AS "TOPCOUNT([Dim Venue].[Tier].[Tier].ALLMEMBERS,10000,[Measures].[Net Revenue])" SELECT NON EMPTY { [Measures].[Net Revenue], [Measures].[Actual Mins], [Measures].[Sessions]} ON COLUMNS, NON EMPTY {(STRTOSET("[Dim Date].[" + "Month" + "].[" + "Month" + "].ALLMEMBERS") * STRTOSET(ViewBySelect) )} ON ROWS FROM (SELECT ( STRTOSET ("{[Dim Date].[" + "Month" + "].&[" + "200806" + "]:[Dim Date].[" + "Month" + "].&[" + "200806" + "]}"),STRTOSET ("[Dim Service Provider].[Service Provider Full].[All]"),STRTOSET ("[Dim Venue].[Tier].[All]"),STRTOSET ("[Dim Venue].[Country Grouping].[All]"),STRTOSET ("[Dim Venue].[Country].&[Norge]"),STRTOSET ("[Dim Venue].[Vertical].[All]"),STRTOSET ("[Dim Venue].[Venue Type].[All]"),STRTOSET ("[Dim Venue].[Owner Name Full].[All]"),STRTOSET ("[Dim Venue].[City].[All]"),STRTOSET ("[Dim Venue].[Venue Name Full].[All]"), -{ [Dim Billing].[Billing Class Short].&[wo] } ) ON COLUMNS FROM [Cloud DWH Cube] ) WHERE ( [Dim Date].[Calendaryear].&[2008] )" for execution against OLE DB provider "MSOLAP" for linked server "CUBESERVER2". Digital