I'm on BI7 using the BEX Query Designer to build the Query. When I run the query using BEX Analyzer where there are blank records I get the word Not Assigned. I can see from other postings that this isnt and uncommon problem. However I dont really understnad the fixes people have suggested. I can see when it's web based people are suggesting Java script. However as I'm using the designer and the analyzer I can see that people are suggesting Macro's to fix this. How would I implement that I can remove "Not Assigned" and perhaps just have a blank.