microsoft word - 05rd practices showingresultswithgaugeviews 5

8/11/2019 Microsoft Word - 05RD Practices ShowingResultsWithGaugeViews 5

1/11

RRI-TEC,#209,Nilagiri Block,Adithya Enclave @8790998182,8801408841

Practice 5-1: Showing Results as Gauges

Goals To use the Gauge view to show results as gauges in Oracle BusinessIntelligence Answers

Scenario You create a request and display results in a Gauge view using the DialGauge type. You set general background properties for the Gauge view,modify Gauge ranges, modify Gauge titles and footers, set advanced DialGauge properties, duplicate a Gauge view and use a different Gauge type todisplay results, and set Gauge interaction to navigate to a saved request.

Time 1520 minutes

Instructions:

1. If necessary, start Oracle Business Intelligence Presentation Services and log in asAdministrator.

2. Click Answers and select the SupplierSalessubject area.

a. Create the following request and associated filters:

Note:If you add the Date column to your request to create the filter, delete itfrom the request after creating the filter.

3. Click Results.


2/11


4. Add a Gauge view to the Compound Layout view.

a. Select Add View > Gauge.

b. In the Gauge view, in the Gauge drop-down list, select Dial.

c. In the Size drop-down list, select Small.

d. In the Measure drop-down list, select Dollars.

e. In the Marker Type drop-down list, select Line.

f. Click the Colorbutton to change the color for the indicator needle.

g. In the Color Selector dialog box, select blackas the color of the indicatorneedle and click OK.

5. Add another marker to the Gauges.

a. Click the Add Markerbutton.

b. In the Measure drop-down list, select Units Shipped.

c. Set Market Type to Line.

d. Change the units shipped marker color to bright green.

6. Set general background properties for the Gauge view.

a. Click the Gauge Canvas Propertiesbutton at the top of the Gauge viewpage.

b. In the Title section of the Gauge Canvas Properties dialog box, selectOverride default.

c. In the Title field, enter Q199 Revenue Units Shipped.

d. If desired, click the Edit Formatbutton next to the Title field to changethe format of the title.

e. Verify that legend location is set to Default. The default location of the legendis beneath the title.

f. If desired, click the Edit Formatbutton next to the Legend Location fieldto change the format of the legend.

g. If desired, use the Borders and Colors section to change the background colorfor the area in which the Gauges appear, the color of the title text, and the

color of the border around the Gauge area.

h. Change the number of Gauges per row to 4. The default is 3.

i. Change the space between Gauges to 50. The space between Gauges ismeasured in pixels.


3/11


j. Check your work. Your Gauge Canvas properties should look similar to thefollowing:

k. Click OKand check your results. There is a Gauge for each customer. Theblack line shows dollars. The green line shows units shipped. The Gauge

colors show the Gauge ranges. Please notice that the screenshot shows only

partial results.

7. Modify the Gauge ranges.

a. Click the Gauge Rangesbutton at the top of the Gauge view.

b. By default, the Gauge ranges for the Dial Gauge are set to show percentage oftotal. Currently, the Dial Gauge displays three percentage ranges. Click Addto add a fourth range.

c. Click the Colorbutton for the new range.

d. In the color field, select light blueand click OK.


4/11


e. Check your results. The Dial Gauges now display four percentage ranges andthe legend captions have changed to reflect the new ranges.

f. Which customers revenue for Q199 fell within the 50% 75% range?

g. Which customers revenue for Q199 fell within the 75% 100% range?

8. Modify Gauge titles and footers.

a. Click the Gauge Titlesbutton at the top of the Gauge view.

b. In the Title field of the Gauge Titles dialog box, enter Rev-UnitsShipped.

c. In the Sub Title field, enter Q199.

d. Notice that in the Footer field, the default is @1. This automatically includesthe results from column 1 (Customer in this example).

e. In the Secondary Footer field, enter @2 Region. This automatically includesthe results from column 2 (Region in this example) and appends the results

with the word Region.

f. If desired, click the Edit Formatbutton for any of the fields to changeformatting.

g. Check your work.


5/11


h. Click OKand check your results. Your Gauge view should look similar to thefollowing:

9. Set advanced Dial Gauge properties.

a. Click the Advanced propertiesbutton for the Dial Gauge. The DialSpecific Properties dialog box is displayed.

b. In the Show scale labelsdrop-down list, select Actual Value.

c. Under Dial Properties, set Dial Arc Length to 360and Dial Thickness to 5.

d. Click OKand observe the results. Gauges now appear as a complete circle,dial thickness is reduced, and dollar values appear as scale labels instead of


6/11


percentages.

e. Click the Advanced propertiesbutton for the Dial Gauge again and resetall properties to Default.

f. Click OKto close the Dial Specific Properties dialog box.

10.Set additional Gauge properties.

a. Click the Additional Gauge Propertiesbutton at the top of the Gaugeview. The Additional Gauge Properties dialog box is displayed.

b. Click the Appearancetab.


7/11


c. In the Show data labelsdrop-down list, select On rollover, which is the sameas Default. When selected, data labels appear when a user moves the cursorover the Gauge.

d. If desired, modify the background, text, and border appearance of the Gauges.

e. If desired, experiment with the size settings. The size is set by default whenthe Gauge size is initially selected. In this case, the Gauge size is set to small.

f. Your appearance settings should look similar to the following:

g. Click the Interactiontab.

h. Verify that Defaultis selected. This allows users to drill down on the Gauge

to retrieve detail results.i. If desired, click the Scaletab and experiment with Gauge limit and tick mark

settings.

j. Click OKto close the Additional Gauge Properties dialog box.

k. Place the cursor over the Gauges to verify that data labels appear.

l. Verify that other appearance settings are displayed as expected. Your resultsshould look similar to the following:

11.Create a duplicate Gauge view and use a different Gauge type to display results.


8/11


a. Click the Duplicate Viewbutton at the top of the workspace and selectDuplicate View to duplicate the current Gauge view.

b. Notice that Gauge:2now appears in the View drop-down list.

c. In the Gauge drop-down list, select Bar.

d. In the Type drop-down list, select Filled.

e. In the Measure drop-down list, select Dollars.

f. Click the Gauge Canvas Propertiesbutton and change the title to Q199

Revenue.

g. Click the Gauge Titlesbutton and change the title to Revenue.

h. Modify Gauge ranges and Gauge properties as desired.

i. Click the Additional Gauge Propertiesbutton at the top of the Gauge

view. The Additional Gauge Properties dialog box is displayed.j. Click the Interactiontab.

k. Select Navigateand click the Add Navigation Targetbutton.

l. Click the Browsebutton. The Choose Request/Dashboard dialog box isdisplayed.

m. Select one of your saved requests. This allows you to click a Gauge tonavigate to another request or dashboard.

n. Click OKto close the Choose Request/Dashboard dialog box.

o. Click OK to close the Additional Gauge Properties dialog box.

p. Check your work. Your results should look similar to the following:

12.Modify the Compound Layout view layout.a. Save the request asMy Gauge Viewin theMy Sales folder.

b. Select Compound Layoutfrom the View drop-down list.

c. Verify that the Compound Layout view contains three views: a Title view thatsays My Gauge View, a Table view with results from the original request, and

the Gauge view as it appeared before you duplicated the view.

d. Select Add View > Gauge:2 to add the duplicated Gauge view to theCompound Layout view.

e. Drag the Table view to display below the Gauge2 view.


9/11


f. Verify that the Compound Layout view now has four views displayed: Title,Gauge, Gauge2, and Table:

g. Save the request again asMy Gauge View.

h. Click Yeswhen asked to replace existing item with the same name.

13.Verify your work.


10/11


a. Click the Answerslink.

b. Verify that My Gauge Viewappears under My Sales in the selection pane.

c. Click My Gauge View.d. Click the bar gauge and verify navigation to the saved request you specified.

14.Leave Answers open for the next practice.


11/11


Solutions 5-1: Showing Results as Gauges

Answers

7.f. Which customers revenue for Q199 fell within the 50% 75% range?Palestine Club

7.g. Which customers revenue for Q199 fell within the 75% 100% range?

Compound

microsoft word - 05rd practices showingresultswithgaugeviews 5

Documents