Create Dimension Sales_Dimension
Level Cust_Id Is Customer_Hierarchy.Cust_Id
Level Zip_Code Is Customer_Hierarchy.Zip_Code
Level Region Is Customer_Hierarchy.Region
Level Day Is Time_Hierarchy.Day
Level Mmyyyy Is Time_Hierarchy.Mmyyyy
Level Qtr_Yyyy Is Time_Hierarchy.Qtr_Yyyy
Level Yyyy Is Time_Hierarchy.Yyyy
Hierarchy Cust_Rollup
(
Cust_Id Child Of
Zip_Code Child Of
Region
)
hierarchy time_rollup
(
Day Child Of
Mmyyyy Child Of
Qtr_Yyyy Child Of
Yyyy)
Attribute Mmyyyy
determines mon-yyyy;
<< 이렇게 작성했는데 잘못된 코드있으면 알려주시면 감사하겠습니다.