Just in case you want to try with Foreign key joins in BMM Layer, try to enable it from Options. It's just suggesting you to give a try!

Check in Options!! just need to enable it. We can still use Foreign key joins in BMM Layer. Hope you got it. @Gianni Ceresa

In Criteria tab we can go for aggregate something like sum(Measure1 by Col1) or sum(Measure1 by Col1,Col2)

The DSN what you are using is pointing to Freshly installed environment?

In Physical layer keep that complex join as is and try to create physical join in BMM layer and see how that works. Gurus may not like but give a try with copy of rpd and let me know. Thank in advance

Why bi server is not showing up in Console!

Try to maintain the below order to load and see how that works OBI Node Manager OBI Admin Server OBI Managed Server OBI OPMN

I need to know how you configured Adminserver and BI Managed Servers (if its Windows) Login to Console and force shutdown bi_server and then start that should help. I think issue is related order of loading servers/components.

You can ignore Weblogic user. Can you redo the same logical column with different name and see how that works? Also try with this if above is not working TIMESTAMPADD( SQL_TSI_MINUTE , -300, "Data Warehouse"."Catalog"."dbo"."XX Facts"."X_TIMESTAMP_YY")

Try to enable Repository Documentation. this is the best.

Check log messages from folder \OFM\instances\instance1\diagnostics\logs\OracleBIJavaHostComponent\coreapplication_obijh1 You might need to set java Memory settings

Check the Physical query.

I would suggest to work on first with oob location by replacing actual file if that works then go to custom location.

Check this https://docs.oracle.com/middleware/11119/core/FUGBI/bi_plan.htm#FUGBI468

Check this doc https://docs.oracle.com/middleware/1212/core/OUIRF/silent.htm#OUIRF330

Check this doc http://www.oracle.com/technetwork/middleware/bi/customizing-oracle-biee-11g-176387.pdf also Replace the Oracle logo - OBIEE 24/7 - Berry van den Heuvel (NL)

Convert it to near datatype so that you wont loose data. So that you can use that in your Group by clause

Just in case check these Doc IDs 1672130.1 and 1364974.1

What value you set for Refresh Interval in Init Block? Proper setting might help you. https://docs.oracle.com/cd/E28280_01/bi.1111/e10540/variables.htm#BIEMG354

You need to use/look for "Entire Dashboard" option and the same not from drop down-list I do see the same in your screen.