3 Replies Latest reply: Jan 23, 2013 8:10 PM by xarg-Xrc RSS

    longvarchar in BI Publisher

    xarg-Xrc
      Hello,

      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:

      http://i.imgur.com/nqn5NEH.png


      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.