Business Objects 4.1 Universe Derived Tables Max Length Problem

[Former Member]

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 .

[former_member4998]

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.

[Former Member]

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