CREATE OR REPLACE ANALYTIC VIEW inventory_av
USING INVENTORY_FACT
DIMENSION BY (
inventory_attribute_dim KEY (LOCATION_ID)
REFERENCES (LOCATION_ID)
HIERARCHIES (inventory_hier DEFAULT)
)
MEASURES (
QUANTITY FACT QUANTITY ,
QUANTITY_SUM as (SUM(QUANTITY))
);