Category Archives: Uncategorized

Year to Date selection in SAP BI4

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:

  1. When dealing with large data volumes, the performance can be compromised.
  2. 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.

Continue reading