I am using OBIEE 11G against SQL Server 2008 R2. I have created a data model (using the query builder) to query my presentation layer and when I view the result, I get the [LONGVARCHAR] in the table as below:
I've gone and traced the table in SQL Server and it's data type is nvarchar(MAX). I can pull the data out in BI Administration --> Physical View --> View Data. Is there a compatibility of BI Publisher with certain data types of SQL Server? Anything I can do to get around this problem (aside from changing data type in source table)?
You need to convert column to string/varchar type of 4000 chars. You may use any of the below functions.
Syntax for CAST:
CAST ( expression AS data_type [ ( length ) ] )
Syntax for CONVERT:
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )
Try to create a db view and embed the function and import in Physical layer. Never mind...you've updated when i was composing
Edited by: Srini VEERAVALLI on Jan 23, 2013 7:35 PM