bing
Flat 20% & upto 50% off + Free additional Courses. Hurry up!
×
UPTO
50%
OFF!

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.

f

 

 

  • 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:

 

g

 

 

  • 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"

Leave a Message

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

Sales Offer

  • To avail this offer, enroll before 28th February 2017.
  • 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
offer-learn-more-image

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