02-12-2024 05:02 PM
Hello,
Other than the 200 character limit, are there any other restrictions imposed on the Default Description for a dimension member? Thank you for your time.
02-13-2024 09:34 AM
Hi @FM I'm not aware of any restrictions. You can use #, $, /, \, and special characters but that does create a bit of a pickle when you're writing Business Rules. If you're ever passing the member description anywhere for say an XFBR, you need to include hard brackets [ ] so as to not break code execution. I checked and wasn't aware the limit is 200 characters, but you are correct. This is a view from the AuditMember table that shows the Description field is nvarchar with length 200. Also, didn't know the Member Name had a length of 500 limit:
Hope this helps,
02-13-2024 03:54 PM
Thank you MikeG! You make a really good point about the special characters potentially causing issues with the business rule execution. I am going to weight that in and might end up excluding them from the text input as it might just be better that way.