OBIEE 11G Adding a Graph to an Analysis

In this topic, you learn how to add a graph to an analysis, and how to apply a saved filter and format the graph.

Enhancing an Analysis by Adding a Graph

In this subtopic, you begin by creating a new analysis to which you add a graph and apply a named filter created in the first topic. Perform the following steps:
1 . Create a new analysis by using the same columns that you used to create Regional Revenue. Select New > Analysis on the global header. Use A - Sample Sales Subject Area.
Screenshot for Step
2 . Add C50 Region from Cust Regions, P1 Product from Products, and 1 - Revenue from Base Facts to Selected Columns.
Screenshot for Step
3 . Next, you will add a named filter that you previously created to limit the analysis to just Americas and EMEA data.
a. In the Catalog pane, navigate to locate your filter Americas and EMEA filter.
Screenshot for Step
b. Select the filter and click the Add More Options icon.
4 . a. In the Apply Saved Filter dialog box, select the Apply contents of filter instead of a reference to the filter check box. This option adds the filter as an inline filter, allowing you to make changes without changing the Catalog filter item. Note that if you do not select this check box, the filter is added as a named filter that you can view, but not edit.
Screenshot for Step
b. Click OK. The filter is added to your analysis.
Screenshot for Step
5 . Save the analysis to your Regional Revenue folder, entering Regional Revenue Graph as the analysis name.
Screenshot for Step
6 . You will add a graph to this analysis.
a. Click the Results tabbed page, and click the New View icon.
Screenshot for Step
b. Select Graph > Bar > Default (Vertical) from the menus.
Screenshot for Step
The default Graph view appears below the Table view.
Screenshot for Step
7 . Click the Remove View from Compound Layout icon for both Title and Table views.
Screenshot for Step
Both views are removed from the Compound Layout. Note however, that they are still available for use from the Views pane.
Screenshot for Step
8 . Save the analysis.

Formatting the Graph

To enhance the appearance of a graph, perform the following steps:
1 .
Click the Edit View icon to begin your formatting changes. The Graph editor appears.
Screenshot for Step

2 .
The Graph, like other view editors, is composed of three sections:
Toolbar Screenshot for Step
The toolbar allows you to change graph types and subtypes, print, preview, edit graph properties, and so on.
Preview pane Screenshot for Step
The preview pane is a dynamic view of the graph, allowing you to view the changes instantly.
Layout Screenshot for Step
The layout allows you to change the properties of prompts, sections, measures, and so on, and allows you to regroup columns for graph display.
3 .
Click the Edit properties icon.
Screenshot for Step
The Graph properties dialog box appears.
Screenshot for Step
The Graph properties dialog box is composed of four tabbed pages: General, Style, Scale, and Titles and Labels. These tabbed pages allow you to do the following:
General Set properties related to the graph canvas, such as canvas width, height, legend location, and so on.
Style Set properties that control the appearance of the graph such as plot area and gridlines.
Scale Set properties for parts of the graph (axis limits and tick marks).
Titles and Labels Set properties that control the display of titles and labels for the graph.

4 .
a. Select Enable for Horizontal Axis from the "Zoom and Scroll" check boxes. When zooming and scrolling is enabled for a graph, then the graph includes a Zoom icon. The Zoom icon allows you to zoom in and out of a graph's plot area via its axes. Once you zoom in on an axis, you can scroll the axis. When you zoom an axis, a zoom and scroll slider appears.
b. Select left from the Legend location drop-down list. The dialog box should look like this:
Screenshot for Step
Note: The "Animate graph on Display" checkbox specifies whether to show initial rendering effects and is selected by default. For example, the bars on a horizontal graph start at the x-axis and move up the scale on the x-axis to the current measurement level.
"Listen to Master-Detail Events" allows you to specify this analysis as a detail view in a master-detail relationship. You will use this option in a subsequent step when working with pivot tables
5 .
a. Click the Style tabbed page.
Screenshot for Step
b. Click the Style drop-down list for Graph Data and select Gradient. The Graph Data area allows you to choose a style for specific types of graphs. For example, you might choose pattern fill for to highlight differences on a line-bar graph or gradient for a bar graph to make the data values standout.
6 .
Click the Background drop-down list in the Plot area, and select a light blue color from the Color Selector. Click OK.
Screenshot for Step
The Graph properties dialog box should look like this:
Screenshot for Step
7 .
Click the Scale tabbed page. The Scale tabbed page appears.
Screenshot for Step
Specifying setting for the axis limits and tick marks enables you to control what you see on your graph. If you override the system default for tick marks, the colors that you have selected for horizontal and vertical gridlines on the General properties tabbed page will be applied to both major and minor ticks.
8 .
a. Click the Titles and Labels tabbed page.
Screenshot for Step
b. Deselect the check box for Use measure name as graph title and enter Regional Revenue in the Title text box.
Screenshot for Step
c. Click the Format Title icon Screenshot for Step for Graph Title.
The "Font Format: Title" dialog box appears. You use this dialog box to specify how titles, legend labels, and so on are handled (such as truncated automatically) and to specify font properties. Click Cancel.
Screenshot for Step
9 .
Deselect the check box for Vertical Axis Title and click OK to close the Graph Properties dialog box.
Screenshot for Step
The preview pane refreshes and should look like this:
Screenshot for Step
Examine the changes that you made to the graph. The formatting changes have been applied along with a new title and a horizontal zoom.
10 .
Click the Zoom icon and select Zoom In.
Screenshot for Step
Once you have zoomed in, a slider appears.
Screenshot for Step
11 .
a. In the Layout pane, move C50 Region from the Group By drop target to the Graph Prompts drop target. The preview pane refreshes:
Screenshot for Step
The prompt allows you to select each region individually, making the graph a bit easier to consume.
b. Move C50 Region to the Sections area and select the Display as Slider check box. The Graph editor should look like this:
Screenshot for Step
When you move along the slider for a particular region, the graph changes accordingly.
c. Click Done and then save your analysis.
Screenshot for Step
You can further experiment with the region slider by clicking the C50 Region or Americas link.
The graph display changes accordingly.
Screenshot for Step

No comments:

Post a Comment

Popular Posts