Forum Discussion

jayaleck's avatar
jayaleck
New Contributor II
6 days ago
Solved

How do I return a range of Members?

We have a large flat hierarchy, members starting with Px_1000 to Px_9999. For example, P1_1000_27 Project 1, P5_1001 Project Yellow.... P7_9999 Project Bob. The numbers are unique (no two same number...
Cube View
Dashboards
Parameters
Reports
  • jayaleck's avatar
    jayaleck
    2 days ago

    Thank you! Same concept I share what I came up with,

    If args.FunctionName.XFEqualsIgnoreCase("UavailableModNumberCheck") Then
     
    Dim FromModNumber As Integer
    Dim ToModNumber As Integer
     
    'Validation that they entered numbers in, then converting to an integer.
    If args.NameValuePairs("From") = String.Empty Or args.NameValuePairs("To") = String.Empty Then
    Return "None:Name(From/To cannot be blank)"
    Else
    FromModNumber = Integer.Parse(args.NameValuePairs("From"))
    ToModNumber = Integer.Parse(args.NameValuePairs("To"))
    End If
     
    'Validation of number entry
    If FromModNumber < 1000 Or ToModNumber > 9999 Then
    Return "Name(Mod Number entry must be between 1000-9999)"
    Else If FromModNumber > ToModNumber Then
    Return "Name(*From* Mod Number must be less than *To* Mod Number)"
    Else If FromModNumber = ToModNumber Then
    Return "Name(*From* Mod Number must not be the same as the *To* Mod Number)"
    End If
     
    Dim ModList As List(Of MemberInfo) = BRApi.Finance.Metadata.GetMembersUsingFilter(si, "Flow", "F#Flow.Base.Where(Name DoesNotContain Jay)", True)
    Dim ModSplit As New List (Of String)
    Dim ModNumbersList As New List (Of Integer)
    Dim PDONumbersList As New List (Of String)
     
    'Loop through modlist, put mod numbers into separate list and mod name in a separate list.
    For Each FlowMod In ModList
    ModSplit = StringHelper.SplitString(FlowMod.Member.Name, "_")
    If ModSplit(2) >= FromModNumber And ModSplit(2) <= ToModNumber Then
    'List if integers as mod number
    ModNumbersList.Add(Integer.Parse(ModSplit(2)))
    'List of mod name
    PDONumbersList.Add(FlowMod.Member.Name)
    'Brapi.ErrorLog.LogMessage(si, $"FlowMod {FlowMod.Member.Name}")
    End If
    Next
    ModNumbersList.Sort()
     
    Dim i As Integer = FromModNumber
    Dim iToString As String = String.Empty
    Dim ReturnString As String = "F#None:Name(Unavailable Mod numbers between " & FromModNumber & "-" & ToModNumber & ")"
     
    While i <= ToModNumber
     
    If ModNumbersList.Contains(i) Then
     
    iToString = i.ToString
     
    If i = iToString
    For Each PDOName In PDONumbersList
    If PDOName.Contains(iToString)
    ReturnString = ReturnString & ", F#None:Name(" & PDOName & ")"
    End If
    Next
    End If
    Else
    'Mod Number is open
    End If
     
    i = i + 1
    End While
     
    Return ReturnString
sameburn's avatar
sameburn
Contributor III
3 days ago

Hi jayaleck​

You should be able to perform some kind of string manipulation using linq on a member list

However based on your description it is difficult to understand how consistent your naming convention is e g are you only trying to retrieve a range from the numbers after the first underscore and before second underscore (if it exists)? You have provided examples of both

Similarly in your 500 to 1000 example, do the members have the same number of characters in the section you want to perform a range on.  E.g 500 and 1000 or 0500 and 1000?

There are a lot of variables here that are unknown based on your description. If you can flesh out your use case here a bit I suspect you will get a better response 

Hope this helps

Sam

 

jayaleck's avatar
jayaleck
New Contributor II
3 days ago

Good questions! It will always be 2 alpha/numeric characters, it could be P1 or PA, then underscore, then a 4-digit integer, starting with 1000, ending 9999. There will never be a leading 0. My apologies, there was a typo, it should have 1500 - 1532. Thank you!!