Special thanks to Justin Molenaur and Krishna Tangudu for making this better.īased on comment, this document was modified on May 2, 2016. Create Calculation View based on direct base table in each projection node.No Analytic view will be created instead base table will be used directly.Calculated Column ( VALUE) is created in each Projection node which derives the value of a particular month in a year.Create Calculation View based on general Analytic View created above and join them together using Union with Constant Value.In this case we select 6 measures M_JAN, M_FEB, M_MAR, M_APR, M_MAY, M_JUN in addition to common attributes.1 general Analytic view will be created instead of several Analytic views in which selected attributes and measures will be selected.No need to create Calculated Column ( MONTH) in each Analytic view as this can be derived in Calculation View to improve performance.Create Calculation View based on Analytic Views created above and join them together using Union with Constant Value.Calculated Column ( VALUE) is created in each Analytic view which derives the value of a particular month in a year.In this case 6 columns need transposition, hence 6 Analytic views will be created.Analytic view will be built on each base table column which needs transposition.Special thanks to Pradeep Gupta for making this document more better than before.
0 Comments
Leave a Reply. |