I have two attributes hierarchies in my dimension [Dim Project]:
Project A with 3 opening date : 2023-01-01 , 2023-01-02 and 2023-01-03
Project B with 2 opening date : 2023-01-02 , 2023-01-04
MDX query :
[Dim Project].[Project Code] .[Project Code].Allmembers * [Dim Project].[Opening date].[Opening date].Allmembers on 0
[Measures].[Measure1] on 1
I want to show for every Project its last Opening Period.
Project_Code Opening_Period Measure1
Project A 2023-01-03 Measure1_1
Project B 2023-01-04 Measure1_2
How can write this in MDX.? Thank you so much for your help!
I know that Tail function can help in this case but how !