on 07-29-2011 10:12 AM
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.