This discussion is archived
0 Replies Latest reply: Nov 21, 2012 6:56 PM by JoeSSI RSS

SQL prompts show no data OBIEE 11.1.1.6

JoeSSI Newbie
Currently Being Moderated
Dear Gurus,

I have prompt with parameters like:
Province
City
Hospital Name

I want Hospital Name parameter filtered by Province & City so I use this in my Sql Prompts Syntax:

SELECT "Dim Hospital"."Hospital Name" FROM "eHealth CCD Vital Sign" WHERE "Dim Region"."Province"='{v_province}'

I tested it and it show no data (appear search....) in Hospital Name drop down.
I run it in Firefox, IE, Chrome, still the same.
It work when I remove WHERE from the syntax.

Is this bugs?
I use obiee 11.1.1.6.0

Any help will be appreciated

Regards

JOE

NB:Sory I have post in wrong section, already move it in OBIEE Foundation.

Edited by: JoeSSI on Nov 21, 2012 6:55 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points