Arrow Storage Products EN106 Guia do Utilizador descarregar pdf (Página 133)

Figure 140 Bar Chart Showing Product 100-10 East as Most Profitable by Sales

You are now ready to pass the data from the visual worksheet into an Excel worksheet in

Spreadsheet Add-in.

This task is optional. Optional tasks do not need to be performed as part of the tutorial. They are provided for information

only.

In Visual Explorer you can further analyze the data in the Sample Basic database by completing any of the following

tasks:

● Drag State from the Database Schema and drop it on the Page shelf.

The view is recalculated to view the data for individual states. The Current Page shows that we are viewing

data for New York. For example, hover over the bar for Cola in New York in the East region during Qtr1, and

the popup shows that the Sales total for New York in that quarter is $1,998.00. Click the right direction arrow

or use the drop-down to view data from another sate.

● Drag Gen3, Population from the Database Schema and drop it on the Groups shelf.

The view is recalculated so that each column is now broken into market size based on population, separated

by lines. Hover over individual sections and view Sales data by market size.

14 In Oracle's Hyperion® Essbase® Visual Explorer, select File > Export > Cross-tab to Excel to transfer data

from the visual worksheet to worksheet in Excel.

Note:

Alternatively, you can select File > Update Excel (New Worksheet) to transfer the data from the

visual worksheet to a new worksheet in Excel.

Using Linked Reporting Objects

A linked reporting object is an external file, cell note, or World Wide Web resource that you link

to a cell in an Essbase database. The file, note, or Web resource (indicated by a URL, or Uniform

Using Linked Reporting Objects

133

1 2 ... 128 129 130 131 132 133 134 135 136 137 138 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 133