Member Property length limitation

I have a member property in a shared dimension MSAS 2000. The length of column from which this member property fetches value is nvarchar(2000). But the OLAP cube is reading only 255 characters ONLY. Is this a common limitation ? If yes, what is the alternative to increase its length to grater than 255 ?

Any help will be greatly appreciated. Thanks.

If you go into the dimension editor, expand the member properties and click on the property and have a look at the advance properties - what is the data size set to? I am guessing that it may be set to 255 and you should be able to set it larger, but it's been a while since I used AS2k.|||I had checked it. It has LongWVarchar(2000).|||

I just fired up a copy of AS2k and did a quick test and got the same behaviour - member properties were truncated to 255 characters. At a guess I would say that they are only using a byte to store the length of the property, so there would be no way of working around this. Also AS2k stores all the dimension members and properties in RAM, so having very large member properties can put a lot of pressure on the RAM usage.

The only thing I could think of is to store an ID that relates back to the record in question and then use an action or something similar to link the two pieces of information together. If you setup a linked server in SQL Server you could write stored procedures that would query AS2k and you could join the cube data with a relational table before sending the results back to the client.