How to Supress the symbol '#' in BEX
hi guys,
when the field in the ODS is empty the report in BEX is showing '#' symbol. we need to supress that in the output.please help.
Regards
Ravi.
_________________
Regards
Ravi
Fill the field ?
Seriously, search the forum on the keyword "suppress" using the search engine, and on the first page of results you will already see at least two subjects that are fitting your question. Read those topics (and maybe some others), it will maybe let you understand what to do.
Ch
Hi, patneedi
If you are in WEB environment, please check it out:
/forums/viewtopic.php?t=173243&highlight=remove
regards,
Tlpl
Hi, patneedi
If you are in WEB environment, please check it out:
/forums/viewtopic.php?t=173243&highlight=remove
regards,
Tlpl
Goog job Tlpl! You remembered even after >3 weeks!!
_________________
Keep smiling
Folks,
We did try out all the options for this case. With Bex analyzer reports using VB and for Web based environment using java script . Couple of hassles doing this way is the front ent OLAP processing time increases to a big extent reducing the performance in both the BEx and Web environment...particularly when having detailed reports. The other thing was when in the web environment with a download to excel/csv option, the scripting on the web works but the download part shows the "#". Any other workarounds in this case? Would be interesting to know.
Zork
Right click on the characteristic, choose Restrict.
Transfer the value '#' to the right side.
Right click and choose "Exclude from selection"
Click ok.
Hope this is what u are looking for.