Smart View is the preferred spreadsheet client for performing drill-through on cubes created in Essbase Studio Server. When using Spreadsheet Add-in to perform drill-through, note the following limitations:
In Spreadsheet Add-in, to access drill-through reports from cubes built through Essbase Studio, users must be registered with Essbase Studio and be provisioned with, at a minimum, the Essbase Read role and the Essbase Studio cpViewer role.
When logging in to Essbase in Spreadsheet Add-in, login names and password are case-sensitive for users who are provisioned through Oracle's Hyperion® Shared Services.
When performing drill-through on cubes created from Essbase Studio, Spreadsheet Add-in does not support localization. To clarify, for Essbase Studio-built cubes, if the relational data source code page is not English, then drill-through does not work. This means that from Spreadsheet Add-in, you cannot drill through to non-English sources.
Use Smart View to access non-English sources.
Essbase Studio Server should be running in order to access drill-through reports on cubes created using Essbase Studio. If Essbase Studio Server is not running:
In Spreadsheet Add-in, a message is returned stating that there are no drill-through reports present.
In Smart View, a message is returned stating that Essbase Studio Server is not running.
In Spreadsheet Add-in, cubes built by Essbase Studio do not display the visual clues that denote drill-through cells. Because there is no way to know for certain which particular cells are drill-through cells, any data cell in the spreadsheet is a potential drill-through cell. To discover if a drill-through report is available on a particular cell, perform these steps:
Select a data cell, and then access the Linked Object Browser (either by selecting Linked Object Browser from the Essbase menu, or by double-clicking the cell).
Once launched, the browser automatically displays an entry indicating that a drill-through report is available from Integration Server. This is true whether or not a drill-through report is actually available from the selected cell.
Select the Drill-Through object in the list in the Linked Object Browser and then click View/Launch.
If one or more drill-through reports are available for the selected cell, the Available Reports dialog box is displayed listing those reports. In Available Reports, select the drill-through report to view and click Execute.
If no drill-through reports are available for the selected cell, a message is displayed indicating that there are no reports are defined for the specified intersection.