This discussion is archived
1 Reply Latest reply: Mar 27, 2013 12:24 PM by Srini VEERAVALLI RSS

OBIEE prompt

999602 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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

Legend

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