Show Month name only

tdugas
New Contributor III

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?

3 REPLIES 3

Henning
Valued Contributor

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

 

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

:Name(|PovSubPeriod|)

T_Kress
Contributor II

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

 

 

 

 

 

Teresa C. Kress
Principal Delivery Manager Partner Enablement | OneStream Software