Archives of the TeradataForum
Message Posted: Wed, 30 Apr 2008 @ 21:30:35 GMT
I now see the issue. When a WHERE is on the SELECT in the view, it is applied before the OLAP/STAT function (rows returned as expected) and when the WHERE is on the SELECT from the view, it is applied after the OLAP/STAT operation(can see this in an EXPLAIN)(no rows returned). It would appear to be a bug and you should probably report it to the GSC.
To get around it, you will either need to use the macro suggestion that I gave you earlier and pass a start and end date to the SELECT in the macro. Otherwise, you could create a table that contains one row and the row contains the start and end dates. Then you can join the real table and your date table together to eliminate rows that are not needed before doing the STAT function.
Hope this helps,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|