cancel
Showing results for 
Search instead for 
Did you mean: 

Object working OK in Designer, not in InfoView. Using Linked SQL Server

Former Member
0 Kudos

Hi There.

I have a problem.

I have made a dimension object in Designer.

The source is a derived table, and the derived table is using a linked Server.

In Designer I have no problems looking at the content of the object.

But when I try in InfoView ( Webintelligence), the query is timing out with no answer.

If I run the SQL from Infoview in a sql tool it is OK.

I have been thinking on user rights and firewalls..

but both should be working ok.

any suggestions on how to test theese from infoview ?

Could it be that SAP bo webi do not handle linked server ?

Thanks for any suggestions.

Ingrid

( SQL :

SELECT

OppstartsMaaned_DerivedTable.mnd

FROM

(

Select

u.udsalesmall_id,

min(u.long47) as uke,

min(t.Year_month) as mnd

From CRM5.udsalesmall u,

OSLNOSQL01.InternalDW.dbo.DIM_TIME t

where

t.Year_week = u.long47

group by u.udsalesmall_id

) OppstartsMaaned_DerivedTable

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Ingrid,

Where is the Webintelligence Server located?

Is it in the same building as the linked server?

Does a non-linked server query perform noticeably slower than SSMS for a Webi query?