Bex Customer exit Variable unable to filter correct data

620 Views

Hi Gurus,

My client is having requirement of dynamic dates display on column heading based on User input. Requirement as below

Input Screen

1. Product

2. Input Date(Single) mandatory - 30.11.2015

Output will be like this

Product Balance as on Prev Month(Dynamic Text) Deposit During Month Payments during month Balance as on till date(Dynamic Text)

I have to display report on Product Basis in which we have 4 keyfigures & below is detailed requirement

1. Balance as on Previous month :- If user input any date for e.g 30.11.2015 than result will displayed from starting date of business till last date of the previous month i.e 01.01.1990 - 31.10.2015.

2. Deposit During Month :- Based on user input the deposit(balance) must be displayed for full month i.e 01.11.2015 - 30.11.2015.

3. Payment During Month :- Based on user input the payments(balance) must be displayed for full month i.e 01.11.2015 - 30.11.2015.

4. Balance as on till date :- Based on user input result will be displayed from starting date of business till current date i.e 01.01.1990 - 31.10.2015.

To suffice the above requirement i have written code in CMOD & in Debugging mode all variables fetched correct values but values are not coming according to the variables. My report shows only data based on User input Date. I have used two characteristics variable & 2 Text variables for dynamic column heading details.

Note: Data is correct at Infocube level but BEX analyzer unable to display data according to User Entry. I am on SAP BW 7.4.

Regards,

Lalit Sachdeva