Skip to Content

Max Charecter Length in webI

Hi Experts,

Please help me on the below requirement.

I have a comments field which has 250K (250000) Length in DB but when I ran the report I got different errors. Finally I achieved to get the results without getting error but i got the field length up to 32767 letters only and remaining are truncating. But if I have written any formula on this field in report is showing #Overflow error.

Could you please help me on this how can i get all the letters in BO WEBI report.

Object is a dimension and type is long text.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jul 26, 2017 at 11:17 PM

    Solution:

    Unfortunately there is no solution till now but we have a work around we can do like below. We need to Increase the limit in the server to generate large binary files and even if we are getting above errors then we need to create object at universe level and the datatype of the field should be LONG TEXT. In this way we will get max length as 32767.We created a ticket with SAP and got the confirmation that we won’t get more than this in report.

    Detailed Information:

    We can achieve to get the results in different ways like creating substr/If else function at universe or report level but whatever it may be finally we can’t get more than 32767.If it is more than 32767 then it should be either truncating remaining letters or you will get #Overflow error. The #Overflow error we are getting because of report limitation in Webi. Webi has 16384 letters limitation in object and if it has more than that then we will get this error because when any calculation on this data (string) is performed, there is a size limitation of 16*1024 = 16384 set internally for the string in report. If we want to get more than 16384 then we can create same formula at universe so that we can get max 32767 in report

    Note:

    Since this object data has huge data in every row it may leads to show some performance issue. Even it will cause more performance issues if this report has

    • 1.More fields in addition to this object in the report
    • 2.If it has more data in Database.
    • 3.If we use this field in filter in query level with like operator or something others it may leads more performance issues.
    Add comment
    10|10000 characters needed characters exceeded

  • Dec 02, 2016 at 09:12 PM

    Hi,

    Is this WebI report on Universe or OLAP?. If universe then you can change the settings of the object to display.

    Also, You can have multiple freestanding cells relatively aligned and define length of the chars.

    Say length of the string you want to define as 30000 chars.

    =If(Length([Object])<30;[Object]+Fill(" ";30000-Length([Object]));Left([Object];30000))

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 05, 2016 at 03:44 PM

    Hi Jyothi,

    Thanks for your reply and apologies for late response.

    I'm creating WEBI report on Universe and it a Relational database (Oracle).I need to get this data as in a single field so that users can apply a filter in query level before data getting into the report.Can you please elaborate the solution on settings of the object to display.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 06, 2016 at 03:27 PM

    Hi Jyothi,

    Any updates on this ticket?

    I know you have referred this URL but my requirement is different.

    http://www.forumtopics.com/busobj/viewtopic.php?t=217106&view=previous&sid=818badf17cf6ab6ca49c86089dc41340

    Hi Experts,

    Could any respond to my request please? If it is not possible, then I want to know the max limitation of chars/letters in BO

    Details are below.

    Report: WebI

    Source : Universe

    DB: Oracle

    BO Version: Version: 4.1 Support Pack 6

    Object type : Long text

    Actual data : 250K letters in each object

    output i'm getting right now is 32767 and remaining are truncating.

    Expected result: Business want to see the all the data in every object in WebI report

    Hope this information is sufficient

    Thanks in advance!!

    Regards,

    Durga

    Add comment
    10|10000 characters needed characters exceeded