Skip to main content
F
FM26
Newcomer
February 12, 2024

Restrictions on member Default Description

  • February 12, 2024
  • 2 replies
  • 0 views

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.

    2 replies

    MikeG
    MikeG
    Contributor
    February 13, 2024

    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:

    MikeG_0-1707834768402.png

    Hope this helps,

     

      P
      ptran
      Newcomer
      February 3, 2025

      how did you generate that table?

        MikeG
        MikeG
        Contributor
        February 4, 2025

        Table Data Manager utility, it is a MarketPlace download.  TDM.  I use it to manage ancillary tables but you can also review the schema of existing OS database tables using that utility.  

          F
          FM26Author
          Newcomer
          February 13, 2024

          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.

            Terms & ConditionsAccessibility statement