This content has been marked as final. Show 4 replies
The problem is that I can't localize reference to column "report"."variables" in repository and in reports. I did a text search in OBIEE web catalog and in repository (MDS XML format) but there is no such object.
I text-searched for all combinaations that came to my mind: [report.variables ; report"."variables ; report"."variables ; report"".""variables]
Repository pases Global Consistancy Check.
I am looking for a way to link the issue with exact report (or other object) causing it. I need a foothold for debugging.
It was not the case. Repository and report was ok. To find where is the issue I needed to add objects to new dashboard individually and see when error shows up.
The problem seems to be OBIEE 18.104.22.168 bug. Issue occurs in dashboard prompt when I add any "Variable Prompt" and sepeify choice list with custom values. Then when I use it in dashboard and click "Apply" all works fine, but there is an error added to BI server log file: Unresolved column: "report"."variables".
Reproduced it in totally new dashboard prompt with just one "Variable Prompt".
Workaround: created dedicated database table "VALUES_LIST" and filled with all combo box values needed in reports, added it to repository, and now use only "Column Prompt" in all dashbaord prompts. Not perfect solution but want to have logs clear before going live...