I have created (5) dropdown boxes outside of my container that drive the content of the (3) charts (calling BW Queries). So far everything appears to be working good.
Here is my question: One of my dropdown boxes is Fiscal Year (0FISCYEAR). When I open the Portal Page it says "Show All Values" and when you click on the downarrow it shows valid years 2006, 2007, ..., 2011, 2012 (which is all of our history in the cube). HOW do I get the page to run and show (by default) just the current year Ex: 2012, instead of running wide-open 2006-2012? I do not want the touch the query. Can I do anything within WAD so when the page loads it will show just the current year and then the user can choose a different year from the dropdown, if desired?
Also, can I pass the value choosen from any of the dropdowns and use those values within my Chart Title?
Ex: "Total Inventory Dollars for 2011", where 2011 is the value from the dropdown box
Any ideas or suggestions???
Thanks,
Tom