:):):):)

Good Day,

I wonder if anyone could advise me on this. My statistical Oracle DB stores hourly values only, so a Query for a Metric(C1055) Daily value looks like this:
SELECT
  CGSP.DW_STAT_CELL_DIM.CELL_NAME,
  CGSP.DW_DATE_DIM.EVENT_DATE,
  SUM(CGSP.DW_NORTEL_CELL_FACTS.C1055)
FROM
  CGSP.DW_STAT_CELL_DIM,
  CGSP.DW_DATE_DIM,
  CGSP.DW_NORTEL_CELL_FACTS
WHERE
  ( CGSP.DW_STAT_CELL_DIM.CELL_KEY=CGSP.DW_NORTEL_CELL _FACTS.CELL_KEY )
  AND ( CGSP.DW_DATE_DIM.DATE_KEY=CGSP.DW_NORTEL_CELL_FACT S.DATE_KEY )
  AND (
  CGSP.DW_STAT_CELL_DIM.CELL_NAME = 'CXC012'
  AND CGSP.DW_DATE_DIM.EVENT_DATE = {d '2003-11-14'}
  )
GROUP BY
CGSP.DW_STAT_CELL_DIM.CELL_NAME,
CGSP.DW_DATE_DIM.EVENT_DATE

The Question: How to modify this to obtain one extra column showing a "Moving 7 Day Average" for C1055

whith a condition such as: EVENT_DATE BETWEEN SYSDATE-12 AND SYSDATE-5, for example.

Please help,

Gezza



N/A