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. 

  • Neal and Wang Presenting EPM Automate and REST APIs at Kscope

    Join us in our booth #204 to learn the latest on Oracle EPM and BI Cloud, plus attend Noah Neal's and Steven Wang's presentation:  Enhance Your Cloud Application with EPM Automate and REST APIs 

    Noah and Steven will be presenting on June 29th at 9:00am in the Grand Oaks 1 room.

    Interested in reducing the time spent in your data loading processes? The EPM Automate utility and REST APIs can help you do just that and much more within the context of Oracle Cloud! Learn how these tools work and can be used for automating processes to save time in day-to-day business activities. These processes include data and metadata import and export, business rule launches, application backup and restore, retrieval of data management process detail logs, and much more. Also learn how EPM Automate and REST APIs can be integrated with scripts to perform a number of different tasks outside of Planning. We’ll be discussing multiple sub-topics to help you get started and optimize automation processes, including:
    *EPM Automate vs REST API highlights
    *Scripting and syntax
    *Email notifications
    *Logging & Error Handling
    *Maintenance Minimization
    Find out more about how these powerful tools can allow your business to save time and enhance processes!

  • Your Monthly Oracle Planning and Budgeting Cloud (PBCS) Release Update

    Late Night with KPI

    Do you want to update your application and improve your processes? Watch our video blog and hear the latest releases from Oracle on Planning and Budgeting Cloud Service (PBCS) and Enterprise Planning and Budgeting Cloud Service (EPBCS). Late Night with KPI will showcase:

    • Predictive Planning in the Simplified Interface: Learn how to predict future values and enhance your forecast using existing forms; plus learn how to build scenario models for best case and worst case of your expenses/costs
    • Dimension Editor- Learn how to easily add, move and delete dimensions
    • Dashboarding- Make your data come to life! Learn how to improve the value you deliver to the CFO and executive management by inputting multiple charts in your dashboards

    Want to learn more about Dashboarding? Check out our blog video by one of our consultants:

  • Hanks Presenting Mastering MDX Analytics and Reporting at Kscope 17

    Join us in our booth #204 to learn the latest on Oracle EPM and BI Cloud, plus attend Jennifer Hank's presentation:  Mastering MDX for Analytics and Reporting 

    Jennifer Hanks will be presenting on June 28th at 8:30am in room Cibolo 8/9/10.

    MDX is often used in ASO cube member formulas, but did you know you can also use MDX to write reports and Smart View queries? Did you know that these reports and queries can be written against both BSO and ASO cubes? MDX can seem daunting, but with a basic understanding of syntax and functions, MDX is not that difficult. This session will give you what you need to get started writing MDX reports and queries that can supplement your reporting and add a new tool to your reporting tool set.

  • Webinar: Smart View- How to Look Smarter!

    Are you an executive or business leader that is not receiving the information you need to guide your business and help make decisions?
    Are you an analyst that needs to efficiently present your discoveries in the right format to support management and business partners?
    Do you want to stop the monotonous daily job of constantly updating reports?

    If you answered ‘yes’ to any of these questions, then this webinar is for you! Join us and learn how to move from spending too much time building reports or drowning in spreadsheets to actually analyzing business performance and make fact-based decisions. This session will showcase how to identify trends and outliers faster, all while removing the mundane of everyday management of data.

    Shane Schmitt, Director of Consulting Services & Delivery at Key Performance Ideas, will present the features and functions of Smart View that can help you be smarter, including how to:

    • Leverage Microsoft Office PowerPoint, Word and Excel for financial reporting
    • Improve performance visibility with Flash Reporting, Dashboards and Butterfly Reports
    • Better management of reporting processes with a simple & automated refresh
    • Take advantage of key attributes of Smart View including planning metadata maintenance, adding attribute dimensions, displaying alias member selections, and pivoting multiple members

    Shane will also present advanced techniques available in Smart View, including Cascading, Smart Slide, and Smart Query. Register today and learn how Smart View can help you look smarter by enhancing how you support business partners and improving decision-making.

    Date:June 20, 2017
    Time:2pmET, 1pmCT, 11amPT
    Location:Convenience of your office
      Register Today!

    Presented by:
    Shane Schmitt, Director of Consulting Services & Delivery
    Shane has been successfully implementing Hyperion solutions for domestic and international organizations since 1990. With considerable experience in finance and accounting, he has hands-on experience with month-end closes and budget/forecast cycles. He also has extensive experience optimizing Hyperion applications and understands how to leverage his practical work experience, the proper use of technology and best practices to maximize existing investments.

  • Managing Alternating Fiscal Calendars in Oracle Planning and Budgeting Cloud Service (PBCS)

    Alternating Fiscal Calendar Structures - what on Earth are you on about?!? Let me explain, using a real-world example that may be more common than you realize.

    Most restaurants utilize a 4 week month, which becomes known as a period, and there are 13 periods in a year. There are a few reasons why the restaurant industry has adopted this calendar which include comparability across periods/years, inventory management, and payroll accounting. 4 weeks in a period * 13 periods in a year = 52 weeks. Nice and round, right? Unfortunately a year is not exactly 52 weeks. To account for this discrepancy, every few years a 53rd week is included in the fiscal calendar. When this occurs, the 13th period includes 5 weeks instead of 4.

    So, the question becomes how to handle shifting calendar logic in a Hyperion Planning application? Particularly when all business rules are set to run based on logic that all periods have 4 weeks in period, dealing with a single period that has an extra week in it every few years becomes an infrequent but major issue.

    Consider the following requirements:

    • 53rd week will not be subject to standard calculations when it occurs, all values will be manually entered. 53rd week data must roll up automatically into the 13th period.
    • 53rd week must be visible during data entry
    • 53rd week must not be visible for reporting
    • Application only has period granularity down to the period, not the week

    To handle the above requirements and minimize application administration, alternate hierarchies and substitution variables are employed for forms, reports, and where necessary, calculations.

    Substitution variables are used to reference the period dimension on all forms and reports. If a form is used for data entry, the “Period_Entry” Subvar is referenced. If a form or report is used for reporting purposes, the “Period_Report” subvar is referenced.

    These subvars point to one of 3 hierarchies in the period dimension. The first is a standard hierarchy with 13 periods, which is referenced by both data entry and reporting subvars in standard 52-week years.

    The second hierarchy is used by the Period_Entry subvar during 53 week years. It shares period 1-13 with the hierarchy above, but it also includes a “14th” period. This 14th period is the 53rd week which exists for data entry purposes only.

    The final hierarchy is referenced by the “Period_Report” subvar during 53rd week years for reporting. It contains shared members for periods 1-12, and a “ P13’ “ member. The “ P13’ “ member is a dynamically calculated member formula which adds up the base P13 and P14 members: P13’ = P13+P14;

    Now we’ve discussed both the substitution variables and the hierarchies they reference – here is a cheat sheet which details how they interact given the two different fiscal year structures:

    Next we will be looking at two forms, one that is used for data entry (named Data Entry) and another that is used for reporting (named Data Report). These are simplistic examples but the concept displayed here can be applied to any sort of form or Financial Report.

    The Period dimension is referenced as follows in the “Data Entry” form:

    The Period dimension is referenced as follows in the “Data Report” form:

    When the subvars are set for a standard 52 week year, the forms are displayed as follows:

    Above, the Entry and Data report forms both show 13 periods, in this case the values for each period are consistent across the entire year as very simple calculations were used to build up periods based on 4 weeks.

    Now, when the substitution variables are flipped to their 53rd week settings, the forms look different:

    In the data entry form, the 14th period is visible. One week’s worth of data was entered in this field.

    In the Data Report form, you cannot see the 14th period, but you can see the special P13’ member. It sums up P13 and P14 as shown on the data entry form.

    This method is one way to manage fiscal calendars that have different structures. In this case we are solving for a 53rd week which occurs every few years in the restaurant industry’s fiscal calendars. By changing just 2 substitution variables, every report, form and calculation can adapt to address wether a standard calendar year, or a non-standard calendar year is currently in play.

    Blog post by James Renger of Key Performance Ideas.

RSS Feed




Kscope 17