Approach 1:
- Analytic view will be built on each base table column which needs transposition.
- In this case 6 columns need transposition, hence 6 Analytic views will be created.
- Calculated Column (VALUE) is created in each Analytic view which derives the value of a particular month in a year.
- Create Calculation View based on Analytic Views created above and join them together using Union with Constant Value.
- No need to create Calculated Column (MONTH) in each Analytic view as this can be derived in Calculation View to improve performance.
