--sp_configure 'show advanced options', 1

--RECONFIGURE

--sp_configure 'Ad Hoc Distributed Queries', 1

--RECONFIGURE

sp_configure 'show advanced options',1
reconfigure with override
go
sp_configure 'Ad Hoc Distributed Queries',1
reconfigure with override
go

DECLARE

 

@RC int

DECLARE

 

@DateMonths nvarchar(max)

DECLARE

 

@RetentionVehicleRetentionVehicles nvarchar(max)

-- TODO: Set parameter values here.

EXECUTE

 

@RC = [acumen].[dbo].[ssrsWap]

 

 

' [Date].[Months].[Month].&[201001],

[Date].[Months].[Month].&[201002],

[Date].[Months].[Month].&[201003],

[Date].[Months].[Month].&[201004],

[Date].[Months].[Month].&[200912],

[Date].[Months].[Month].&[200911]'

 

,'

[Retention Vehicle].[Retention Vehicles].[Advertise Detail].&[304850],

[Retention Vehicle].[Retention Vehicles].[Advertise Detail].&[304849]

'

 'MSOLAP', 'Datasource='datasource'; Initial Catalog= 'cubedb',