Category Archives: forecasting

Customers and Partners Discuss the Benefits of Oracle Planning and Budgeting Cloud

By Guest Blogger: McKenzie Clune

Oracle Planning and Budgeting Cloud (PBCS) enables businesses of all sizes to rapidly adopt a world-class planning, budgeting and forecasting solution. This service features first in class planning and forecasting functionality, and enables accelerated adoption and flexible deployment options to meet your changing business needs. Oracle PBCS works to connect operational assumptions to financial outcomes and requires no capital infrastructure investment and minimal IT resources.  


At Collaborate 2015, Nigel Youell, Senior Product Marketing Director of Enterprise Performance Management at Oracle was joined by Emily Baird, Senior Accountant for Diono LLC to talk about Diono’s use of PBCS. Emily described Diono’s decision to adopt PBCS – namely, Diono’s budgeting, forecasting and reporting processes were very dependent on spreadsheets, and the tool that was directly linked to the ERP system was resulting in broken links and data integrity issues. As a rapidly growing mid-sized company with a global footprint, Diono found the cloud aspect of PBCS very attractive due to the low investment and scalability. PBCS had the potential to grow with the company.  

Diono’s implementation lasted roughly six months, and the company has already experienced significant improvements in reporting, annual budgeting and overall productivity. Specifically, Emily touches on how calculations, translations and consolidations of data from seven different countries, a once five week process, can now be performed in minutes – Thanks to Oracle’s PBCS!

To watch the video, click here

Nigel also spoke with Scott Costello, Director for Cloud Service and Emerging Technologies for Key Performance Ideas, about the benefits their customers have been realizing with PBCS. Key Performance Ideas currently has about 15 organizations using the software, and that number continues to grow. Scott talks about the agility that comes with PBCS, and how customers are leveraging the software for Line of Business (LOB) planning outside of Finance, including  sales planning, marketing planning, and even daily and weekly planning.  

One of the main benefits Scott describes is the positive economic impact associated with implementing PBCS, which makes it an attractive product. With PBCS, there are no upfront infrastructure costs or maintenance costs, and customers receive automatic updates. Lastly, the subscription aspect of PBCS allows for flexible and scalable deployment. Oracle’s PBCS has made many operations easier, and our partners and customers are realizing the associated benefits.

To watch the video, click here
To learn more about PBCS, click here


Disclaimer:
1)Oracle, Oracle Hyperion, Hyperion and Java are registered trademarks of Oracle and / or its Affiliates
2)Microsoft is a registered trademark of Microsoft and / or its affiliates
3)Any other trademark, name, logo, images, etc. are copyright and trademark of its respective owner which also includes Innov8 Infinite Technology Pvt.Ltd.

Customers and Partners Discuss the Benefits of Oracle Planning and Budgeting Cloud

By Guest Blogger: McKenzie Clune

Oracle Planning and Budgeting Cloud (PBCS) enables businesses of all sizes to rapidly adopt a world-class planning, budgeting and forecasting solution. This service features first in class planning and forecasting functionality, and enables accelerated adoption and flexible deployment options to meet your changing business needs. Oracle PBCS works to connect operational assumptions to financial outcomes and requires no capital infrastructure investment and minimal IT resources.  


At Collaborate 2015, Nigel Youell, Senior Product Marketing Director of Enterprise Performance Management at Oracle was joined by Emily Baird, Senior Accountant for Diono LLC to talk about Diono’s use of PBCS. Emily described Diono’s decision to adopt PBCS – namely, Diono’s budgeting, forecasting and reporting processes were very dependent on spreadsheets, and the tool that was directly linked to the ERP system was resulting in broken links and data integrity issues. As a rapidly growing mid-sized company with a global footprint, Diono found the cloud aspect of PBCS very attractive due to the low investment and scalability. PBCS had the potential to grow with the company.  

Diono’s implementation lasted roughly six months, and the company has already experienced significant improvements in reporting, annual budgeting and overall productivity. Specifically, Emily touches on how calculations, translations and consolidations of data from seven different countries, a once five week process, can now be performed in minutes – Thanks to Oracle’s PBCS!

To watch the video, click here

Nigel also spoke with Scott Costello, Director for Cloud Service and Emerging Technologies for Key Performance Ideas, about the benefits their customers have been realizing with PBCS. Key Performance Ideas currently has about 15 organizations using the software, and that number continues to grow. Scott talks about the agility that comes with PBCS, and how customers are leveraging the software for Line of Business (LOB) planning outside of Finance, including  sales planning, marketing planning, and even daily and weekly planning.  

One of the main benefits Scott describes is the positive economic impact associated with implementing PBCS, which makes it an attractive product. With PBCS, there are no upfront infrastructure costs or maintenance costs, and customers receive automatic updates. Lastly, the subscription aspect of PBCS allows for flexible and scalable deployment. Oracle’s PBCS has made many operations easier, and our partners and customers are realizing the associated benefits.

To watch the video, click here
To learn more about PBCS, click here


Disclaimer:
1)Oracle, Oracle Hyperion, Hyperion and Java are registered trademarks of Oracle and / or its Affiliates
2)Microsoft is a registered trademark of Microsoft and / or its affiliates
3)Any other trademark, name, logo, images, etc. are copyright and trademark of its respective owner which also includes Innov8 Infinite Technology Pvt.Ltd.

Oracle’s Top EPM Trends for 2015

Modern CFOs are successfully leveraging digital technologies in their Enterprise Performance Management (EPM) processes to transform their finance organizations and generate value for the business.  Which EPM priorities are at the top of the Finance agenda? What are the most compelling developments in big data, analytics, mobile technology, and cloud computing that motivate Finance leaders to undertake new technology initiatives?

Oracle surveyed hundreds of decision makers to learn more about their EPM plans for 2015—both within the Oracle customer base and the industry at large. We asked your colleagues to provide specific feedback on EPM technologies and practices—past, present, and future. From this extensive data set we compiled the following views and outlook—along with a bit of advice.  

For details on each trend, download the entire report here.

Trend 1 – EPM Embraces the Cloud; Speed is Key
EPM Cloud is planned to nearly double in 2015 vs. 2014. Compared to last year’s EPM Trends survey, speed and agility overtook cost considerations as a top cloud benefit. 

Trend 2: Mobile Goes Beyond Convenience to Strategic
Nearly half of respondents indicated that mobile technology adoption is providing growth opportunities and competitive advantage.

Trend 3: Big Data is Creating a New Signal for Finance
Over half of respondents expect to leverage big data in planning and forecasting processes in 2015 and 62% of CFOs around the world cited big data as hugely important to the future of business.

Trend 4: Modern Planning Practices are Becoming a Reality
More than 50% of respondents currently use, or are planning to use, driver-based budgeting and planning in the next 12 months. Rolling forecasts are in use or will be used in the next 12 months by 70% of respondents.

Trend 5: Detailed Costing Practices are Needed to Stay in the Game or Get Ahead
There was a 71% increase over last year in companies planning to cost individual customers, 133% more for costing invoices and 136% more for transactions. The desire to understand detailed costing practices has grown significantly. Meanwhile, many companies are still over-burdening their General Ledger with management reporting calculations.

Trend 6: Finance Departments need Literacy as well as Numeracy
Over half of respondents expect external stakeholders will require greater explanation of the numbers in financial reports, and 90% agree that expanding qualitative commentary in management reporting processes is critical.  It’s not just about the numbers – stakeholders want them put into context.

Trend 7: Organizations are not Realizing the Wider Benefits of Enterprise Data Governance
Over half of respondents already have Enterprise Data Governance (EDG) in place to help align reporting from multiple systems and in 2015, EDG is expected to reduce the use of spreadsheets and email by half again. Finance has felt the pain, seen the need, and has taken action, but the front office is yet to act.

The focus of Modern Finance is evolving from governance to guidance. Predictive, data-driven analysis, continuous planning and budgeting, and real-time decision making are what’s needed now. 


Modern EPM tools leverage cloud, mobile, and big data technology and are changing how Finance organizations are run and the best practices they use to measure contribution to the business.  Armed with fresh, accurate, enterprise insights from EPM tools, the Finance department can confidently drive digital transformation.

To download the entire report on Oracle EPM Top Trends for 2015, click here
To learn more about Oracle EPM, click here


Disclaimer:
1)Oracle, Oracle Hyperion, Hyperion and Java are registered trademarks of Oracle and / or its Affiliates
2)Microsoft is a registered trademark of Microsoft and / or its affiliates
3)Any other trademark, name, logo, images, etc. are copyright and trademark of its respective owner which also includes Innov8 Infinite Technology Pvt.Ltd.

Oracle’s Top EPM Trends for 2015

Modern CFOs are successfully leveraging digital technologies in their Enterprise Performance Management (EPM) processes to transform their finance organizations and generate value for the business.  Which EPM priorities are at the top of the Finance agenda? What are the most compelling developments in big data, analytics, mobile technology, and cloud computing that motivate Finance leaders to undertake new technology initiatives?

Oracle surveyed hundreds of decision makers to learn more about their EPM plans for 2015—both within the Oracle customer base and the industry at large. We asked your colleagues to provide specific feedback on EPM technologies and practices—past, present, and future. From this extensive data set we compiled the following views and outlook—along with a bit of advice.  

For details on each trend, download the entire report here.

Trend 1 – EPM Embraces the Cloud; Speed is Key
EPM Cloud is planned to nearly double in 2015 vs. 2014. Compared to last year’s EPM Trends survey, speed and agility overtook cost considerations as a top cloud benefit. 

Trend 2: Mobile Goes Beyond Convenience to Strategic
Nearly half of respondents indicated that mobile technology adoption is providing growth opportunities and competitive advantage.

Trend 3: Big Data is Creating a New Signal for Finance
Over half of respondents expect to leverage big data in planning and forecasting processes in 2015 and 62% of CFOs around the world cited big data as hugely important to the future of business.

Trend 4: Modern Planning Practices are Becoming a Reality
More than 50% of respondents currently use, or are planning to use, driver-based budgeting and planning in the next 12 months. Rolling forecasts are in use or will be used in the next 12 months by 70% of respondents.

Trend 5: Detailed Costing Practices are Needed to Stay in the Game or Get Ahead
There was a 71% increase over last year in companies planning to cost individual customers, 133% more for costing invoices and 136% more for transactions. The desire to understand detailed costing practices has grown significantly. Meanwhile, many companies are still over-burdening their General Ledger with management reporting calculations.

Trend 6: Finance Departments need Literacy as well as Numeracy
Over half of respondents expect external stakeholders will require greater explanation of the numbers in financial reports, and 90% agree that expanding qualitative commentary in management reporting processes is critical.  It’s not just about the numbers – stakeholders want them put into context.

Trend 7: Organizations are not Realizing the Wider Benefits of Enterprise Data Governance
Over half of respondents already have Enterprise Data Governance (EDG) in place to help align reporting from multiple systems and in 2015, EDG is expected to reduce the use of spreadsheets and email by half again. Finance has felt the pain, seen the need, and has taken action, but the front office is yet to act.

The focus of Modern Finance is evolving from governance to guidance. Predictive, data-driven analysis, continuous planning and budgeting, and real-time decision making are what’s needed now. 


Modern EPM tools leverage cloud, mobile, and big data technology and are changing how Finance organizations are run and the best practices they use to measure contribution to the business.  Armed with fresh, accurate, enterprise insights from EPM tools, the Finance department can confidently drive digital transformation.

To download the entire report on Oracle EPM Top Trends for 2015, click here
To learn more about Oracle EPM, click here


Disclaimer:
1)Oracle, Oracle Hyperion, Hyperion and Java are registered trademarks of Oracle and / or its Affiliates
2)Microsoft is a registered trademark of Microsoft and / or its affiliates
3)Any other trademark, name, logo, images, etc. are copyright and trademark of its respective owner which also includes Innov8 Infinite Technology Pvt.Ltd.

Why Are My Numbers Different From Yours?

Happy New Year!

Organizations spend way too much time arguing about whose numbers are right, where they came from, and what they mean, rather than spending time discussing what to do about them.  I had the pleasure of interviewing book author and consultant Ron Dimon, Enterprise Performance Management Advisory Services Partner at CheckPoint Consulting – an Oracle Platinum Partner – during a Podcast, and he provided some interesting insights into this topic.


Ron and I have been involved in Performance Management in one way or another since about 1999 and it amazes me that organizations today still rely so much on spreadsheets to do their planning and forecasting, profitability analysis, and even to record and report their financial and operational results.  But, I am hopeful, as many companies and institutions now embrace the tools and processes of Enterprise Performance Management (EPM), that this will change, turning performance management into a discipline and a competitive advantage.To listen to the entire Podcast, click here.

I asked Ron to give his point of view on why people are still uttering “Why are my numbers different from yours?” With all the technology and systems we have now, why is this still an issue for many organizations?  He told our audience that he believes much of the issue can be attributed to spreadsheets. “While great for some things, they were never meant to be collaborative, controlled, enterprise-wide consolidation and reporting engines or reporting systems.  We have grown to rely on them, because they are pervasive and so easy to set up.”  Ron explained that it is relatively easy to whip up a customer profitability spreadsheet, for example, in less than an hour. You just need to collect the sales and expense numbers, take a stab at indirect costs and voila!  The problem, he suggested, starts after the report is set up and we need to share it, compare actuals to forecast, or include some historical trend data.  Ron explained that, “When Finance gets a look at the spreadsheet, they have to reverse engineer it and will probably quickly find that my basis for allocating expenses is wrong, or I haven’t taken into account commission splits, or I’m not including a foreign subsidiary of the customer in the sales results…the list goes on and on.”

So how can this be corrected? Ron talked about a way of still using Excel to create easy, on-the-fly reports – but rather, using Excel directly connected to the central repository of data to ensure that everyone creating reports is starting from the same set of data. The Oracle solution he has used for this is called Oracle Hyperion SmartView for Office and is part of the Oracle EPM System.  Because the spreadsheet is essentially connected to the underlying central repository of the EPM system, there is less time spent arguing about why numbers are different.

So is Oracle Hyperion SmartView for Office the answer? Does it solve the data problem all by itself? Ron explained to our audience that SmartView is the window to all that data; it’s one way to access it. But how and when the data gets into the central repository, and how it’s organized and transformed once it gets there requires an Enterprise Performance Management System (EPM). Oracle’s EPM system is both a collection of tools and a group of processes that govern how your data, especially financial data, is recorded, reported and used. 

Ron explained that an EPM profitability application, like Oracle Hyperion Profitability and Cost Management (HPCM), is a much more disciplined way to truly determine customer profitability – unlike the spreadsheet example mentioned previously. Instead of the finance person making up formulas, allocations, and deciding what is included in that customer number or not, HPCM does it for you.  So now you CAN spend more time on what do to with that customer: pay more attention, adjust prices, offer new services (or even fire them!) – and much less time arguing about why my numbers are different than yours.

To listen to the entire Podcast, click here.
To learn more about Oracle’s Enterprise Performance Management solution click here, and to learn more about HPCM, click here.

Disclaimer:
1)Oracle, Oracle Hyperion, Hyperion and Java are registered trademarks of Oracle and / or its Affiliates
2)Microsoft is a registered trademark of Microsoft and / or its affiliates
3)Any other trademark, name, logo, images, etc. are copyright and trademark of its respective owner which also includes Innov8 Infinite Technology Pvt.Ltd.

EPMA Dimension Server service startup issue – MS SQL Server

We’ve often seen the EPMA Dimension Server service failing to startup. On multiple previous occasions, I’ve often seen my ex-colleagues ignoring the issue and the normal quick fix would be to re-load the image or avoid using EPMA. Two major reasons for this

  1. EPMA is not as much popular within the developer community due to its not so rich history and notoreity for being filled with bugs
  2. In most of the cases, re-loading an image with application backups is faster approach rather than spending time into de-bugging the issue

Recently, we stumbled upon a similar issue for one of our friend wherein his test environment was not able to start the EPMA service. Checking out the Hyperion logs was a futile exercise as there was nothing which could assist us in our debug investigation, we checked out the Event Viewer (normally not scouted for in most of the cases) if it can gave us some lead into the issue. To our surprise, we found that the issue was related to the MS SQL database environment wherein few privileges were missing. Apparently, it seems that database privileges for Set READ_COMMITTED_SNAPSHOT = ON & Set ALLOW_SNAPSHOT_ISOLATION = ON were missed out by him. Once the privileges were granted, restart of DB and restart of Hyperion services, the issue got resolved and there was no further issues noted.

The utility of Event Viewer is frequently undermined within Hyperion environment and the focus area is mostly upon the Hyperion Logs. As mentioned in the instant case, if the issue relates to the third party product, then there is more likelihood of the internal support team of loosing out of their precious time to scout within the Hyperion Logs due to ignorance of the utility of Event Viewer logs.

Please note that if you’re using MS SQL server, the following options are to be set in database to allow proper functioning:

  • Set READ_COMMITTED_SNAPSHOT = ON
  • Set ALLOW_SNAPSHOT_ISOLATION = ON

It is also heard within discussion groups that the settings used to be available by default in MS SQL server earlier but the same is no longer available and has to be set manually within each DB instance. Reader comments are welcome.

Disclaimer:
1)Oracle, Oracle Hyperion, Hyperion and Java are registered trademarks of Oracle and / or its Affiliates
2)Microsoft is a registered trademark of Microsoft and / or its affiliates
3)Any other trademark, name, logo, images, etc. are copyright and trademark of its respective owner which also includes Innov8 Infinite Technology Pvt.Ltd.

Optimizing the Business as a Whole: The Case for Enterprise-Wide Planning

I recently interviewed David Jones, Director in PWC’s Consulting Services EPM Practice, and Simon Kenney a Senior EPM Consultant also from PWC, in a podcast about their successes in enterprise planning implementation and their research on finance effectiveness.


Initially, we discussed the research they have been conducting around planning and forecasting effectiveness; they call it the Finance Effectiveness Benchmark. For 2012, some issues were consistent with previous years. Planning, budgeting and forecasting is taking too long to pull together, it’s still too manual and requires too many resources or effort to get it done. But the interesting headline this year is that 80% of the respondents declared that the accuracy of their forecasts is critical to the running of their business, but only 45% said that their forecasts were actually reliable. This result is very concerning as this deficiency will prevent companies from making the right critical business decisions.


So what are the causes of this large deficiency?


According to Simon, a lack of integration across the entire planning process – front office to back office is a key issue. The business functions are just not engaged enough as the forecasting is mostly finance led. Sales and marketing are essential to any forecast, but they are often not engaged properly. Ultimately, those that generate the opportunities and the revenue need to be involved with the forecast.


No wonder the forecasts are not accurate!


How do companies to fix this deficiency and move to an integrated more inclusive world of forecasting? Simon suggested the following three steps are a good start.


Step 1: Identify why the forecasting process is failing (Is each function independently running their own processes? Is there a lack of clearly defined accountabilities?)


Step 2: Determine if/when the company is ready to integrate their processes. (Does it have the required level of sponsorship in place to move to an integrated planning process? Are the functions prepared for change?)


Step 3: Define a blue print or target “n” state (Design the integrated process. Determine which technology can help support the new integrated process)


These steps sound fairly simple, so I asked David what some of the more difficult or challenging things are that he sees when undertaking these steps with his customers. David indicated that there are challenges specific to each industry, but some common ones to watch for are:



  • Lack of executive sponsorship across functions (Very Key!) The drive to implement change must come from the top and be a collaborative process.

  • Miss-aligned performance measures that drive the wrong behaviour.

  • Too much granularity or unnecessary detail in the financial plan. Requests for more detail and more clarifications lengthens the process (without sufficient benefit) taking too much time and effort.


Simon shared his experience working with a large UK based motor car manufacturer – the challenges and success they had experienced.


Car manufacturers are a more traditional type of company with lots of legacy systems. Being so entrenched in these systems meant that they were not sure if they were really ready for a big bang approach to integrated planning and forecasting. They, therefore, decided to work on one area of the company at a time – in waves – so they could prove it was the right thing to do by demonstrating success and showing value to drive further change.


I asked David how real the benefits were that could be obtained through integrated planning and forecasting. David said that he sees real results in more accurate forecasts and a much better understanding of what goes on in the business, how it behaves, and the impact each business function has on delivering the optimal level of profit. These are real and tangible benefits. Individual functional areas need to understand their role in the overall plan and not behave independently.


What can organizations do today to evaluate their planning and forecasting processes? Simon suggested the following:



  • Look at your existing processes – are they collaborative and integrated?

  • How accurate are your forecasts? If you are not sure, take a retrospective look and find out.

  • How effective are the different business functions in forecasting accurately?

  • Take a look at benchmarks and case studies outside your organization and see how you measure up and what else you can achieve.

  • If you are in the spreadsheet world, re-evaluate the process and take an honest look at how it is working for you. How accurate are your forecasts?


It became quite apparent from speaking to David and Simon that it’s all about optimizing the business as a whole and not the individual parts; without enterprise planning integration, this is simply not possible.


To listen to the webcast, click here.

Disclaimer:
1)Oracle, Oracle Hyperion, Hyperion and Java are registered trademarks of Oracle and / or its Affiliates
2)Microsoft is a registered trademark of Microsoft and / or its affiliates
3)Any other trademark, name, logo, images, etc. are copyright and trademark of its respective owner which also includes Innov8 Infinite Technology Pvt.Ltd.