In a previous post I explained how to display Year To Date values. In that particular example a WebI user was prompted a month and based on that input the YTD (*) values are calculated in the WebI document. This approach has two big disadvantages:
- When dealing with large data volumes, the performance can be compromised.
- The solution is not reusable over WebI reports without manually recreating the logic.
One of my colleagues, Frits Nagtegaal, recently pointed me to a different and more elegant approach for calculating To Date values. In this post I will explain how to implement a YTD value that is calculated in the DB layer.