ERROR EXECUTING XMLA WHILE IMPLEMENTING PROJECT REAL BI

Hi all,

I didnot find any other forum to post this problem. I am facing an problem while trying to implement the PROJECT REAL BI.

I was trying to implement the PROJECT REAL but facing an error. After attaching the mdf : REAL_Source_Sample_V6 and REAL_Warehouse_Sample_V6 when I try to execute the XMLA Script “REAL Warehouse Sample V6 MT.xmla” i am getting an error "Object Reference not set to an instance of object ( ConnectionDlg)". Can you tell me why this error comes. I am using SQL SERVER 2005 SP 2. You can ping me at girija45701@.yahoo.com...

Thanks in advance...

In Sql Server Management Studio

01. Select tools --> Options

02. Select File Extension under text editor on the left side panel.

03. In the right side panel Add XMLA in the Extension box and select XMLA Query Editor from the drop down list.

04. Click on the 'Add' button.

05. Close and restart Sql Server Management Studio.

By mapping the extension to an editor, the SSMS will know which Engine/parser to use.

regards.

Error executing User Defined function on another server

Hi All,
Facing a problem while executing a user defined function (UDF) which resides
on another sql server ( we have access on this sql server to execute the
UDF). This UDF accepts a varchar parameter with max length 8. When we
execute the function as
Select * from
SERVERNAME.DBName.dbo. fn_GetConsulteesDataForReport('00118179'
) it throws an
error as given below.
Server: Msg 170, Level 15, State 31, Line 1
Line 2: Incorrect syntax near '('.
Please let me know what is the issue in my SQL statement and how we can
resolve this.
Thanks in advance.
SuhasThere's a workaround for this hm... feature. Use the OPENQUERY function:
select *
from openquery(SERVERNAME, '
select *
from
DBName.dbo. fn_GetConsulteesDataForReport('00118179'
)
')
ML
http://milambda.blogspot.com/|||Hi ML,
Thank you for giving this suggestion. But please let me know whether open
query does accept variable as an input to the function ? I mean, can I
execute the same as given below.
declare @.empid varchar(8)
select @.empid = '00118179'
select *
from openquery(SERVERNAME, '
select *
from
DBName.dbo.fn_GetConsulteesDataForReport(@.empid)
')
Becuase we need to dynamically change this employee ID.
Thank you.
Suhas
"ML" wrote:

> There's a workaround for this hm... feature. Use the OPENQUERY function:
> select *
> from openquery(SERVERNAME, '
> select *
> from
> DBName.dbo. fn_GetConsulteesDataForReport('00118179'
)
> ')
>
> ML
> --
> http://milambda.blogspot.com/|||For actual production use I'd suggest designing a local UDF, that references
tables in the database on the linked server. This way you can call the
function directly, and still access the data remotely.
ML
http://milambda.blogspot.com/|||Sorry, I forgot to mention, that OPENQUERY does not accept parameters or
variables. Read more here:
http://msdn.microsoft.com/library/d...br />
5xix.asp
ML
http://milambda.blogspot.com/