Hi all,
I have a problem in defining the membercaption in a hierarchy.
Actually, I have a hierarchy populated with attributs from a table A which contains 3 fields: Date, id: BusinessKey and Name:memberCaption .
suppose that we have 3 sets ( {'date': 01/2017 ; 'id' : 1 ; 'Name': X } , {'date': 02/2017 ; 'id' : 2 ; 'Name': Y }, {'date': 02/2017 ; 'id' : 1 ; 'Name': Z } ).
When I test the hierarchy, I get to lines {'date': 01/2017 ; 'id' : 1 ; 'Name': X } , {'date': 02/2017 ; 'id' : 2 ; 'Name': Y }.
I am wondering if is there a way to filter the hierarchy to retrieve the last version of each id, I mean to retreive the id =1 and name =Z not x because the name x is not valid.
Thanks