I take this as a compliment ! It was my first post ever after years of reading this forum , I wanted to do my best Finding a solution to my problem and reading your comment proved I was right to do so ! Thanks all Regards

Don't worry I WILL remember that !! Worst thing is I don't have any performances issues. I've always worked with cache disabled as a consultant ( especially for the cache management strategy ) just thought it would be a "cool" thing to use now that I am in an IT dept. That's part of the job to learn every day ( even the…

Disabling the cache solved the problem. ! So my understanding is that BI server uses the cache entries of the 2 physical queries and joins them After disbaling the cache , the join query is a physical query ran against the DB It's the first time I wanted to use the BI cache for improved perf..... Anyway , gianni thanks a…

Yes the DB is Oracle 11g The 11.1.1.9 system is a new install performed 3 months ago. It's in production mode since March and we didn't notice anything strange since then The database has been running for ages I left the default settings in the DB options in physical layer The cache setting is different between the 2 env (…

Yes both queries are on the same connecion pool Here is the end of the session log page , I can see both physical queries and what I assume to be the join : First physical query for Previous Year WITH OBICOMMON0 AS (select T44176.DATE_COMPLETE as c3, T44176.ANNEE_MOIS as c4, T44176.ANNEE as c5, ROW_NUMBER() OVER (PARTITION…

Hi Gianni , I 've always assumed that it is obiee ( presentation or bi server ) that does the final join ( the ability to join different datasources made me think that ) , I may be wrong though. In session manager I see both pysical ( ie oracle sql) queries for current and old figures but the final join is not written in…