1 Reply Latest reply: Mar 27, 2013 2:24 PM by Srini VEERAVALLI RSS

    OBIEE prompt

    999602
      Hi,

      I need a column in report to be displayed only when current month is selected on the dashboard prompt.. for this i am using server variable
      The condition I gave in report is :
      case when @{biServer.variables['CURRENT_FISCAL_PERIOD']}
      THEN "Fact"."Invoice Amount - Functional Currency"/"Fact"."WIP To Bill - Functional Currency"/100
      ELSE 0 END
      Its throwing syntax error..could anyone help me out in this.

      Thanks,
      Sandy
        • 1. Re: OBIEE prompt
          Srini VEERAVALLI
          There is no condition in your case statement.

          Btw:Use the below for calc or with brackets

          ("Fact"."Invoice Amount - Functional Currency"/"Fact"."WIP To Bill - Functional Currency")*100.0

          If helps mark

          Edited by: Srini VEERAVALLI on Mar 27, 2013 2:24 PM