Avoiding # in BI reports
We all aware that in BI reports wherever if the characteristic value is empty (Null) we get it as '#' in the query o/p.
I have a requirment for example, if the Gender is not maintained then for a customer/employee and if i pull out the report based on Gender wise i will have 'M', 'F' and '#' in the output. but instead of '#', i need to display some text like 'Others'.
How can i acheive this.
Thanks in advance