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!

nvarchar column filter - SQL server

cardellDec 7 2011 — edited Dec 8 2011
Hello,
I am using OBIEE 10.1.3.4.2 and I have problem with filtering data coming from SQL server 2008. I am using ODBC connection to access SQL server data. I can see results of my queries without any problem.

But I have problem with filtering.

My answer use these columns:

Id (varchar(36))
Code (nvarchar(256))
Name (nvarchar(256))
HappenedOn (date)

Please look on this screenshost:

http://img59.imageshack.us/img59/5242/obieenvarcharcolumn.jpg
Screenshot

I have problem when I want to use filter on Code column and use some non-english characters. Specifically Czech characters in windows1250 code page. With that filter I am getting "No result" view. But generated select is working in Microsoft SQL Server Management Studio.

I think there is some problem with ODBC resource or BI configuration, but I can not find reason of this behaviour.
Do I need to make some specific configuration to use NVARCHAR columns? Specifiy some encoding etc....

Thank you
This post has been answered by Dpka on Dec 7 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 5 2012
Added on Dec 7 2011
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #column, #filter
3 comments
680 views