While i'm hooked up to the internet, thought i'd ask another one which is causing me some probs...
I have a BO hooked upto a db2 database and one of the objects in my universe is a timestamp in a diary, i have prefixed the object in the universe with the date function DATE(Timestamp) and i have set the object as a measure to show the Max item...
Now i'm using this object in a report criteria and it's causing me a few problems, basically if the max date doesn't fit the criteria that i have imposed the bo reports on one of the previous entries which isn't a max date.
EG...
b - 1 - 02/01/2003
a - 1 - 01/01/2003
b - 2 - 05/01/2003
a - 2 - 07/01/2003
If i impose a condition that maxdate is less than 06/01/2003 then i would only expect b -2 to be returned (as a's max date is after criteria), however both b - 2 and a -1 are being returned...
Any ideas??
I have a BO hooked upto a db2 database and one of the objects in my universe is a timestamp in a diary, i have prefixed the object in the universe with the date function DATE(Timestamp) and i have set the object as a measure to show the Max item...
Now i'm using this object in a report criteria and it's causing me a few problems, basically if the max date doesn't fit the criteria that i have imposed the bo reports on one of the previous entries which isn't a max date.
EG...
b - 1 - 02/01/2003
a - 1 - 01/01/2003
b - 2 - 05/01/2003
a - 2 - 07/01/2003
If i impose a condition that maxdate is less than 06/01/2003 then i would only expect b -2 to be returned (as a's max date is after criteria), however both b - 2 and a -1 are being returned...
Any ideas??