06-10-2024 11:06 PM
06-11-2024 12:29 AM
Hi, I am not aware of a native function that reverses the periods e.g. of the one you are using. I think you will need a memberlist for that. There is a helpful post with a good responses where someone needed a custom memberlist for the time dimension as well:
Solved: Time Member POV CVs - OneStream Community (onestreamsoftware.com)
There are other posts on this too if you search for "memberlist" in the search bar, that should get you going.
06-11-2024 04:15 AM
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
06-11-2024 10:45 AM
Thanks! So I just need to create a BR and apply that to the cv?
06-11-2024 10:59 AM
Exactly, you need to create the BR and run it in your CV.
I haven't tested it, but let me know if it works and If not I can help troubleshoot.
Thanks,
ALbert