Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Windows XP - SQL server 2000

601445Mar 31 2008 — edited Apr 15 2008
Hello everybody,

I use OBIEE on a server Windows 2003 and a SQL Server 2000 and I have no problem, all the requests in Answers are correctly interpreted. But on my own computer with Windows XP and SQL Server 2000 when I run a request in Answers for exemple only on Customer name, OBI interprets the SQL like this :
WITH
SAWITH0 AS (select distinct T175.CUST_LAST_NAME as c1
from
CUSTOMERS T175)
select distinct SAWITH0.c1 as c1
from
SAWITH0

and my SQL SERVER doesn't appreciate this "WITH" at the beginning of the request, so for the moment I am totally blocked.

Do you have an idea why this happens ?

Thanks in advance for your help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 13 2008
Added on Mar 31 2008
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
3 comments
585 views