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

  • 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 :


    [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 !

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

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply