If we have a requirement to have case statement on column and it has some filtering condition on it. Filtering cannot be achievable by make use of presentation case statements or Bins, but using repository it’s possible.
Create a new logical column with required case statement in repository pull it on to Presentation, this will works fine with all filters.
Just to demonstrate I have made a dash board page with page prompt and report. Page prompt consist rpd case statement column and also presentation case column. Report consists of same above columns and one measure in a table.
Now if you try selecting any value in presentation case prompt, report will not effected with selection where as rpd -coulmn will be works fine.
Under line concept is using rpd column formula will be placed in physical SQL’s Where clause as well as Select, contrast Bins(presentation case) – column will put case statement in only SQL’s Selection clause.
Hope helpful to you
Posts
