Oracle Hyperion data sources such as Financial Management, Planning, Essbase, and Hyperion® Reporting and Analysis repository can be imported as a function grid in Smart View. After the data is in the Office document, the metadata label or data source members in the query can be associated with XBRL concepts with the Disclosure Management Mapping Tool. When this association occurs, the XBRL concepts are recognized from the data source member when it is part of a Financial Reporting grid or another Office document. Therefore a data source XBRL map can be associated once and be consumed in and/or Financial Reporting grids.
Disclosure Management extends data source functionality by storing data source mappings on the server instead of the document. Key features associated with this functionality include:
Centralized storage of mappings which contains update-to-date information about the concepts, contexts and units referenced in the document. Since only fact values are stored with the document, the loss of element specific data is minimized.
Preparing data for instance generation is faster.
Context and units for facts can be changed independent of the original document.
You can create facts not associated with the document content (for example, “nil” values).
Disclosure Managementvalidates compatibility between the period type of a concept and the period type of a context at the time of mapping (before instance generation and validation).
An organized validation of compatibility between dimensions and primary items is performed.
Multiple mappings on the same value are now available.
A prompt that allows you to choose either one or multiple data sources for mapping an item. Additionally, you can see mappings to both data sources when they exist.
A “Remember choice” option is available to preserve data source selections as a default for future data source mappings.
XBRL contexts, units, and footnotes can be mapped after the data is in the Office document, but these maps persist only at the report or document level and are not considered data source maps.
You can import data using the following import formats in Microsoft Office:
Query ready (Excel only)
Fully formatted (Excel only)
Function grid (Microsoft Word and Excel)
You can use any of the queries or import formats for report-level mapping. You must use function grids for data source-level mapping.
Note: | Financial Management, Planning, and Essbase are the only sources supported for data source mapping. |