Accessing the Data Cube

SELECT model, year, SUM(units) as total,

SUM(units)/total(ALL,ALL)

FROM Sales

WHERE model = ‘Chevy’

GROUP BY model, Year(date) as year with cube

Embedded SQL: Sales_cube.total(:m, :y)

Previous slide

Next slide

Back to first slide

View graphic version