I'm relatively new to Omniture, and am trying to clean up an existing instance. One issue we're having - that has MOSTLY been cleaned up by Tealium before Adobe ever gets it, but not totally - is mixed case results not aggregating together.
For example, my prop1 is the page URL. Somehow I still have entries for both Login.aspx and login.aspx separately. The woman who views these reports is essentially begging us to get rid of the split and somehow get everything the same case. According to everything I've found online, this supposedly happens as of about 2012. However, my reports disagree.
To clean up the mixed case values of the historical prop data and combine login.aspx and Login.aspx you can you use Traffic Classifications (formerly SAINT). You can use the =LOWER() formula in Excel to convert all your prop variable "Keys" to lower case classified values. See screen shot below.