Drilling Through

Oracle Hyperion Financial Data Quality Management, Enterprise Edition provides the framework to drill through from EPM applications back to the general ledger source. Drill through is not supported for human resource data. Users can drill through to detail in the source system through FDMEE.

The ability to create a drill region is enabled in Target Application options. FDMEE creates drill region by scenarios. For any cube (Planning plan types or Essbase databases, the name of the drill region is FDMEE_<name of the scenario member). When creating the drill region, FDMEE checks if a dimension is enabled for the drill. Members of enabled dimensions selected in data loads, are included in the drill region filter. If no dimensions are enabled, the following dimensions are enabled by default: Scenario, Version, Year, and Period. You can enable additional dimensions, and the subsequent data load considers members of newly enabled dimensions. If you disable any dimensions which were previously included in a drill region used for drill creation, members of such dimensions are not deleted during the subsequent data loads. If needed, you can remove obsolete members manually.

Note:

If the source system is Oracle E-Business Suite/PeopleSoft and you have metadata rules, then the drill region is created based on the metadata rule. Otherwise, it is created based on the target members in the data load mappings. For Year, Period, and Scenario, FDMEE uses audit information to create the drill region.

Note:

In Oracle Smart View for Office and Oracle Hyperion Financial Reporting, you can drill through only if the data source is Oracle Hyperion Financial Management, Oracle Hyperion Planning, Oracle Essbase, and Oracle Hyperion Profitability and Cost Management.

Note:

Drill through is not supported for Financial Management journals and intercompany transactions.

When you drill through, if data was loaded by FDMEE, a landing page is displayed in a new Oracle Hyperion Enterprise Performance Management Workspace tab or a new window. The landing page is a gateway to the data in the source system. See Drilling Through to the FDMEE Landing Page.