OTBI Dashboard Prompt based on "Trading Partner Item Details" is not returning values
We have. a dashboard that contains an analysis and a prompt.
The prompt is based on the following sql query:
SELECT 0 s_0, "Product Management - Trading Partner Item Real Time"."Trading Partner Item Details"."TP Item Number" s_1 FROM "Product Management - Trading Partner Item Real Time"
When trying to select from the prompt, I get no rows. The same column pulls data fine when used inside an analysis
We looked at the nqquery log attached here and we could see this sql query:
SELECT T288232.C132658618 AS c1
SELECT V228609011.TP_ITEM_NUMBER AS C132658618