10 Replies Latest reply on Nov 28, 2012 10:10 AM by Layman-Oracle

    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