Now, we can get the following result by the type "Calendar" in the Extract in the Jedox ETL.
level1;"level2";"level3";"level4"
All Months;"Half year 1";"Quater 1";"Jan"
All Months;"Half year 1";"Quater 1";"Feb"
All Months;"Half year 1";"Quater 1";"Mar"
All Months;"Half year 1";"Quater 2";"Apr"
All Months;"Half year 1";"Quater 2";"May"
All Months;"Half year 1";"Quater 2";"Jun"
All Months;"Half year 2";"Quater 3";"Jul"
All Months;"Half year 2";"Quater 3";"Aug"
All Months;"Half year 2";"Quater 3";"Sep"
All Months;"Half year 2";"Quater 4";"Oct"
All Months;"Half year 2";"Quater 4";"Nov"
All Months;"Half year 2";"Quater 4";"Dec"
We hope to get the following result by the type "Calendar" in the Extract in the Jedox ETL.
level1;"level2";"level3";"level4"
All Months;"Half year 1";"Quater 1";"Aug"
All Months;"Half year 1";"Quater 1";"Sep"
All Months;"Half year 1";"Quater 1";"Oct"
All Months;"Half year 1";"Quater 2";"Nov"
All Months;"Half year 1";"Quater 2";"Dec"
All Months;"Half year 1";"Quater 2";"Jan"
All Months;"Half year 2";"Quater 3";"Feb"
All Months;"Half year 2";"Quater 3";"Mar"
All Months;"Half year 2";"Quater 3";"Apr"
All Months;"Half year 2";"Quater 4";"May"
All Months;"Half year 2";"Quater 4";"Jun"
All Months;"Half year 2";"Quater 4";"Jul"
