Skip to Content
0
Jan 27, 2011 at 05:54 AM

Replace # with blank in query output

21 Views

Dear All,

If anyone came across below requirement, please share your thoughts.

In my cube I have :

company code Material Movement type Net sales

100 M001 101 100 INR

100 M002 150 INR

200 M001 200 INR

In query

Actual result :

company code Material Movement type Net sales

100 M001 101 100 INR

100 M002 # 150 INR

200 M001 # 200 INR

Expected result: (client wanted to see movement type as blank instead u201C#u201D)

company code Material Movement type Net sales

100 M001 101 100 INR

100 M002 150 INR

200 M001 200 INR

Note: Output environment is portal (BEx WAD).

We have already tried the option of virtual chars, but it is not working.

Thanks.

Raja