Skip to Content


Hello Folks,


This Blog will help you to understand on how to address YTD, which is more of a common scenario in SAP Bex reports.


Problem Description:


To apply Year to Date filtering which is a more common scenario with SAP Bex Reports.


YTD: Year To Date – The report should show the values from starting day of the year till the date provided by the user


We need to define an input parameter to take the input of the day value till which the report has to be shown as done below:


Screen Shot 2013-12-26 at 1.13.08 PM.png


Now we need to create a calculated column to define the “FromDay” as shown below:


Screen Shot 2013-12-26 at 1.13.56 PM.png


We have a functionality named “Expression” in Calculation View (Graphical) in Projection or Aggregation nodes


We need to define the filter expression as shown below:


Screen Shot 2013-12-26 at 1.14.38 PM.png


Connecting to Analysis Office:


1) Selecting the data source to login to the relevant SAP HANA database as shown below:


Screen Shot 2013-12-26 at 1.15.53 PM.png


2) Choose the data source and login as shown below:


Screen Shot 2013-12-26 at 1.16.31 PM.png


Output in AO:


Screen Shot 2014-04-21 at 3.24.33 PM.png


If you see carefully in the output, i have applied cross tab to get the output in the way we get in Bex using customer exit.

We can also apply other KPI scenario’s like Previous Year Vs Current Year comparison, etc..


Hope this blog is helpful to you. Do share your feedback on the same.


Hope you understood on how to apply YTD when using SAP HANA with SAP BO Analysis Office as reporting tool.


Your’s,

Krishna Tangudu



To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply