tdugas
6 months agoNew Contributor III
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?
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?
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:
Yes, you could also use a substitution variable within the name function to retrieve the month description:
:Name(|PovSubPeriod|)
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: