From the Desktop ElastiCube Manager you can call a SQL Server Stored Procedure (with or without parameters)
Step One:
Configure for ad hoc distributed queries on the SQL Server Instance
exec sp_configure 'show advanced options', 1;
RECONFIGURE;
exec sp_configure 'Ad Hoc Distributed Queries', 1;
RECONFIGURE;
GO
Step Two:
Include a Linked Server to itself
EXEC sp_addlinkedserver @server=’localhost’, @srvproduct=’SQL Server’;
EXEC sp_addlinkedsrvlogin
@rmtsrvname=’localhost’,
@useself=’FALSE’,
@rmtuser = ‘admin’,
@rmtpassword = ‘admin’;
Step Three:
Enable remote connections and SQL browser
Now you should be able to use an OPENQUERY in the ElastiCube - for instance, I tested this against the AdventureWorks database...
SELECT * FROM OPENQUERY
(localhost,'SET FMTONLY OFF; exec [AdventureWorks2014].[dbo].[uspGetEmployeeManagers] "3";')
