2 Replies Latest reply on Mar 16, 2019 5:15 PM by Christian Berg

    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?