Создание OLAP-клиентов с помощью Excel и Microsoft PivotTable Services
Листинг 7
CREATE CUBE [OCWCube] ( DIMENSION <Dimension Name> [TYPE <Dimension Type>] LEVEL <Level Name>[TYPE <Level Type>], [LEVEL <Level Name> [TYPE <Level Type>]…], [[DIMENSION <Dimension Name> [TYPE <Dimension Type>] LEVEL <Level Name>[TYPE <Level Type>, [LEVEL <Level Name> >[TYPE <Level Type>…],…], MEASURE <Measure Name> FUNCTION <Function Name>, [MEASURE <Measure Name> FUNCTION <Function Name>,…] )