Did you try building a new analysis from scratch with the same query?
Also maybe worth searching the forum here as I remember something similar (actually the same) some time ago.
PS: it always help if you clearly identify the versions you talk about (full version number + bundle patch)
Yes we have tried creating new analysis from scratch.
Details of version: Oracle Business Intelligence Product Version 220.127.116.11.0 (Build BIPS-20160923092103 64-bit)
Please note that the issue is only for direct sql queries. Normal queries from subject areas have no problem.
You meant this post? Data missing in random columns in Analyses (12c 18.104.22.168)
Yes, that's the post I had in mind
As you have the same version you maybe want to have a look into the linked bug/patch. The bugs not being public if you want to see more you will need to open a SR.
The patch is available publicly in MOS, so you maybe want to give it a try ...
That particular post was related to queries from subject areas.
But nevertheless, it's the same issue, will have a look at the patch.
You are right but it's also the only thing I remember sounding like what you see, with columns just "empty".
Also the patch has a name and replace a .so file which could also work for DDR.
You can of course open a SR and follow the process there asking them if the fix cover your needs too or not. But if you have a sandbox around it's probably faster to try the patch (in general SR take time)