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:
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.
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.
In the spreadsheet, select the member on which to drill down.
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.