Skip to main content
T
tdugas
June 19, 2024

Show Month name only

  • June 19, 2024
  • 2 replies
  • 0 views

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?

2 replies

H
Henning
June 19, 2024

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:


Henning_0-1718804801266.png

 

A
aformenti
June 19, 2024

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

:Name(|PovSubPeriod|)

T
T_Kress
June 19, 2024

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


T_Kress_0-1718814044126.png

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


T_Kress_1-1718814088316.png

 

 

 

 

 

Terms & ConditionsAccessibility statement