Forum Discussion

Shub's avatar
Shub
New Contributor III
14 days ago
Solved

Dynamic Short Description for UD3

Hi 

I have been trying to dynamically update the short name for UD3 but somehow the i am not getting the result. Not sure where i am wrong. Please help

 

Cube View
Reports
  • db_pdx's avatar
    db_pdx
    13 days ago

    One small tweak to your XFMemberProperty syntax should be all that is required.

    U3#|!SITA_GroupBU!|.Children:Name(XFMemberProperty(DimType=UD3, Member=|MFUD3|, Property=Text1))

5 Replies

  • db_pdx's avatar
    db_pdx
    Valued Contributor
    13 days ago

    One small tweak to your XFMemberProperty syntax should be all that is required.

    U3#|!SITA_GroupBU!|.Children:Name(XFMemberProperty(DimType=UD3, Member=|MFUD3|, Property=Text1))
    • Shub's avatar
      Shub
      New Contributor III
      13 days ago

      It works now. Thanks:)

  • jbrem's avatar
    jbrem
    New Contributor III
    14 days ago

    I believe short description only applies to the time dimension & can be edited in Application > Time Profiles.

    • Shub's avatar
      Shub
      New Contributor III
      14 days ago

      How do we do the dynamic short description then without BR.. Such long Description looks odd in PDF any way to make it presentable in PDF format?

      • jbrem's avatar
        jbrem
        New Contributor III
        14 days ago

        For time, you would go to you can set the property in the cube view to use short description.  I suppose if you really wanted alternate descriptions for other dimensions you could use the English description as an option.  You could also set the width for the pdf to accommodate.  If it's a big issue maybe discuss with your teams to agree on what items can be abbreviated to fit better.