How to pass Characterstic varialble in WAD using button.

[anshu_lilhori]

Hello Gurus,

I have one requirement in WAD 7.0.i have made one user input characterstic variable in Bex i.e on 0calmonth.Now i have passed the same variable in WAD drop down button.Now suppose based on the logic on that variable which i have made in bex is like when i select 04.2010 in drop down button it dispalys data for next three months.

Now my user wants same thing to be displayed with the help of button as well. I need to make two buttons one for previous month and other for next month.I made two button using button group and passed that variable also but data is not changing.

How to get the desired output using buttons.

I want two buttons like this <<(previous) >>(next) and i want to pass that same variable which i passed in drop down button and when i press previous button it should display last month data and when i press next it should display next month data.

How to achieve this in WAD with the help of buttons.Give me your useful suggestions.

Hope my requirement is clear.

Thanks in advance

Regards,

AL

[Former Member · Accepted solution]

HI,

You have to create two more customer exit variables - for next month and previous month and assign them to the buttons in WAD.

Hope this helps.

Regards

Suvarna

[anshu_lilhori · Accepted solution]

give me some suggestions which i can do at wad level like using java script and all

[Former Member]

Hi, Have you checked this out. There's a command OPEN_VARIABLE_DIALOG. You can create a 'Button' in a 'Button Group' & label it 'Change Month' (Assuming the Month Input you've used is a simple variable). Under Action > Command : OPEN VARIABLE_DIALOG. Further this is allow the variable dialog box for choosing month to be displayed at run time inside the report's layout itself. If users aren't happy with such an approach, and would like to continue with >> & << (Previous & Next) Month, as said previously you'd have to use customer exit variables which pass data to get offset values. If not you can try this also: In BEx query create a small strcuture like this: M-1 ... M ... M1. Hide the values of M-1 & M1 offsets. Later you can add a 'Radio Button' linking this structure. If you're using Radio Buttons, only data for 1 month is displayed. So, you need to use command SET_ITEM_PARAMETERS for the radio button linking it with a dummy button, where command is to hide/display the radio button; CLEAR the hidden offsets in the structure if you want the months visible. This helps you toggle the 1st & 3rd elements via the BEx structure, rather than using a button. Thanks!

[anshu_lilhori]

Thanks for your detailed answer.I want that previous and next month button approach only,can you give detail explanation on how to create that customer exit variables with offset and all and same how can it be passed to those buttons.

If you can give step by step solution,it would be really helpful.

Regards,

[Former Member]

Hi,

Just came across some doc posted by a fellow SDN member PrashanthK that may help you with Customer Exit Variable creation

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f002c608-2533-2c10-25a1-d0e7f7b5b...

Once you have created your Customer Exit Variables you may create the following Commands to have their values assigned to the << >> Buttons as follows & check if it works for you :-

Action -> Command via Command Wizard, Command -> Commands for Data Providers -> Data Commands for Filter Values -> SET_SELECTION_STATE_SIMPLE -> select the Data Provider assigned to the DropDown webitem -> select 0CALMONTH as your Characteristic, Sign -> INCLUDING, Operator -> EQUAL_SELECTION, Equals -> SINGLE_MEMBER_EXIT, Exit Variable -> specify your Customer Exit Variable here.

--Priya