BI Publisher - CASE WHEN returns correct value on Tree View Only

Summary

CASE WHEN is returning the correct value when I view the data in tree view e.g. Home or Mobile etc on BI Publisher but when viewed on table view the database values are still being displayed

Content

My CASE WHEN is in the code snippet below.

 

 

Version

19B (11.13.19.04.0)

Code Snippet

(CASE WHEN pp.phone_type = 'H2' THEN 'Home Secondary' 
WHEN pp.phone_type = 'H1' THEN 'Home' 
WHEN pp.phone_type = 'M' THEN 'Mobile'
WHEN pp.phone_type = 'W1' THEN 'Work'
WHEN pp.phone_type = 'PM' THEN 'Personal Mobile'
WHEN pp.phone_type = 'WE1' THEN 'Work Extension'
WHEN pp.phone_type = 'WM' THEN 'Work Mobile'
WHEN pp.phone_type = 'H2' THEN 'Home Secondary'
WHEN pp.phone_type = 'H3' THEN 'Home Tertiary'
WHEN pp.phone_type = 'W2' THEN 'Work Secondary' ELSE 'Other' END) "Phone Type",