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. 

  • Batch Bursting of Reports by "Property" in Oracle EPBCS and PBCS

    Ever have the need to produce a subset of Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS) or Planning and Budgeting Cloud Service (PBCS) reports based on multiple characteristics in a timely fashion? Perhaps you need to provide multiple departments with snapshot of PDF P&L reports, and within your Department hierarchy, you are looking to quickly produce reports only for members identified as “Open,” as opposed to those that are “Closed”. Alternatively, maybe you are looking to distribute reports to a select group of Entities that are responsible for making “Product A” as opposed to “Product B”.

    Fortunately, Oracle EPBCS and PBCS Financial Reporting capabilities can meet those requirements! In this blog, we’ll discuss Batch Bursting of financial reports as a methodology for producing multiple report snapshots quickly and efficiently. In particular, we will address the nuance of producing reports for a sub-section of intersections, as constrained by a set of parameters. We will discuss each topic through an example.

    What is Batch Bursting?

    “Batch Bursting” is a functionality that allows you to run (“burst”) a predefined “batch” of reports (and/or related items) across a set of parameters (for example – a set of members, e.g., reports for all lowest-level departments in the Department dimension). Multiple Financial Reports (as well as FR “Books” and other items) can be added within a designated “batch”, and that “batch” can then be bursted via a schedule or in an ad-hoc fashion. The snapshots commonly have an output format of PDF – and that output can be produced within Oracle Cloud and then downloaded (for example, from the Inbox/Outbox Explorer), and/or, emailed to designated recipients. Batch Bursting is beneficial in multiple business contexts because it:

    • Allows for time saving – no need to run report member-by-member
    • Allows for distribution (e.g., emailing the output to recipient(s))
    • Allows for convenient means of snapshot archival (e.g., through Inbox/Outbox Explorer)

    Walk-through: Batch Bursting Execution

    Let’s discuss Batch Bursting within the context of Oracle EPBCS and PBCS in more detail by going through an example.


    Assume we are responsible for producing EPBCS or PBCS Income Statement report snapshots for departments in the “Department” dimension that are “open”. Also, assume that we are a new user and not as familiar with the Department hierarchy and another admin has tagged these specific (highlighted) departments with the UDA “Open”:

    Clearly, the UDA is associated with members across multiple levels within this hierarchy. Is it possible to produce report snapshots dynamically in this context for these departments without having to drill in to identify those tagged with the UDA? Yes, it is! Let’s continue.

    Begin by accessing EPBCS or PBCS. In our example, our application is called “PLNtstc1”:

    Access the reports repository:

    We will create a batch containing our report template. Go to “File” -> “New” -> “Document”:

    “Batch Reports for Scheduling”:

    Select the report template for which we want to run these Income Statement reports – this is “Income Statement_Example”:

    Click “Finish” on the lower right. We are then brought to this screen:

    Where we can save our batch:

    Now that we have our batch, we can “burst” it for our departments of interest.

    Go to “Edit” -> “Schedule Batch”

    Input the Batch Job Name and detail and click “Next”:

    Select the batch of interest and click “Next”:

    Input credentials used to login to EPBCS or PBCS:

    Let’s assume we don’t want to schedule this burst, but that we want to run it now. Leave top settings as-is within the “Start Time” section.

    Nuance: Bursting Across Specific Property/Properties

    This screen might be the most critical in the batch burst process in our particular case. We know we want to run the batch for “multiple members in the dimension “Department” so we would select it as such:

    Then, use the magnifying glass on the right to select more constraints:

    We know we only want to run this process for the multiple Departments tagged with UDA “Open”, and, as such, we need to designate those parameters in this screen. At first glance, a way to begin to do that might be to choose the descendants of “All_Departments”.

    However, this would get us all the Departments under “All_Departments” as opposed to only those Department members tagged with UDA “Open”.

    So instead, to capture those specific departments, go to “Functions”:

    And identify the function that is “Property”. Move to the right-hand side of the selection box:

    Upon doing so, you will see the options to select “Property” parameters. In our case, we can select such that the logic aligns with ‘departments with UDA-equal-to-“Open”’:

    After clicking “OK”, our selection screen looks like:

    And after clicking “OK” again, we have:

    Side Note: We can add multiple functions to further constrain the set for which we run the reports. For example, if we were to add a “Property” function again and this time add attribute “Northern” within “Territory” attribute hierarchy:

    We could run the process only for departments that are “Open” (UDA) and in “Northern” territory (attribute).

    After clicking “Next” again, we can choose output destinations, label conventions, and detail-related options on the following screens. For example:

    Once we click “Finish” at the bottom, the process will run:

    And our output should yield what we expect – the snapshot reports for the designated departments:


    Batch Bursting is a very useful method for producing report snapshots in EPBCS and PBCS for specific members in a hierarchy. That said, the “Property” function within that method is especially useful as it allows you to quickly confine your set of members by leveraging properties such as UDA and/or attribute associations! We hope you can use Batch Bursting and the “Property” function to save time and improve efficiency in your next reporting cycle.


    Blog Post by Noah Neal of Key Performance Ideas.

  • Start 2018 with a deep dive into Enterprise Planning and Budgeting Cloud Service (EPBCS) and Oracle Analytics Cloud Service (OAC)

    Start 2018 off educated!  Join us for our Oracle EPM Cloud events featuring Enterprise Planning and Budgeting Cloud Service (EPBCS) and Oracle Analytics Cloud Service (OAC).  We will take a deep dive into EPBCS' Workforce and Capital Asset Planning modules in January and March.  In February 2018, we will demonstrate OAC and review how the components included in OAC are used, integrate, and improve the overall reporting picture of your business.

    Workforce Planning in EPBCS
    January 30, 2018

    Join us for our webinar as we take a look at the Workforce Planning module of Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS) which will showcase what can be enabled out-of-the-box including features such as detailed data granularity, expense and headcount planning, and workforce management. 

    Oracle Analytics Cloud Service (OAC) Demonstration
    February 27, 2018

    Join us for our webinar as we review Oracle Analytics Cloud Service Enterprise Edition (OAC), a single platform that empowers your organization to ask any question of any data in any environment on any device.

    Capital Asset Planning in EPBCS
    March 20, 2018

    Join us for our webinar as we take a look at the Capital Asset Planning module of Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS) and how it provides overall capital expense spend analysis and review, including asset summary reports, actual versus plan variances, as well as the impact on the balance sheet, income statement, and cash flow by asset class and business unit. 

    For more information and to register, visit Key Performance Ideas Events.

  • Webinar Part 1: Data Integration Options for EPBCS, PBCS and FCSS

    Would you like to have more options with data integration and automation within Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS), Planning and Budgeting Cloud Service (PBCS) and Financial Consolidation and Close Cloud Service (FCCS)? Watch Deanna Sunde, Oracle ACE, as she explores data integration options for EPBCS, PBCS and FCCS.

    Part 1 of the 2 part series covers importing and exporting metadata and related use cases (including migrating from on premise), importing and exporting data with jobs (both in Essbase and Planning formats) including exporting text accounts and Smart List values. The discussion also includes exporting data with the DATAEXPORT command in business rule.

    Due to technical issues, we apologize for the audio issues at the beginning of this webinar. 

    Attendees of this series will understand how the EPM Cloud tools replace the functionality of on premise dimension build and data load rules, .bat and maxl scripting. Use cases and pros and cons for the methods will be discussed as well as the file format requirements, options, and code examples. Example EPM Automate scripts will also be presented.

  • Data Integration Options for Oracle EPBCS, PBCS, and FCCS- Part 2, A Webinar

    Would you like to have more options with data integration and automation within Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS), Planning and Budgeting Cloud Service (PBCS) and Financial Consolidation and Close Cloud Service (FCCS)?  Join Deanna Sunde, Oracle ACE, as she explores data integration options for EPBCS, PBCS and FCCS.  

    Explore the metadata and data integration and automation options available for EPBCS/PBCS/FCCS. The second part of this two part series will cover loading data with Data Management, moving data between databases using Smart Push, Data Synchronization and xref/xwrite, including related use cases. Also discussed will be migrations between Test and Prod, backups and disaster recovery.

    Attendees of this series will understand how the EPM Cloud tools replace the functionality of on premise dimension build and data load rules, .bat and maxl scripting. Use cases and pros and cons for the methods will be discussed as well as the file format requirements, options and code examples. Example EPM Automate scripts will also be presented.

    Date: December 14, 2017
    Time: 2pmET/1pmCT/11amPT
    Location: Convenience of your office!

    Register Today!

  • Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS) Workforce Planning Module

    Does your company struggle with unreadable spreadsheets that track employee headcount and related workforce expenses? Did you know that Oracle offers an Enterprise version of the Planning and Budgeting Cloud Service (EPBCS) that uses several dynamic dashboards and reports to help your company meet strategic initiatives and that is easily readable by your HR and FP&A teams?

    Oracle’s EPBCS Workforce Planning Module is built to fit your enterprises’ needs, as-is and out-of-the-box. Workforce allows your company to track personnel related expenses at the employee level, job level, entity level and some custom levels. You will see reports and dashboards analyzing expenses related to base salary, bonuses, merit raises, taxes, allowances and any number of compensation types that your company offers. This includes out-of-the-box variance analysis and forecasting for your FP&A team. Workforce also allows your HR team to see expense analytics dashboards based on employee demographics. Additionally, Workforce can help your company pursue strategic initiatives by managing employees by skill and allocating them to where they are needed. This is done through a dynamic hiring requisitions, new hires, transfers and terminations system. All of these features allow your company to see if it is functioning efficiently or exactly where changes need to be made. These features and more come with Workforce Planning on EPBCS with little necessary maintenance.

    What can be enabled out-of-the-box:

    • There are three cubes available out-of-the-box:
      • An input cube and stores generic earnings, benefits, and taxes
      • A detailed sub-cube for calculations and drivers
      • A detailed reporting cube and includes employee demographics
    • 6 Folders of forms that each contain analytics on expenses, variances and demographics
    • 7 Dashboards related to Workforce analysis
    • Several Smart Lists to simplify choosing properties
    • Business rules for each new cube
    • 8 new dimensions and shells of hierarchies that can be customized to your company’s structure

    Out-of-the-Box Features

    Below is the setup wizard that will facilitate your application administrator in enabling features that are essential in your company’s workforce analysis.

    Granularity – How will expenses be managed? At the Employee level, Job level or a hybrid of both. For example, some companies manage base salary expenses by each specific employee and corporate bonuses on the job level (Analyst, Manager, VP, etc.). This would be a reason to use both employee and job. Another, simpler option is to use job level average for each compensation related expense.

    Expense Planning – Employee or Job level expenses may be greater than just the employee’s base salary. This is where you can enable Additional Earnings, Benefits, Taxes and Merit Based Planning. Enabling these will allow you to add expenses at a more specific level including but not limited to:

    • Federal & State Taxes
    • Benefits such as Healthcare, 401k Matching & Auto Allowance
    • Any Additional Earnings that are common expenses to the company

    Those will later be configured to percentages of salary, flat amounts and max amount limits.

    Headcount Planning – Employee Demographics is concerned with analyzing expenses related to Age, Gender, Etc. Strategic Workforce Planning tracks the skills of individual employees or jobs. This functionality also would show you when talent needs to be allocated to certain areas or departments in order to maintain your corporate strategy.

    Workforce Management – Create new hire requisitions based on your company’s needs. Once hired, the requisition can be easily moved into the record of existing employees, which is the data analyzed on the dashboards and forms. Terminations and transfers are also offered out of the box and use a similar process.

    Additionally, 3 custom dimensions can be enabled for additional personnel analysis.

    Structure of Compensation Expenses and Levels:

    • Component –
      • Salary Grades
      • Tax Tiers
      • Types of Benefit
      • Additional Earnings that are offered by your company
    • Entity – Salary and non-salary expenses may vary from entity to entity. Include properties and data you want calculated at the entity level
    • Employee – Properties for each individual employee and data you want calculated at the employee level
    • Job – Properties for each position held in the company and data you want calculated at the job level
    • Union Code – Include Union related expenses that can be tagged at the employee, job or entity level

    Workforce Assumptions

    Plan expenses for hourly employees based on specified assumptions that will be used globally in the Workforce Module. Enter Hours per Day, Hours per Week, Workdays per Month and Partial Payment Factor.

    Salary Grades 

    How many levels of base salary are required? Each level (or grade) will require a Salary Basis (i.e. hourly, annually, semi-annually) and a Rate which is a dollar amount. These grades can be configured on different levels (employee, job, etc.).

    Salary Basis is a good example of an out-of-the-box Smart List being used.

    Benefits and Taxes

    There are so many variations of benefit packages that companies offer. Workforce can configure to the way YOUR company does benefits. The same goes for Federal taxes and taxes for each state in which your company has a presence.

    Identify how your company calculates benefits:

    • Simple Table - one rate and one threshold per year

    • Rate Table - multiple rate options with no threshold

    • Rate Table and Threshold option -multiple rate options with different thresholds

    • The financial account they will be affecting
    • Payment terms & frequency
    • Value type - flat amount or % of salary
    • The max value type – flat or %
    • If the component is taxable
    • If this amount should be added to gross pay

    Planning and Forecast Preparation

    How far in the future would you like to project labor expenses? How often? The EPBCS module allows for forecasting and budgeting for future workforce expenses at different levels of granularity. Assumptions can be made on a monthly, quarterly and yearly level. You are able to choose the number of periods in the future you would like to project.

    Employee Properties

    You can also track expenses based on properties related to employees. Properties come out-of-the-box if enabled. You also have the option to create custom properties to track. These property titles can be attached to Smart Lists and are configured to individual employees.

    Non-Compensation Expenses

    Another optional feature is Non-Compensation analytics which displays dashboards and forms that are found under the Non-Compensation card. Examples include the costs of hiring a new employee which would include costs to recruit, to train once hired, etc.

    Performance Metrics

    This can be used in a couple ways. If enabled, Performance Metrics can be used to analyze the performance of employees in a POV. It is also used to rate employees for compensation purposes. See Merit Rates for more details.

    Merit Rates

    Organizations can set rates of salary increase based on the Performance Metric rating. The metrics are used globally across the application as standard increase based on merit.

    Is Workforce Planning Right for Your Enterprise?

    Whether your company employs hourly workers, salaried workers or temps, has low or high employee turnover, pays only yearly bonus or has a comprehensive benefits package, and all of the above, the Workforce Planning module on Oracle’s Enterprise Planning and Budgeting Cloud Service will assist your company in managing employees and the related workforce’s expenses. Simple dashboards and reporting will help your FP&A team see exactly where a variance occurred. HR will be able to manage the variances by allocating employees using the Headcount Planning tool. No matter how complicated your workforce management is, the Workforce Planning Module will make it simple and get you to out of spreadsheet hell.

    Blog post by Henry Rosenberg of Key Performance Ideas.

RSS Feed