In DeskI, what's the maximum for "Limit size of long text objects"? 2000?

[Former Member]

In Universe Designer, we have a setting which is "Limit size of long text objects", it can control how many characters can be displayed for long text objects.

The problem is that in DeskI, we can only display 2000 characters even we set 2500 or more in Universe Designer by "Limit size of long text objects". But if we use the same Universe & same Database, WebI can show 2500 or more characters for long text objects.

So does it mean in DeskI the maximum value for "Limit size of long text objects" is 2000?

[Former Member]

Hi Jason,

Check that the object in the universe is set to data type "long text".

Also check that the object itself is not limiting the length of the string, as well as that the entire string is actually in the database... the data type here could also be the issue.

Hope this helps

Jacques

[Former Member]

Resolved, here are the steps:

This issue was related to the setting of dimension type in universe and customized SQL.

1. Parameter on long text limitation

2.Demention type changed to long text.

3.In DESKI, create report but not using customized SQL