This content has been marked as final. Show 4 replies
Cause:The column name was misspelled or the user does not have access rights to this
Response: Verify the spelling of the column name, and be sure the user has access rights
to the column. Correct any problems and retry the action
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.
u have passed global consistency mean there is no errors...did u changed/renamed any column in RPD recently and by any chance forgotten to change same in Reports as well?this may be happen if u renamed any thing and if Alias notreferenced/not created for that presentation column... plz check.
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 220.127.116.11 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...