3 Replies Latest reply on Jan 24, 2013 2:10 AM by xarg-Xrc

    longvarchar in BI Publisher


      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)?

      Many Thanks.