Base Unit of Measure(like CRT) and Currency not showing...

Dear All,

I have created a BEx Query and created a BICS connection on top of it. In the Dashboard Query Designer Base Unit of Measure like CRT and Currency like PKR are being fetching/displaying but these are not displaying on Dashboard object like List View.

1. Do I need to make necessary changes into Excel where the data being saved from queries?

2. What should I do to have my Base unit of Measure along with Currency(PKR)?

I will appreciate your reply.

Thanks!

Tariq Ashraf