How to Supress the symbol '#' in BEX

Question:
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
Answer:
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
Answer:
Hi, patneedi
If you are in WEB environment, please check it out:
/forums/viewtopic.php?t=173243&highlight=remove
regards,
Tlpl
Answer:
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
Answer:
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
Answer:
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.

More Articles:

Master data?
creating header tables as master data?
Deleting Icube Contents, best practice?
Problem with Update mode : S?
Push Data into BW from XI?
Reassign or Change the Workflow Task Agent?
Support Packages when to apply the latest?
Documentation on virtual characteristics?
CO-PA System could not find a source of data that coul?
multiple Jobs for Queued Delta/V3?
EBP: How to load EBP Purchase Order to BW (0BBP_PO_TD_1)?
Changing the characteristics length?