You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Dashboard Prompt based on "Trading Partner Item Details" is not returning values

Received Response
51
Views
3
Comments

Summary:

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:

WITH SAWITH0

AS (

SELECT T288232.C132658618 AS c1

FROM (

SELECT V228609011.TP_ITEM_NUMBER AS C132658618

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!