Referencing system tables to build a view

An alternative to the "Member" table is to use a Business Rule of type, Dashboard Data Set, which would return a DataTable to a Data Adapter.

For example, to get base members of a member.  "Dimension" and "Member" could be passed as string parameters.

Public Function getBaseMembers(ByVal si As SessionInfo) As DataTable
    Try
        Dim lomBaseMembers As New List(Of member)
        lomBaseMembers = BRApi.Finance.Members.GetBaseMembers(si, _
            (BRApi.Finance.Dim.GetDimPk(si,("Dimension"))), _
            BRApi.Finance.Members.GetMember(si, _
                DimType.Account.Id,"Member").MemberId)

        Dim dt As New DataTable
        dt.Columns.Add("MemberName", GetType(String))

        Dim mBaseMember As Member
        Dim strBaseMemberName As String = Nothing

        For Each mBaseMember In lomBaseMembers
            Dim Row As DataRow = dt.NewRow()
            Row("MemberName") = mBaseMember.Name
            dt.Rows.Add(row)
        Next

        Return dt
    Catch ex As Exception
        Throw New System.Exception ("An error has occurred.")
    End Try
End Function