by Doug Correa | 10 24, 2015 | EPM, FDM, FDMEE
One of my seven year-old daughter’s favorite phrases is “easy, peasy, lemon squeezy”. She said it recently and I thought, You know, who doesn’t like when something goes as expected or when a product or service just works? Ultimately, technology exists to make life easier, right? Oracle EPM software is no different. This got me thinking about how FDMEE makes transforming and loading data in the Oracle EPM world easier than ever. Over the next couple of weeks, this series will show you 10 Incredibly Simple Things You Can Do in FDMEE. Tip 1 – Register a New Target Application Tip 2 – View an Execution Log Tip 3 – Download Metadata to Excel Tip 4- Use Lifecycle Management Tip 5 – Schedule a Job with Batch Processing Tip 6 – Map Blank Record Values Tip 7 – Filter Data Using Query by Example Tip 8 – Define Target Members Based on Multiple Source Values Using Multi-dimension Mapping Tip 9 – Use Advanced Search Tip 10 – Override Default Location Settings with Data Load Rules...
by Doug Correa | 08 07, 2015 | EPM, FDM, FDM Classic, FDMEE
This past June saw the annual gathering of Oracle EPM folk for KScope15. For those not in the know, KScope is the premiere conference for all things Oracle Hyperion put on by the esteemed ODTUG (Oracle Development Tools User Group) community. Thought leaders, product experts, and end users meet to share tips, implementation success stories, and to get details on upcoming product releases from the Oracle product management team. Enter FDMEE. If you couldn’t make it to KScope15, or you attended the conference but had too many commitments to make it to FDMEE sessions and the EPM Symposium (read: you were sitting poolside with a mojito in hand), here are the highlights of the near-term roadmap for FDMEE – 11.1.2.4.100. Note: It’s always important to bring attention to Oracle’s Safe Harbor statement, which simply says, Yeah, this stuff is on the way, but no guarantees as to when. PBCS Integration and the Universal Data Adapter If you’ve ever attended one of Oracle’s presentations over the past couple of years, you know that data integration goal for FDMEE is any source/any target. FDMEE delivers several pre-built source adapters for major ERP systems, like EBS Financials and PeopleSoft. Earlier this year, the 11.1.2.4 Release also introduced the EPM Data Synchronization component. With FDMEE EPM Data Sync we can map and move data between two EPM applications, such as HFM and Essbase. In the next 11.1.2.4 patch set update (PSU), we can expect Planning and Budgeting Cloud Service (PBCS) to the be part of the EPM Data Synchronization family for quick and easy EPM to EPM integrations. To achieve the objective of any source/any...
by Doug Correa | 07 10, 2015 | EPM, FDM, FDM Classic, FDMEE
Good news for you FDM Classic users out there looking to extend the life of legacy FDM just a little longer. Oracle has provided a solution for using FDM Classic with IE11. See My Oracle Support Knowledge Base article Doc ID 2028236.1 for details. Keep in mind, if you plan an upgrade to Oracle EPM Release 11.1.2.4, you will still need to migrate to FDMEE. There’s no sticking around with FDM Classic beyond Release 11.1.2.3. And with 11.1.2.4 being the second major release of FDMEE, there are a lot of reasons to make the leap to FDM Enterprise Edition. Want to know a few of those reasons? Click here....
by Doug Correa | 05 28, 2015 | EPM, FDM, FDMEE
Tip 2 – Viewing an Execution Log In FDMEE, you use data load rules to extract data from a source system (e.g. Oracle EBS or SAP) or to load data from a flat file. When you click any Workflow step (Import, Validate, Export, or Check) in Data Load Workbench, the data load rule associated with the point of view is executed. Now, suppose you want to see the status of an import? Or you want to view additional details associated with a failure. Where do you look? That’s easy. Just go to the Process Details component of FDMEE. With the Data Management tab open in Workspace, go to Workflow > Monitor > Process Details. The Process Details grid will appear with an entry for each submitted task. For any task in the grid, click the corresponding Show link to view the log. ...
by Doug Correa | 03 10, 2015 | EPM, FDM, FDM Classic, FDMEE
Oracle recently released FDMEE 11.1.2.4. Back when Oracle rolled out Enterprise Performance Management (EPM) System Release 11.1.2.3 in 2013, FDMEE was missing a number of core FDM Classic features (e.g. support for file-based data loads and scripting). Since the initial release, the Oracle development team published several patch set updates; each delivering more FDM Classic features to FDMEE. Now, with 11.1.2.4, FDMEE is FDM Classic and more. Like an aging superstar athlete in the twilight of a storied career, FDM Classic is looking ready to give way to its successor. Here are a few reasons why. Web-enabled Application – FDM Classic comes with a Windows client called Workbench. A Windows client is so 2005. Like most other Oracle EPM applications, FDMEE is a fully Web enabled application. Direct Connect to Any ERP System – Want to integrate data and metadata directly from an Enterprise Resource Planning (ERP) source system? With FDM Classic, you will need to use the ERPi add-on module. ERPi turns FDM Classic into a bit of a Frankenstein monster. With FDMEE, this functionality is baked into one product. Advanced Architecture – FDMEE’s underlying data transformation engine is Oracle Data Integrator (ODI). ODI is a world-class data integration tool on par with Informatica. FDM Classic doesn’t have ODI (unless you use it in conjunction with ERPi module). EPM Data Sync – Oracle Hyperion FDMEE Release 11.1.2.4 introduced data synchronization to the product. Using the data synchronization feature, you can now move data between EPM applications (e.g. from HFM to Planning). FDM Classic does not have this capability. Superior Performance on Exalytics – Want blazing data transformation performance using Exalytics,...
Recent Comments