This content has been marked as final. Show 6 replies
You have a better choice on the performance side.
Replace your case when by:
In the Presentation Layer of the repository make the following alias in the led table:
- JAN for the column YTD1
- FEB for the column YTD2
- MAR for the column YTD3
With this solution, you will not fire the "case when" and you will then read the data of only one column.
Furthermore, if you implement aggregate navigation, your related query will use it.