This article addresses the requirement of Customer Exit variables in BW/BI Reports; in this article I’m explaining the following scenario…
In most of the Sales reports (Here I taken Sales example) users want to see the data in Two columns, i.e. in one columns the Sales details of given Date Range and in another column the Sales details of the previous month for the same date range.
Eg: Suppose user will give From Date : 01/05/2009 and To Date: 27/05/2009.
As per above date range in one column Sales details From Date : 01/05/2009 and To Date: 27/05/2009. And in another column Sales details From Date : 01/04/2009 and To Date: 27/04/2009.
To display the data in report as per above example, we need to use the Customer Exit Variable on Date (0CALDAY).
Along with the Sales information, Users want to display the Date Range details in the Columns headings. To display this Date Ranges in columns headings, we need to use the Text Variables.
Surendra Kumar Reddy Koduru