NVARCHAR(4000) -- Limitation in Rule Files

Hi all,

I just faced a problem with loading a dimension via rule file (SQL view).

My sql statement included a column with NVARCHAR(MAX). The result is that the rule file only shows and loads the first 7 characters of this column. After some time i figured out that a rule file accepts

4000 characters at maximum --> nvarchar(4000) or varchar(4000).

Is it possible to raise the maximum number of characters somehow?

This is especially interesting becuase the following statement works:

I add the first 4000 characters of a column to the characters 4001 to 8000 in one column - which is nothing else than a varchar(8000) ...