Hi there,

I have a SSAS project which its data is relevant to be accessed from a
strored procedure in T-SQL, SQL Server Transactional Database.

My approach was to extend SQL Server Transactional Database stored
procedures with CRL, in which by using ADOMD.NET I would access and
retrieve the information I needed.

Is this a good approach, can anyone give me a clue of how can I do
this?

Tks.
Pedro Ávila

Try linked server



EXEC master.dbo.sp_addlinkedserver @server = N'OLAP_LT',
@srvproduct=N'Analysis Services 2005', @provider=N'MSOLAP',
@datasrc=N'xxx.xxx.xxx.xxx', @catalog=N'LT'



Ramunas

"pavila" <pedro.avila (AT) wissefinancial (DOT) com> wrote

Hi there,

I have a SSAS project which its data is relevant to be accessed from a
strored procedure in T-SQL, SQL Server Transactional Database.

My approach was to extend SQL Server Transactional Database stored
procedures with CRL, in which by using ADOMD.NET I would access and
retrieve the information I needed.

Is this a good approach, can anyone give me a clue of how can I do
this?

Tks.
Pedro Ávila

Hi,

Thank you for your tip.
However, since OPENQUERY doesn't support variables on its arguments I
will not be able to use it whenever a variable, like a time period, is
intended to be sent in the MDX query.

I've been struggling with assymetric keys, and all around it, to have
the SQL Server accessing the Analysis Server.

Any clue is welcome.
Tks.



Ramunas Balukonis escreveu: