OBIEE dashboard column formula

user1323905

HI,

OBIEE 11.1.1.7

I am trying to update certain records (some fields, not all the line) in the dashboard depending on the entry from the presentation variable (drop down list)

let's say the user chooses (A,B,C) from a list of (A,B,C,D,E,...) and i only want to update the Amt for those lines by

equation= Amt * constant_value

the other lines stay the same.

in the popup screen I edit the column formula, I am trying to do the following and it's not working :

FILTER("Fact S"."Amt" USING (DESCRIPTOR_IDOF("S"."DS [Level Dtl] Attributes"."Short Name") IN (@{pv_short_name}{'%'})))

how do i fix it?

Gianni Ceresa

Hi,

Why do you use FILTER ?

Based on what you wrote a simple CASE WHEN .... THEN .... ELSE ... END would be enough ....