Problem with model - how to use max() keep (dense_rank last order) in OBIEE

choracy69

    Hi, I have some problem with  creating model.

     

    My table has for example for one product 3  record with  STATUS and  DATA_STATUS:

    product1 || open || 2018.10.23 15:23:00

    product1 || prepared || 2018.10.23 18:00:00

    product1 || issued || 2018.10.23 23:00:00

    product1 || close || 2018.10.26 00:00:00

     

    And now I want use in bi something like this:

    max(STATUS) keep (dense_rank last order by DATA_STATUS) LAST_STATUS

     

    Additional in physical layer this table I have connect to D_TIME_STATE_OF (D_TIME_STATE_OF .D_TIME_ID >= DATA_STATUS) which means when I'm creating analysis on BI I want to set: DAY STATE OF for 2018.12.31 and want last data for this state, for example:

     

    1) For state of = 2018.12.31 I want see :

              product1 || close || 2018.10.26 00:00:00

     

    2) for state of = 2018.12.25 I want see:

              product1 || issued || 2018.10.23 23:00:00

     

    How can I achieve result like this?