About using worksheet parameters in Discoverer portlets

If you create Discoverer portlets that contain worksheet parameters, you can map the worksheet parameters to page level parameters. This enables a portlet user to specify a parameter value for a page level parameter to update many different Discoverer portlets at the same time. To accomplish this you must map the Discoverer worksheet parameter to a generic Discoverer portlet parameter. Then you create the Portal page parameter and map it to the generic Discoverer portlet parameter.

For example, you create three Discoverer portlets, each one containing a worksheet with a parameter called City_WS_param. While editing the defaults of each portlet, you map City_WS_param to a generic Discoverer portal parameter, say DiscoParameter1. Make a note of each generic Discoverer portal parameter and which worksheet parameters they map to so that you can correctly set up the Portal page level parameters.

When you get all three portlets on a Portal page, click on the Edit button and go to Page: Properties. Go to the Parameters tab of the Edit Page screen. If there is no suitable page parameter available, add a new page parameter called City_Page_Param. In the Page Parameter Properties section, you will probably want to make the parameter Customizable and may optionally set Display Name, Default Value and Description. In the Portlet Parameter Values section, for each appropriate portlet, map DiscoParameter1 to use Page Parameter City_Page_Param.

You can map parameters in both Worksheet portlets and Gauges portlets. In other words, you can update both Gauges portlets and Worksheet portlets at the same time with a single parameter value.

Users can set the value for a Page Level parameter either on the URL for the page (by following the Customize link for the page and going to the Parameters tab on the Customize Page screen) or by using a Simple Parameters Form Portlet if one has been added to the page and configured correctly.

For more information about mapping worksheet parameters to portal page level parameters, see "How to map worksheet parameters to generic Discoverer Portlet Parameters".