creating dashboard prompt based on column in analysis with case statement

Question

Hi

I am trying to create a dashboard prompt based on column in analysis with case statement

I have a case statement in one of the column let us say to show "sell to " and "sell thru"

the case statement works perfect on the report but now I want to create a prompt so the user can pick either "sell to" or "sell thru"

I was able to do it but then the numbers dont make sense.

If the prompt has both selected the $ is 10,000 (for example) if I select only sell to I get 11,000

any idea?

Thanks

cesar.advincula.o · Answer

Hello,

First, this case statement you compare two columns and you get a result this a little weird,

just think about it OBIEE execute this code

SELECT

CASE WHEN "Bill Customers"."Bill Customer Party Number" = "Ship Customers"."Ship Customer Party Number"

THEN 'Sell to'

ELSE 'Sell thru' END

FROM "Your Subject Area"

The question is why are you using that, you just need 'Sell to' and 'Sell thru', as a workaround you could use this values

as a hardcode values:

And use your presentation variable in your report with syntax, in your FILTER of your REPORT:

'@{var_Pr}{DefaultValue}'

Kind Regards,

Thomas Dodds · Answer

The easiest way to get the report column and the prompt column the same is use the same presentation column -- you're best served by doing the case in a logical column and putting it in your subject area (sometimes I will create a sub-folder special for prompting and filtering for these types of columns) ...

Joe Choueiri-Oracle · Answer

@Joel Acha

How do you suggest the prompt should be created- because are few ways of doing right?