You might be encountering this issue or something similar.  https://support.sas.com/kb/68/361.html Which version are you using?  ... View more

Hi!   I am having the same problem here.   I have an aggregate meassure which does the following:   If number_customer > 25 return number_customer else 0 I cannot make a filter over that aggregate.   Any ideas? ... View more

You are correct, that indeed seems to be the case. I did some testing and it appears that Aggregated Data Sources support f.ex. Aggregated (simple) and Aggregated (advanced) operators but not the Aggregated (periodic) operators.   Unfortunately I do not have another idea how to get the wanted end result.   Best regards, Petri ... View more

Yes, likely related to the different variable length and potential leading/ending spaces. You may also consider using numeric columns in this case (in both data sets). Unless necessary - your IDs could be simple numbers and you could apply formats such as .Z5 or similar to get the expected formatting. Would make your data set smaller as well - along with avoiding potential matching issues. Let us know how you go. Thanks, Falko ... View more

Yes, thanks, I was just doing it wrong.  I had pre-selected one data item before I tried to build the query and then I couldn't select any other data items.  If I build the query without pre-selecting a data item, they're all available to me in the query builder. ... View more

I deleted the old data item "Offence Day of Week" and created a new one by right-clicking on the "Offence TMST" (datetime) data item and selecting "Duplicate Data Item".  I renamed the new item to "Offence Day of Week" and applied the "Day, Date" format.    That gives me what I want -  "Offence Days of Week" of "Sunday", "Monday", "Tuesday", etc.  However, I have the same problem when I view the report - they change to "03Jan1960", "04Jan1960", "05Jan1960", etc.   Help!  Very frustrating! ... View more