Hyperion Financial Management (HFM) (MOSC)

MOSC Banner

How do I create an Alpha Numeric Memberlist?

edited Apr 23, 2012 12:04AM in Hyperion Financial Management (HFM) (MOSC) 2 commentsAnswered

Our MetaData for Custom2 Members are Alpha Numeric.

The below code only sorts the Memberlist in Alphabetical order but ignores the Numeric Values.

How do I get it so sort Numerical as well?

'********************************************************************

'Sort routine to sort member lists

'********************************************************************

 

Sub Sort(aMyArray(), sSortOrder)

 

    Dim i, j, Low, Hi

    Dim sTemp, sSwapped

    Dim bSortDescending

 

    If UCase(Left(sSortOrder, 1)) = "D" Then

        bSortDescending = True

    Else

        bSortDescending = False

    End If

 

    Low = LBound(aMyArray)

    Hi = UBound(aMyArray)

    j = (Hi - Low + 1) \ 2

    Do While j > 0

        For i = Low To Hi - j

            If (aMyArray(i) < aMyArray(i + j) And bSortDescending) Or _

             (aMyArray(i) > aMyArray(i + j) And Not bSortDescending) Then

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center