Forum Discussion

marisolbritton's avatar
marisolbritton
New Contributor III
7 months ago

change order of AllPriorinYearInclusive

Hi!  We are using T#Pov.AllPriorinYearInclusive in a cube view but would like to change the order the months appear from oldest to newest (i.e. Jan to June)  to current to oldest (June to Jan).  Does...
Cube View
Reports
aformenti's avatar
aformenti
Contributor II
7 months ago

Hi marisolbritton,

You can try with the following XFBR rule, this should reverse the order:

				If args.FunctionName.XFEqualsIgnoreCase("GetReversedTimeFilter") Then
					
					Dim TimePK As DimPk = BRApi.Finance.Dim.GetDimPk(si,"Time")
					Dim TimeList As List(Of String) = BRApi.Finance.Members.GetMembersUsingFilter(si,TimePK,"T#Pov.AllPriorinYearInclusive",True).Select(Function(x) $"T#{x.Member.Name}").ToList()
					TimeList.Reverse
					Dim TimeListString As String = String.Join(",",TimeList)
					
					Return TimeListString
					
				End If