Thomas - Are you talking about in the database or in obiee? If in the database, yes, completely agree. Our modeling team is looking at that option. But if you're talking about doing something in obiee, please elaborate. I attached a screenshot (word doc) to the ticket with how I set up the 3 key join (I just spelled it out…

Gianni - Thank you. Yes, I did open an SR with Oracle. Here is some more information that might be of interest. Any thoughts? I was able to create an outer join where there was only 1 physical column join between two tables. In my example, I have 3 columns that are part of the physical join between the two tables. Is that…

That's not what I'm looking to do. Just an observation about the tool compared to some other BI tools I've seen. I do need to use obiee for the purposes of presenting information. I don't have another option presently. Thank you.

So has anyone else seen issues with generating the outer join syntax in obiee? I attached a Word doc with steps I've taken that I would think would impact the ability to generate the syntax. Thanks in advance.

Here is a picture from the connection in the physical layer. Outer joins enabled.

Martin - I can perform an outer join against the same database using another tool. So yes, the database itself supports outer joins. Is the picture you showed a setting in obiee or at the database level? Our database is Oracle 11. It does support outer joins now.

I attached a Word doc. Thank you.

Joel - Thanks so much. Our exact obiee version is 11.1.1.7.150120. Attached are screenshots. I really appreciate any feedback. I have screenshots in a Word doc. I'll find where to attach to the ticket and do so. Thanks.

Hi - We resolved this as part of another ticket. We are using VPD as we want all security controlled in the database. VPD is working now. I had to uncheck sharing the connection pool in the connection object for it to fully work as desired.

Gianni - You absolutely nailed it. Amazing job. That was it. We had shared connection pool checked. Once that was unchecked, it solved the issue. Ugh. Thanks again to all.

It is version 11.1.1.7. If the user hits the same report, you sure the presentation server cache not shared? When I cleared all cursors manually, the problem went away. VPD itself is working. If I manually clear all cursors, a person who was not seeing the correct data on the page now does see the correct information. We…

Here is what was throwing me - when you search the web for turning off the cache in obiee, several places basically say in order to do this at the application level, do it in Enterprise Manager. Isn't BI Presentation Services considered part of the application? I thought so. So didn't realize that I also need to deal with…

I'll keep all posted. I've also implemented the suggestion to disable presentation services caching. Here's why I'm doing this. We're incorporating VPD (virtual private database) whereby depending upon who runs a given query, a different set of data will show up. We need the query to hit the database each time so that…

Ok. The issue is probably the Presentation server cache. Will try last suggestion. Thanks all!

Hi All - I took the steps of turning cache on and off again (and restarting services) in EM this morning and it now appears that all is behaving as intended at the report level. Thank you. We've had caching turned off (at least as evidenced in EM and I verified in the nqslog) for a long time. What would make caching at the…