Skip to Content
avatar image
Former Member

Business Objects 4.1 Universe Derived Tables Max Length Problem

Hello Everybody ,


I created a derived table. Derived table character number length is 65517 . I did not add any character in the derived table. How can I increase character length ?  I must add more 50000 characters . How can I do ?

My database is Progress so view is not supported.


Thank you .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 13, 2014 at 05:12 AM

    Hi,

    Try creating two Derived table & then use combined queries (Or Merge Dimentions as per the structure designed for derived tables ).

    Also Please check the link below It may help .

    Derived Table - SQL Expression Limit

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 19, 2014 at 02:42 PM

    Hi

    If possible create views in the Data base requesting DBA guys, and use that views in the Data Foundation...or create different derived table related to each sub requirements and use this tables.

    Creating large derived tables will impact performance.

    Add comment
    10|10000 characters needed characters exceeded