Key Performance Ideas is a full-service systems integrator and implementation consultancy with a focus on Oracle Hyperion applications and related technologies. Our blog is designed to help companies of all sizes derive the most value from their Oracle Hyperion Enterprise Performance Management and Business Intelligence (BI) software solutions. Search the blog and find tips and tricks and lessons learned from our experts. 

  • "Move and Improve"- Migrating from On Premise to Oracle EPBCS and Implementing Workforce Planning

    This company develops system-level solutions that optimize its customers’ applications. It’s market-leading products in radio frequency, high performance timing, memory interface, real-time interconnect, optical interconnect, wireless power, and smart sensors are among the company’s broad array of complete mixed-signal solutions for the communications, computing, consumer, automotive and industrial segments. The company has design, manufacturing, sales facilities and distribution partners throughout the world. They were founded in 1980 and employ approximately 1,700 employees worldwide.


    The Finance team has historically used on premise Oracle® Hyperion Planning™ for detailed revenue and P&L planning. Generating planning expenses related to personnel had been a highly manual and fragmented process typically done in Excel by a just a handful of corporate users. With business operations in over 50 legal entities around the world, getting a consistent, clear view of salary and headcount forecasts in a timely manner had been challenging. Furthermore, internal controls related to salary and bonus data limited access to only a handful of planners. The majority of planners responsible for workforce expenses did not have access to the salary and bonus information for their employees.

    The company required a workforce solution that would allow quarterly forecasting by named employee and related expenses, calculated at the GL account level and integrated into their existing planning application. Most of their users would not be given access to detailed salary and related accounts by named employees, but would still be responsible for the results in aggregate at the cost center level. The application would need to be refreshed with data for 1,700 employees on a quarterly basis using a source file requiring only very limited ETL and calculate data at the level of granularity required for management reporting.

    The company selected a Cloud based solution, Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS), for their new financial statement reporting and revenue and workforce planning system and chose Key Performance Ideas, the nation’s leading implementer of EPM Cloud solutions, as their implementation partner.

    Partnering with Key Performance Ideas, the company chose to move their on premise Revenue and Reporting Planning application to the Oracle EPBCS and enable the EPBCS Workforce Planning module. EPBCS is a planning, budgeting and forecasting solution which includes best practice, prebuilt frameworks for Financials, Workforce, Capital, and Project Planning. Based on Hyperion Planning, the EPBCS solution provides the needed sophisticated modelling and analytic capabilities the company’s users require (and are accustomed to) with the added capabilities of pre-built frameworks for rapid implementation of additional detailed models.

    Key Performance Ideas migrated the existing Planning application using “move and improve” techniques for moving from on premise to the cloud and improving their forecasting processes by implementing the Workforce Planning module within EPBCS. The company wanted to leverage the best practice prebuilt elements provided by Oracle in the Workforce Planning module, but also had several custom enhancements which Key Performance Ideas tailored to their requirements.

    Necessary customizations included replacing the process to load data to use source system-derived files instead of the pre-defined templates. Calculation logic was modified for employee bonus payments, as well as new employee expenses. These modifications were integrated into EPBCS calculations, processes, and user interface. Additionally, the resulting data was copied into the existing reporting application with a greater level of detail than natively supplied by the Workforce Planning module. Finally, the user interface was updated to shield detailed salary and bonus information from most Workforce users.
    The company also engaged Key Performance Ideas’ System Maintenance And Remote Troubleshooting (S.M.A.R.T.) team to provide managed services and administration of their EPBCS environment. The S.M.A.R.T. team of Oracle certified, US-based administrators reduces the company’s operational risk and minimizes interruptions to core organization planning and reporting exercises.

    Benefits Achieved
    The Finance team is responsible for preparing plans and forecasts for financial statements drawn from detailed models for revenue and workforce expenses. With the implementation of EPBCS, they are able accomplish all related activities in a single application. The new Workforce Planning module implementation achieves the following benefits:

    • Best practice, named headcount workforce engine provides the majority of detailed headcount calculations
    • Annual and monthly drivers are readily accessible and tailored to the company’s requirements
    • Snapshots from the HR source system are readily loadable into the application with minimal alterations
    • Detailed account reporting requirements are fulfilled outside of the underlying Workforce engine, allowing future updates from Oracle to be patched into the application with minimal disruption.
  • Oracle Analytics Cloud Integrated with EPBCS and PBCS- Watch the Webinar

    Would you like to perform real-time deep analysis and reporting of your Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS) or Planning and Budgeting Cloud Service (PBCS) application without the need to export the data to your Data Warehouse or other analytical tool? Would your Finance team like to extend their reporting capabilities beyond budgets and forecasts and integrate other data sources? 

    Watch our webinar as we review how to leverage Oracle Analytics Cloud (OAC) to enable dynamic drilldowns from EPBCS and PBCS summary views into General Ledger and sub-ledger transactions and explore other advanced reporting and data visualization capabilities. 

    Our speaker, David Decker, presents a demonstration of OAC integrated with EPBCS/PBCS and showcase how organizations can improve their overall reporting of business performance. David also presents how your organization can build a case study to invest in OAC, as well as:

    • Best approaches to integration with your EPBCS and PBCS application
    • How to identify the data sources for needed reporting
    • Advanced analytics and reporting capabilities, including techniques to show data in the appropriate visualization for each decision maker in your organization

  • Multidimensional Mapping- A Use Case Example

    Multidimensional Mapping is a tool that allows administrators to map data to an intersection by referencing dimensions other than the one being mapped. This can be helpful when administrators face more stringent data load requirements. This could be due to a GL string identifier in the source system, or the need to abide by certain requirements for system calcs to run properly. In this example, I will be focusing on the GL string scenario, but the concept can be applied in a variety of use cases.

    Let’s begin by taking a look at an example involving a GL string that is composed of an entity member, followed by an account member in the following form XXXX.XXXXX. Once again, in your case the GL string may use different dimensions, or you might be taking a variation of this issue, but the same rules apply.

    Before we go any further, it is important to highlight that this is meant to be used as needed, but best practice would be to clean up the hierarchy on the front end. A cluttered hierarchy is something that will add another layer of unnecessary complexity, and thereby decrease overall performance. This solution only allows the administrator to circumnavigate the issue and map the data to the appropriate dimensions. It is still highly recommended you clean up your hierarchies, and minimize the number of multidimensional mappings you will need to set up.

    Also, remember that the accounts you are mapping will need to have already been created in the outline. These are likely not accounts that were brought over in the initial metadata import. It is more than likely that you will need to create these members, and you will also need to determine the nomenclature that will be used, as these will not look like the source system’s GL String.

    The first step will be to manipulate our GL string into the various dimensions of which is it composed. In our example, this is the entity and account dimensions. To do so, we will leverage the Text to Columns function found in the Data tab in Excel. First, let’s highlight the column we want to separate into the various dimensions, and select Text to Columns.

    A small pop up screen should appear. You can either set it to a fixed width or delimited. If the GL string is always the same length, fixed width can be an effective method of identifying where our entity dimension ends, and where the account dimension begins. In most cases, GL strings will use some method of delimitation, so we will showcase this in our example.

    After delimited has been selected, the following screen allows us to determine what character is being used as the separator. In our case, we are using a period. We can select multiple characters (even tabs and spaces) as separators, and can treat consecutive delimiters as one singular delimitation. For our purposes, we can check the other box, and enter the period value.

    Finally, the last screen allows us to determine the data format of the new columns we are creating. It is recommended that you select text to avoid the loss of trailing zeros, or any other changes to our values as we manipulate them. Once you have completed this and your GL string has been divided across your various columns, you can copy and paste them separately in their respective columns in the flat file you are trying to load.

    Next, we will go to Data Management, and select Data Load Mappings:

    From here we select the tab marked Multi Dimension:

    Next, we select Add, or the green plus sign to add a new mapping. We should be taken to a screen that looks like this:

    From here we can input a rule name. For now I will just use the name of the member we are mapping it to in order to guarantee uniqueness. In such a case my rule name and target value would be one and the same. For this example, the GL String 3030.24125 will be mapped to A_24125_REV. In other words, when the account 24125 intersects with the department 3030, the value should be mapped to a member by the name of A_24125_REV. We could then go back and map other departments to other accounts.

    In any case, once A_24125_REV has been input into the rule name and target value, select the green plus sign to add a dimension. Once it has populated select the account dimension from the drop-down menu.

    Next, we input the value of the source account, or in this case 24125 (remember that the GL String has been broken into two columns to allow for this).

    Next, we select the green plus sign and select the other dimension in the GL String. In our case, it would be entity, and for value we would simply input the source value for departments. For this example, the value field would be 3030.

    Once you are done, select okay to add the mapping. You can go back and edit the mapping using the pencil sign just like any other mapping, and you can repeat the process for all the accounts that suffer from this issue. Otherwise, the rest of the process is the same. You would load the data the same way, and run the same business rules you would have otherwise run.

    Multidimensional Mappings is an effective tool in mitigating the added complexity incurred by GL strings, as well as the more stringent data load requirements that usually accompany them. By using this technique, administrators can map data from their source systems to their environment with relative ease and simplicity. This is despite the, often drastic, differences between the source and target hierarchies. Thanks to the flexibility provided by this technique, administrators can utilize this regardless of which two dimensions are being referenced in their own GL strings, or in any situation where the administrator needs to map data across two or more dimensions.

    Blog post by Ali Khaled of Key Performance Ideas.

  • Learn how Panduit Migrated 260+ Users to Oracle PBCS and EPRCS

    Watch our webinar as we showcase how Panduit and over 260 users migrated an on premise operational planning, financial reporting and allocations solution to the cloud in just weeks. Hear how, through our migration methodology, the power and speed of the cloud reduced calculation times from 1-2 minutes to a few seconds. We will also review how they are using Enterprise Performance Reporting Cloud for financial and management reporting.

    Learn how:

    • A systematic approach supported moving 260 users to the cloud seamlessly and secured user acceptance
    • To create an automated integration process of the Oracle GL
    • The cloud applications supported current processes and streamlined reporting and analysis
    • PowerPoint is being used to collaborate and comment on management reporting

RSS Feed




PCMCS Webinar