presentation varaiable is not working in edit formula in obiee

3167974

hi,

I have written one formula in the edit formula say for ex we have sales measure and there we  need to filter the data using column =@{scenario}{actual} but, when I apply  the presentation variable in edit formual its not working anymore whereas if I apply the formula  as filter( sales using column name ='actual') then report is working fine. please  help me oout on these why the presentation variable is not working in edit formula.

[Deleted User]

Works perfectly fine:

FILTER("Revenue Metrics"."# of Customers" USING "Products"."Brand" = '@{pv_SomeVar}{BizTech}')

Your formula must be wrong

Robert Angel

Note the single speech marks in the example in Christian's reply, necessary for varchar fields....

[Deleted User]

I immediately thought the same thing but just wanted to prove the whole shebang

Robert Angel

The comment was not directed at you, I just wanted to point out to the asker that the syntax is dependent on the data type.

No criticism intended or implied of your good self or your most detailed and salient response!

:-)

[Deleted User]

I didn't take it as criticism Robert. Just wanted to "+1" your pertinent statement since it is THE thing to go wrong there.