I am having problems with displaying the correct data in the Pay scale Level field we are using. The following are the ONLY three results that can be displayed: 1, 2 and Blank is the data is not 1 or 2. The issue is that, the data that is 1 or 2 is working fine, but the fields that are suppose to be blanks (Emty), are not emty, they are filled up with the all are getting filled up like this: "10/R1/SV/1/LEVELMG1/" I have checked the data in the cube and it seem fine, the tables are all having emty feilds, but in the reports they are not. Also, I have gone thru all the display settings and that figured out that I've tried everything I can but even that is not working out for me. I know Im suppose to have the data in this feild displayed as Text.