Creating a Simple Drop Down box in Web Application Designer
Vishal Sanghvi replied
I think you are on WAD 3.5.
Well, in the settings of the DROPDOWN Box, you have to specify the characteristic on which you have to restrict (0FISCPER in this case).
Then you can specify the READ MODE (from Dimension Table (D) or Master Data (M) or Posted Value (Q) ).
You can also restrict the values displayed in Maximum Number of Values Displayed.
And then give the AFFECTED DATAPROVIDER. This is the most important part. Based on this, the Dropdown Box (Filter) values work and affect the Query Output.
Hope this solves your problem.