How can I show the last opening period for each project in my project dimension

• casagrandi

  Old Hand

  Points: 351

  More actions

  May 30, 2023 at 4:29 pm

  #4200779

  I have two attributes hierarchies in my dimension [Dim Project]:

  Project Code

  Opening date

  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 :

  Select

  [Dim Project].[Project Code] .[Project Code].Allmembers * [Dim Project].[Opening date].[Opening date].Allmembers on 0

  [Measures].[Measure1] on 1

  from Mycube

  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 !

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  May 31, 2023 at 5:10 pm

  #4201659

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.