Drilling Down to a Sample of Members

To drill down to a sample of members, you must connect to a server, an application, and a database. Next, enable sampling in Spreadsheet Add-in and set a percentage amount of data to query when drilling down to more detail (performing a Zoom In operation).

  To drill down to a sample of members:

  1. To enable sampling, select Essbase, and then Sample Data (Zoom In).

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

  2. Select Essbase, and then Options.

  3. In Essbase Options, select Zoom.

  4. In Sampling Percentage, enter an integer between 1 and 100 to represent the approximate percentage of the Essbase cube to query during a Zoom In operation.

    The default value is 100.

    Note:

    If Hybrid Analysis is enabled and in use, the sampling percentage also applies to queries on the underlying relational database.

  5. To save these settings, click OK.

  6. In the spreadsheet, select the member on which to drill down.

  7. Select Essbase, and then Zoom In.

    For example, if you entered 50 in the Sampling Percentage box, approximately 50% of the members in the Essbase database, and, if applicable, from the specified columns of the relational database, are queried when you select Zoom In.

  To drill down to a sample of detail across columns, press Alt while double-clicking the member name to expand, and then release Alt.

Essbase expands the data into columns.

Related Topics

About Metadata Sampling