0 Replies Latest reply: Nov 21, 2012 8:56 PM by JoeSSI RSS

    SQL prompts show no data OBIEE

      Dear Gurus,

      I have prompt with parameters like:
      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

      Any help will be appreciated



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

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