Arrow Storage Products EN106 Guía de usuario descargar pdf (Pagina 103)

Figure 96 Result of Pivoting in an Asymmetric Report

Essbase combines the Product members into all unique members. For example, Root Beer, which

is displayed twice in Figure 95 on page 102, is displayed only once in the current view. Colas,

which is displayed in only one market in Figure 95, now is displayed in East and West.

Essbase also removes the blank line between Product row groups. A pivot action always

eliminates any rows or columns in which all cells are empty.

2 Close the sample file without saving the changes.

Drilling Down to a Sample of Members

Essbase is a multidimensional database engine that provides support for ad hoc analysis. Such

analysis is entirely driven by the intuition of the analyst and can be time-consuming as data

volume increases. Large cubes tend to have more dimensions and sometimes more levels, making

hierarchical navigation very cumbersome.

By drilling down to a portion of the members in an Essbase database, you can quickly analyze a

large multidimensional database with a focus on data trends. This type of drilling down is also

called “metadata sampling.”

Metadata sampling enables you to analyze on large cubes with a focus on data trends or to

approximate information in the initial stages. Because you query on a “sample” of the members,

retrieval is quick. Metadata sampling enables you to drill down to a portion of the vast number

of members of an Essbase database in a fraction of the time that it usually takes to analyze the

entire Essbase database. You can view many samples in a small amount of time and make early

decisions. Later, you can follow up with organized data exploration.

With the introduction of Hybrid Analysis, you can store part of an Essbase cube in a relational

database. Metadata sampling enables you to drill down on all members that you specify, whether

they reside in Essbase or in an underlying relational database.

To drill down to a sample of members, you must to connect to a server, an application, and a

database. Next, enable sampling in the Spreadsheet Add-in for Excel and set a percentage amount

of data to query when drilling down to more detail (performing a Zoom In operation).

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

only.

In Spreadsheet Add-in, to drill down to a sample of members:

1. Select Essbase > Sample Data (Zoom In) to enable sampling.

A check mark displayed next to the Sample Data (Zoom In) menu command indicates that sampling is

enabled.

Performing Advanced Retrieval Tasks

103

1 2 ... 98 99 100 101 102 103 104 105 106 107 108 ... 199 200

Sin comentarios

Arrow Storage Products EN106 Guía de usuario Pagina 103