The sample model that will be used has been described in the previous section, and this section describes the MDX statements that need to be executed to create that sample model.
This sample model data is already built into the EuclidOLAP service by default, so you don't need to execute the following statements yourself, just take a look.
create dimensions [Date] [Aircraft Type] [Service Type];
create levels [Date] (2:Year, 3:Quarter, 4:Month);
create members
[Date].[ALL].[2020].[Q1].[January],
[Date].[ALL].[2020].[Q1].[February],
[Date].[ALL].[2020].[Q1].[March],
[Date].[ALL].[2020].[Q2].[April],
[Date].[ALL].[2020].[Q2].[May],
[Date].[ALL].[2020].[Q2].[June],
[Date].[ALL].[2020].[Q3].[July],
[Date].[ALL].[2020].[Q3].[August],
[Date].[ALL].[2020].[Q3].[September],
[Date].[ALL].[2020].[Q4].[October],
[Date].[ALL].[2020].[Q4].[November],
[Date].[ALL].[2020].[Q4].[December],
[Date].[ALL].[2021].[Q1].[January],
[Date].[ALL].[2021].[Q1].[February],
[Date].[ALL].[2021].[Q1].[March],
[Date].[ALL].[2021].[Q2].[April],
[Date].[ALL].[2021].[Q2].[May],
[Date].[ALL].[2021].[Q2].[June],
[Date].[ALL].[2021].[Q3].[July],
[Date].[ALL].[2021].[Q3].[August],
[Date].[ALL].[2021].[Q3].[September],
[Date].[ALL].[2021].[Q4].[October],
[Date].[ALL].[2021].[Q4].[November],
[Date].[ALL].[2021].[Q4].[December],
[Date].[ALL].[2022].[Q1].[January],
[Date].[ALL].[2022].[Q1].[February],
[Date].[ALL].[2022].[Q1].[March],
[Date].[ALL].[2022].[Q2].[April],
[Date].[ALL].[2022].[Q2].[May],
[Date].[ALL].[2022].[Q2].[June],
[Date].[ALL].[2022].[Q3].[July],
[Date].[ALL].[2022].[Q3].[August],
[Date].[ALL].[2022].[Q3].[September],
[Date].[ALL].[2022].[Q4].[October],
[Date].[ALL].[2022].[Q4].[November],
[Date].[ALL].[2022].[Q4].[December],
[Aircraft Type].[ALL].[Boeing].[Boeing 747],
[Aircraft Type].[ALL].[Boeing].[Boeing 777],
[Aircraft Type].[ALL].[Boeing].[Boeing 787 Dreamliner],
[Aircraft Type].[ALL].[Airbus].[Airbus A380],
[Aircraft Type].[ALL].[Airbus].[Airbus A350],
[Aircraft Type].[ALL].[Airbus].[Airbus A330],
[Aircraft Type].[ALL].[Embraer].[Embraer E-Jets],
[Aircraft Type].[ALL].[Bombardier].[Bombardier CRJ],
[Aircraft Type].[ALL].[Sukhoi].[Sukhoi Superjet],
[Service Type].[ALL].[Premium Economy Class],
[Service Type].[ALL].[Basic Economy Class],
[Service Type].[ALL].[Economy Plus],
[Service Type].[ALL].[Business Suite],
[Service Type].[ALL].[Premium Business],
[Service Type].[ALL].[First Class Suite],
[Service Type].[ALL].[Private Jet Charter];
build cube [Airline Turnover] dimensions [Date] [Date] [Aircraft Type] [Aircraft Type] [Service Type] [Service Type] measures [Turnover];
insert [Airline Turnover]
([Date].[ALL].[2020].[Q1].[January], [Aircraft Type].[ALL].[Boeing].[Boeing 747], [Service Type].[ALL].[Premium Economy Class] measures [Turnover] 8683347),
([Date].[ALL].[2020].[Q1].[January], [Aircraft Type].[ALL].[Boeing].[Boeing 747], [Service Type].[ALL].[Basic Economy Class] measures [Turnover] 12506540),
([Date].[ALL].[2020].[Q1].[January], [Aircraft Type].[ALL].[Boeing].[Boeing 747], [Service Type].[ALL].[Economy Plus] measures [Turnover] 12193918), ...
To see the complete statement for inserting measures, look at file airline-turnover-measures.txt.