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?