Depending on the type of Ad Hoc view you are using, there may be options on how to change the display of your data.
If you are using a Table view, it may help to click on options icon (cog wheel) and change the selection from Detailed Data to Totals Data.
If you are using a CrossTab View, you click on the – or + symbols to change what information is displayed.
It is also possible that the duplication is due to the setup of the data domain you are using. To discuss the creation of new domains for your data, contact CDS Support.