Drill Through is a feature in FDMEE that allows users to see where the data is coming from. When data is loaded through FDMEE, there is a Source and a Target Application. The Source is where the data comes from, and the Target Application is where the data is loaded to. The Drill Through feature gives the user the ability to see what the data looked like in the Source, while they are using the Target Application. Since Drill Through is accessed in the Target Application, the Data Mappings must use at least one explicit mapping in order for the Drill Through to work. There is an Application Option to enable Drill Through, called ‘Drill Region’, which is located in the Target Application Settings (shown at the bottom of the screenshot below).
There is also a ‘Drill Region’ setting in the corresponding Data Load Rule that must be enabled.
Once the data has been exported to the Target Application using a Data Load Rule, open the Target Application and view the data. In this case, the Target Application was a Hyperion Planning application, called HP, and the data was viewed using a Data Form. When the Data Form is open, if a cell is selected and can be drilled through, the cell will say “This cell is drillable” as seen below.
To open the Drill Through, right-click on the desired cell and click ‘Drill Through’.
Then, click on ‘Drill Through to source’.
This will Launch the Drill Through Landing Page, which opens another tab in Workspace. Here you can see how the intersections of data were set up in the Source. In this example, an explicit mapping was used for the ‘UnitFlows’ dimension. The explicit mapping linked the [None] member from the Source, to the [UnitFlowsNone] member in the Target Application. [None] is shown in the screenshot below, while [UnitFlowsNone] is shown in the Target Application’s POV in the screenshot above.
A Better Solution Through OneStream Software
FDMEE is a data integration tool used in Oracle Hyperion software products. At the time of the original publication of this article in May 2015, Hyperion once was a premier software tool for Enterprise Performance Management (EPM) or Corporate Performance Management (CPM).
Since our origination in 2012, HollandParker is a CPM software consulting firm that specializes in best-of-breed CPM software implementation solutions for Fortune 500 corporations and global enterprise companies to medium and small businesses across North America. From 2012 to 2017, we supported Oracle performance management products. Now, the market has changed. OneStream Software is the leader in corporate performance management solutions for global organizations of all sizes, providing a single platform, OneStream XF, that replaces fragmented legacy applications.
In 2015, our partnership with OneStream began. And, due to client demand, we made a 100 percent business commitment to the OneStream partnership in 2017. OneStream has created a series of capabilities that all naturally live and work together so that organizations don’t have to do the hard part of integrating or connecting separate technologies together. OneStream XF simplifies data integration through direct integration and powerful pre-built XF Integration Connectors with drill back and drill through capabilities.
We are proud of our 100 percent company dedication to OneStream and to be a top OneStream Implementation Partner with Diamond status. Find out more about migrating to OneStream and our Diamond OneStream Implementation process by contacting HollandParker today.