question

BijuIG-9590 avatar image
0 Votes"
BijuIG-9590 asked LukasYu-msft commented

Master Data Services - Attributes Length Issue

I have 2 questions...

  1. Is it possible to have an attribute in the MDS Model entity with data type NVARCHAR(MAX). If yes, how can I set the "MAX" length?

  2. "Code" attribute is a key in MDS Entity. Is it possible to change the data type or length of this column?

Earliest reply much appreciated.


sql-server-generalsql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft commented

Hi,

Is it possible to have an attribute in the MDS Model entity with data type NVARCHAR(MAX). If yes, how can I set the "MAX" length?

I guess you are trying to have a string attribute , in MDS we did not have NVARCHAR(MAX) data type but we have Text. You could follow this to create the attribute you like, and you question is answered with step 10 and step 11. Create a Text Attribute (Master Data Services)


May I understand why would you change code attribute? Code is only used as key in the model, it should not affect you model. It is generated automatically as numeric value. I remember vaguely it can be set as text type, but I am not quite sure on this.

Regards,
Lukas


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Have you resolved this issue ? Can we help you further on this issue ?

0 Votes 0 ·