Yes! its strange..Everything is similar. But Query execution is different from 11g vs 12c. We will confirm with users once.

with admin rights; which is to say no security; if you construct a simple query against pre / post subject area do you get the same data? Answer: Haven't tried this. I am new to essbase. Then apply security and check like for like? Answer: Security is applied via shared logon in 11g and where we kept static name for 12c in…

You are missing a key point in your thread: different as "they are finally correct" or different as in "they aren't correct" ? Answer: They are not correct Did you do some analysis/debug of the case to find out what is different between how 11g and 12c do things? (generated queries etc.) Answer: 11g is showing a crossjoin…

We have resolved ourselves. OBIEE12c security implementation was different when compared to 11g.

Have you already checked in the ADministration page whether there are objects left which require upgrading? Yes.. I have scanned and updated the catalog objects. Have you checked what makes those folders stand out? Do they share certain rights in 11g? The folders which are not displaying in 12c that was set as system…

Yes they are same. We have verified the applications roles they are exact match.

1.Upgraded from 11.1.1.7.0 2. Upgraded to 12.2.1.3.0 3. Using jar file import and export from 11g to 12c. Hope you got all information you requested.