funkmonsteruk
IS-IT--Management
I'm running a query on a db2 database and i'm having problems using the max date as a condition. Basically the field is called diry_ts and it relates to several events within a particular case. I want the report to show me cases where the last diry_ts date is over a month ago, but the report is showing me all cases which have a diry_ts of over a month old, even if they have one that is more recent.
I'm thinking that the problem is with the object in the universe, as it seems to be ignoring the fact that i've set it up as a max dimension. However, because it's a db2 database i've had to use date(diry_ts) in the universe, does this have any effect on setting an object as a max dimension???
I'm thinking that the problem is with the object in the universe, as it seems to be ignoring the fact that i've set it up as a max dimension. However, because it's a db2 database i've had to use date(diry_ts) in the universe, does this have any effect on setting an object as a max dimension???
