replacing '#'-sign for 'not assigned' in queries
We're doing several queries on master data in BW 3.10 and I get '#'-signs ('not assigned') in queries in records that don't have a value for some of the infoobjects in the query.
I can't use a filter to eliminate the '#', because this would remove the complete record from the query.
Is it possible to replace the '#' with a alterative sign for indicating the value is not specified?
Thank you for your help, Kathrin!