Forum Discussion

tdugas's avatar
tdugas
New Contributor III
6 months ago

Show Month name only

I have a cube view that is comparing two years and the better worse for each month.  Is there a way to show only the month name only (no year) in the Better Worse column header?

  • Henning's avatar
    Henning
    Valued Contributor II

    Hi,

    yes, you can add :name() to the member filter builder to set the name you need to display. You can manually enter the name, use a parameter, substitution variables or an XFBR rule.

    Manual would look like this:

     

    • aformenti's avatar
      aformenti
      Contributor II

      Yes, you could also use a substitution variable within the name function to retrieve the month description:

      :Name(|PovSubPeriod|)

  • T_Kress's avatar
    T_Kress
    Contributor III

    I think you could also set your cube view to use "short description" for time dim here:

    And then so long as your time profile appears as follows, it should only show the month: