Hi all

happy new year !!

I finally resolve this issue :

WITH

MEMBER [Measures].[Last_Date] AS

Mid([HierarchyA].[MemberA].CurrentMember.Member_Caption,7,4) + Mid([HierarchyA].[MemberA].CurrentMember.Member_Caption,4,2) + Mid([HierarchyA].[MemberA].CurrentMember.Member_Caption,1,2)

SELECT

NON EMPTY

...