Skip to Main Content
Forums

Dashboard Prompt Issue: SQL + Constraint

1003917Apr 18 2013
Hello,

I have 1 dashboard prompt: Procedure room"."Room name" which I am constraining by another prompt: "Procedure room"."Department name"

Constraining works fine but the problems is that when I constrain the prompt: Procedure room"."Room name" I can no longer filter the check box values with the following SQL query:
SELECT "Procedure room"."Room name" FROM "Request - Procedure" WHERE ("Procedure room"."Inactive since" IS NULL) ORDER BY UPPER("Procedure room"."Room name" )

Any advice to solve this or workarounds?

Thanks,
Gunnar
Post Details
Locked due to inactivity on May 16 2013
Added on Apr 18 2013
#11g, #bi, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee, #oracle, #prompt
0 comments
55 views