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

    SQL prompts show no data OBIEE 11.1.1.6

    JoeSSI
      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