Problems with Precomputed Views under RedBrick 5.1
Hi folks!
I have a problem with a precomputed view ind Informix Redbrick decision
server datawarehouse (5.1):
create view UHRZEIT_AGG_VIEW (UHRZEIT_KEY,STUNDE,TIMESLOT) as
select UHRZEIT.UHRZEIT_KEY as UHRZEIT_KEY,
UHRZEIT.STUNDE as STUNDE,
UHRZEIT.TIMESLOT as TIMESLOT
from UHRZEIT
where UHRZEIT.MINUTE = 0
and UHRZEIT.SEKUNDE = 0
group by UHRZEIT.UHRZEIT_KEY,UHRZEIT.STUNDE,UHRZEIT.TIMESLOT
using UHRZEIT_AGG(UHRZEIT_KEY,STUNDE,TIMESLOT);
After sending this statement to the database I get the following response:
Statement #1: [Red Brick][ODBC Driver][Warehouse]** ERROR ** (1903) The
WHERE clause for the precomputed view is invalid.
But I'm sure, that the where clause ist correct! If I leave the where clause
out...
create view UHRZEIT_AGG_VIEW (UHRZEIT_KEY,STUNDE,TIMESLOT) as
select UHRZEIT.UHRZEIT_KEY as UHRZEIT_KEY,
UHRZEIT.STUNDE as STUNDE,
UHRZEIT.TIMESLOT as TIMESLOT
from UHRZEIT
group by UHRZEIT.UHRZEIT_KEY,UHRZEIT.STUNDE,UHRZEIT.TIMESLOT
using UHRZEIT_AGG(UHRZEIT_KEY,STUNDE,TIMESLOT);
...the view can be created. But all the rows are inserted! How can I make
the first statement work? Anybody?
Thanks in advance,
Peter Philipp