Thanks for response. In BI I have something like: But it still not work.

1) Oracle Business Intelligence 12.2.1.4.0 2) Yes, at now I see two time dimension for notification date and close date 3) Unfortunately I don't create this model but I must use it. It is looks like: FACT ---> PRODUCT and PRODUCT dim has join to NOTIFICATION DATE and CLOSE DATE (in physical layer and in business) ---- I…

Can anyone help or suggest some approach to solve my problem? I have dimension in rpd like: product1 || open || 2018.10.23 15:23:00 || 1 product1 || prepared || 2018.10.23 18:00:00 || 2 product1 || issued || 2018.10.23 23:00:00 || 3 product1 || close || 2018.10.26 00:00:00 || 4 But now I don't know how to see only last…

Hi, Robert has right about my question. I select driver: Oracle BI Server or Oracle BI Server-OBI12Client. Next I want to click Finish - I should see new windows with properties (host, login, pass, port etc.) - BUT when I click finish all window disapear and I can't set properties. I check others driver (like: Oracle in…

I have requirement about running OBI in Windows Server as 'service mode' and I want read about it, the advantages and disadvantages. I still learn about install OBI and for me is something new. Can you share some documentation about it?

Unfortunetaly, data is correct and the visualization is correct - we have one unexpected value for one branch and thats the problem. I can uncheck this branch in filter but it is wrong option. I am thinking about ZOOM graph in percent...

Yes, I am asking for sum of last 3 MAX values. My mistake.

Ok, I have MEASURE_1 with MAX aggregation and when I'm using PERIODROLLING like: PERDIOROLLING(MEASURE_1, -2,0) in results i see MAX VALUE from 3last months. I must set max in rpd but on analysis I want to sum last 3months

Thanks for response. I did this task by creating complex SQL query (view) and implementing Direct Database Request.

I knowo who to use pivot table, I only thought that you know some secret solution with pivot.