I have been having an issue with modifying the OOTB Scheduled Shipments report. This issue isn’t specifically with that report, but more so UD Fields in general. When I try to add UD Fields into my report they just return zeros. I know that there isn’t a problem within my SSRS report because when I go into SSMS I can query the Temp Tables directly and get nothing but zeros.
Also worth mentioning, whenever I run a similar query in a BAQ, I am able to see all of the fields values that have been returning 0 in the RDD.
So my question is, what is the difference in data sources between BAQ’s and RDD’s? Why/how could this be occurring?