Flat 10% & upto 50% off + Free additional Courses. Hurry up!

Advanced Analysis and Reporting


Analyzing worksheets by entering dynamic input values:

The following steps will walk you through the process of creating a month parameter:

  • In the Discoverer Plus menu, choose Tools | Parameters… to launch the Edit Worksheet dialog at the Parameters
  • the Parameters tab of the Edit Worksheet dialog, click the New… button to open the New Parameter dialog shown in the following screenshot:

Check the Intellipaat OBIEE online training course to get ahead in your career.




  • On the Parameters tab of the Edit Worksheet dialog, in the Available parameters box you should see the month entry.
  • the New Parameter dialog, leave the other settings at their defaults and click OK to come back to the Parameters tab of the Edit Worksheet
  • In the New Parameter dialog, enter Which month do you want to analyze? in the What prompt do you want to show for this parameter? edit box.
  • In the New Parameter dialog, make sure that the Create condition with operator: checkbox is set and the operator in the list on the right is =.
  • In the New Parameter dialog, select “Orddate: Month” in the Which item do you want to base this parameter on? list.
  • In the New Parameter dialog, enter month in the What do you want to name this parameter? edit box.
  • n the Edit Worksheet dialog, click OK to complete the creation of the parameter and come back to the worksheet.
  • Before the worksheet is displayed, the Edit Parameter Values dialog shown next will be displayed, prompting you to enter the month id:





  • You can enter, for example, Jan, and click OK. As a result, you will see the worksheet containing only January figures.
  • To save the parameter, so that it persists the current session, select the File | Save menu option of Discoverer.

"0 Responses on Advanced Analysis and Reporting"

Training in Cities

Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Chicago, San Francisco, Dallas, Washington, New York, Orlando, Boston

100% Secure Payments. All major credit & debit cards accepted Or Pay by Paypal.


Sales Offer

  • To avail this offer, enroll before 04th December 2016.
  • This offer cannot be combined with any other offer.
  • This offer is valid on selected courses only.
  • Please use coupon codes mentioned below to avail the offer

Sign Up or Login to view the Free Advanced Analysis and Reporting.