PERCENTIX BLOG

Hyperion Smart Slices

Typically television comedy doesn't go over my head; Frazier often challenged my mind as does Curb Your Enthusiasm.  Last evening I found myself perplexed when Sheldon dropped "30 pieces of silver" in front of Leonard on the show Big Bang Theory.  So with that I turned on my laptop to understand the reference, and of course that led me to playing with the latest version of Hyperion Planning 11.1.1.3.01. (Yes, the versions are starting to look like IP addresses.)  Last night's newest feature: Smart Slices.

There are two forms of Smart Slices: 

1. The first is rather simple, when a Planning form is "Enabled for Smart Slices" by an administrator (Manage Data Forms/ Other Options). The form, while in Excel SmartView, has the capability to move from a standard form into an Ad-Hoc mode, which is a big improvement for clients that are used to recreating a data form via Ad-Hoc analysis just to query the data they are already looking at. Honestly, I have seen clients create complex VBA scripts to do what now can be done in two clicks.
2. The second part of data slicing is controlling a portion of Essbase for Ad-Hoc analysis. Basically you are creating an excel workbook of your data stored in Essbase; however, only the data inside that book is available to query. As an example, you can slice off a piece of data specific for your sales team and save this as a Smart Slice called "Sales". So when the sales team wants to view data, they can start at a specific intersection of data (rather than dig through the data base eating up valuable performance time) and not be able to review data outside of "Sales Smart Slice", like "Cost of Sales".

Additionally, by the use of sub-queries, you can expand the Sales Smart Slice to create an "Encyclopedia of Sales" where each volume can be set to a specific POV (such as final sales for Ohio and Mid Market). This way your sales team won't have to drill through further layers of dimensionality to get their desired data.  But rather, they can select the "Ohio Mid Market Sales Smart Slice" in the "Sales Smart Slice".  Whether a Smart Slice, or a sub query, access to a Smart Slice is controlled by the administrator who can modify user access as needed - a task not possible in Excel, without each person sharing the password.

Smart Slices solve issues for the security-minded as well.  A Smart Slice can be created for the HR Department excluding sensitive employee data for only those that require access; employee salary is a perfect example.  You may want only department VP's to view employee salaries for those employees that report to them.  Such cross-dimensional security can be challenging when managing employees that are constantly crossing departments and for VP's shifting responsibilities.  However, with a Smart Slice you can create an "Encyclopedia for HR" and a separate volume for salaries, with further volumes for each department.

Smart Slices take us down a path of efficiency and usability not seen in a centralized data source. It's almost like creating a separate database for each need, a major improvement and a great addition to the tool chest.

Oh, and "30 pieces of silver" refers to Judas..... I wonder how that show ended.

The Oracle | Sun Acquisition and What it Means for Enterprise Performance Management

What's old is new.  Bell bottom jeans, aviator sunglasses, big band jazz, vertical integration...err...yes, vertical integration.  By most historical accounts, Andrew Carnegie introduced the concept of vertical integration some time ago, and in the recent past we have seen business process outsourcing essentially debunk the merits of this once cherished business practice.  If you need a primer on vertical integration use this Wiki link: http://en.wikipedia.org/wiki/Vertical_integration.  Cheap labor abroad drove much of the drive around outsourcing, reinforced by a increasingly educated set of foreign workers who are inexpensive when compared to their US counterparts.  However, the economic turmoil experienced from 2007 to the present has stressed companies in multiple ways, so much so that organizations are revisiting the concept of vertical integration (VI) in an effort to improve the quality of their products, protect the supply chain from systemic risks, hedge currency fluctuations, and most importantly, use VI as a means to enhance the customer experience.  Which leads me to the point of this blog: Oracle's acquisition of Sun Microsystems.  

By all accounts, Oracle|Hyperion is a tiny fraction of the overall Oracle technology stack, albeit a very critical one.  Oracle's acquisition of Hyperion was indeed a trendsetter, noted by the quick reaction of SAP and IBM.  But setting trends for the sake of setting trends is foolish: Oracle realizes the importance of the Chief Financial Officer and wants access to that office.  So, when viewing the impact of the Sun acquisition on Oracle|Hyperion EPM, I feel justified in composing this blog despite the rather small footprint of EPM on the overall stack.

So, what does it mean for Oracle|Hyperion EPM?  Well, in the short, term, not much.  There is no question that Oracle has made great strides with the original Hyperion software offering, enhancing the customer experience with new features and functions, as well as integrating the technology with ERP solutions for drill back and tighter integration.  The Sun acquisition, in immediate terms, is a long term strategic play and the short term effects for EPM are minimal.  Things do get interesting in the long term, in my opinion.

The long term effects of the Sun acquisition will be felt throughout the Oracle technology stack, Hyperion EPM included.  Here's a very brief sampling (clearly not exhaustive) of what I believe we will see in the next 3 to 5 years.

1. Oracle|Hyperion EPM in a box

• "EPM in a box" offerings will begin to surface, essentially integrating hardware and software for a simple plug a play solution. Today, a customer will make a license purchase of Oracle|Hyperion EPM (think Planning, Essbase, HFM, etc) and will then make a determination on what hardware to use. Most of the time customers select a set of servers which run a version of Microsoft Windows, although they do have the option of selecting UNIX based environments (in my experience I have only really seen Essbase used with consistent success on UNIX boxes). Customers then procure the hardware, install the OS, then have a consultant come in and install the Oracle|Hyperion components. Sometimes we see "fancy" setups that use SAN environments but mostly the work is restricted to the set of boxes designated for Oracle|Hyperion EPM use. In the new world, Oracle will literally deliver a server(s) to your server facility, or even host it for you, that has everything installed and ready to go with a few minor tweaks (security authentication, etc). They may even have that locked down with enough pre-installation contact with the client. So, from a client's perspective, after conducting your due diligence on EPM solutions, all you need to do is take delivery of your box and plug/play. Ease of use cannot be understated in this regard and neither can a "clean install". I have seen companies struggle intensely with bad installs, which ultimately has led many to completely reinstall the software. A bad install can haunt you for a very long time. In the future, a customer will simply identify what they want to buy (Hyperion Planning, Hyperion Essbase, HFM, etc) and the servers will show up at their data center, ready to go. There's just something beautifully elegant about preconfigured hardware and software, particularly when they are engineered to go together (if you don't understand what I mean...look at Apple and their suite of products which unite software and hardware).

2. Reduced strain on infrastructure related issues

• Now that we have EPM in a box, we can expect that infrastructure related issues with the hardware/software should begin to subside in a material way. Today, we constantly see issues with upgrades that occur on the server OS which then cause a conflict with the Oracle|Hyperion EPM software and subsequently require the trained eye of an Infrastructure Consultant that specializes in this area. Tomorrow, the hardware will be specifically built to support Oracle|Hyperion EPM. Any changes to the hardware will be tested in advance of release, to be leveraged by the client and thus avoiding conflicts. Infrastructure related issues can be a huge problem for customers as they fight to keep their end users happy. End users tend to really enjoy the rich analysis that Oracle|Hyperion EPM offers and they place the system at the center of their daily activities. Any downtime is frowned upon and can reduce end user satisfaction quickly.

3. Improved scalabilty

• Today, there are hardware guidelines provided Oracle depending on the Oracle|Hyperion EPM software tools purchased, however, there is this grey area of what to recommend for large scale deployments. Don't get me wrong, no other EPM system, and I REALLY mean no other, can scale the way that Oracle|Hyperion EPM can scale. However, when recommending hardware to a client, certain variables such as user counts, etc must be factored in. Most of the time, consultants will use the Oracle guidelines as a proxy for recommendations and combine that with their own experience. In the future, this new "purpose built" hardware may render experience and recommendations irrelevant. Plainly stated, if you are buying Oracle|Hyperion Planning with full use Essbase and you are rolling this out to 1,000 users, well, your software will arrive preconfigured to work with the right amount of hardware for that task. I love it...let's hope it happens.

4. Tighter integration with...well, just about everything

• Without question, the key benefit I can foresee to clients lies in the ability to unite the organization from a technology perspective. Think about it: start at the top with strategic planning tools like Hyperion Strategic Finance to set out goals and model high level future movements in the business, then use Hyperion Planning to take this down to a detailed level, only to be supported by seamless drill thru functionality to E-Business Suite, which will be linked tightly with demand planning tools like Demantra, etc. In theory, a customer could have set of Oracle|Sun servers completely built out to support their entire supply chain from Design to Manufacturing to Financial Consolidations and Reporting. Today, these systems exist in various capacities, often linked via a hodgepodge of servers throughout the company (and, heaven forbid, with the use of Excel-macros, etc). I know of consultants that have built entire careers designing, building and maintaining data interfaces. Data interfaces can be a huge burden on any organization and tighter integration of the entire Oracle stack, thanks to good hardware/software engineering via the Sun acquisition, can really put a significant dent into this area. This is a huge competitive difference when you think about the longevity, sustainability, and maintenance of the system.

5. Countless other benefits that I have missed...

Obviously I have simplified things greatly.  The bottom line is that the Sun acquisition is good for Oracle and good for Oracle|Hyperion EPM.  Stay tuned.  I'm sure Larry and Co. will be unveiling more and more innovation related to this deal over the next few months...

Uh Oh, Your EPM Project is in Trouble...What Should You Do?

First, let me say openly, it happens.  Yes, Enterprise Performance Management projects do occasionally go the "wrong" way, leaving a trail of tears, blown budgets, and irate Executive Sponsors.  Most research shows that IT projects (please realize that I consider EPM projects to be much more than IT projects but this is the best data point we have) have a 60% to 75% chance of falling short of expectations, which is just a nice way of saying that they fail.  So, the odds are against you before key stroke number one.  If someone tells you that they have never had a project go awry, they either have very little true experience or they are lying to you.  If a consulting firm tells you something along those lines, run...run like the wind and don't look back.

If you are in the middle of a bad project, keep reading.  If you are in the middle of a good project, keep reading.  If you are about to start a project, keep reading.  If you are perfect, without failure, and have an affinity to walk on water, hit Starbucks and buy yourself a well deserved cup of coffee.  

Now that I have everyone's attention, here are my top three recommendations on what to do if your EPM project is taking a turn for the worst.

1.   Don't Panic.  Stop and Think.

Generally reserved for personal emergency situations, this recommendation cannot be understated within a project based business world.  Your external project manager has just informed you that all key metrics involving scope, dollars, and time (the Consulting Trinity) are currently out of control and will only get worse.  It would be very easy to panic here, but instead now is the time to stop and think.  Realize that a physical reaction does not exist which will make the situation any different.  Jump, yell, throw a pen, slam your computer, it doesn't make any difference and you only make yourself look rather ridiculous in front of your colleagues, and they will remember this.

Instead, stay calm and consider the levers that you have to pull.  Every project has levers including people, cost, time, scope, expectations, etc.  I will describe how to do this in points 2 and 3 below but in the meantime, poise counts in this situation, and you would be well served to ingrain that in your thinking now.  And on another note, I know it may seem like the wrong time, but remember that you are about to have an extremely valuable experience.  In my opinion, almost anyone can handle a good situation, but it takes an extraordinary individual to deal with a bad business situation.  Navigate this field of land mines well and tough situations begin to look easy...and become the type of professional Executives value the most...people like them, frankly.

2.    Figure Out What to do Internally

• Identify the key internal players
• There are typically two players here: the internal players and the external players.  Internally, there is a key set of people that really matter to the project.  Usually, these individuals include the project sponsor (usually an Executive) and the end users, both of which are expecting you to get this project done with them in mind.  The project sponsor wants the project completed within the allotted dollars and probably isn't so time sensitive and the end users are more time sensitive and care less about the project budget.  Either way, you've got a problem and a formidable audience but not all participants are created equal.  Some have power and others have less power.  Figure out who has power and focus on them (a no-brainer, I know but you would be surprised what I have seen over the years).  Then...
• Talk to the those with power and influence and reset expectations
• Be honest.  Be brutally honest.  Paint the true picture of what is occurring, but also create a proposed plan of action to get the situation resolved.  Do not show up empty handed...you better have a proposed plan, but stress the "proposed" part.  You are there to explain the situation, sell your plan, and solicit feedback, which will ultimately get you the support you need.  If the project scope grew, say that.  If the consulting team is failing, say that.  If you need more money, say that.
• Only go to the well once...go twice and suffer a professional death
• Whatever you ask for must be more than sufficient to get the job done.  Your first instinct will be to sugarcoat the real numbers and timeline required to finish the project.  Resist all temptations to do this.  Put the real numbers and timeline out there.  Be fearless in this regard.  At the same time, you will need to introduce a new level of oversight to ensure this does not happen again.  Your plan should outline this new set of controls that will guarantee success.  Yes, I said guarantee, because, barring a sponsor driven expansion of scope/dollars, you only get to do this once.  Do it twice and you've lost all credibility and should probably get a job that isn't so project driven.
• Now that you have the funds and extended time, over communicate
• Ok, hotshot, you've successfully navigated the internal team.  Now is not the time to take a few days off and count your blessings.  Whip your team into shape.  Be merciless with deadlines and dollars.  Drop by the executive sponsor's office for 5 minutes at least once a week and let him know that you are pushing your hardest to get the job done.  Let him know your plan is working.  If your plan is not working, let him/her know that too.

3.    Figure Out What to do Externally

• Is it really the consulting team's fault?
• Chances are that you are working with an external consulting team that focuses on EPM.  Clearly the situation has not gone as you envisioned and the EPM utopia expressed within the consulting team's PowerPoint deck now seems like a slow trek thru the bowels of Hades.  But is it their fault?  Only you can make this assessment but I would strongly encourage you to be candid about this.  Do not simply use the consulting firm as a scapegoat.  That may solve your internal problem (everyone loves to hang the consultants...come on, admit it, it's fun) but in the long run, switching out the consultants for unfounded reasons only increases the cost to your company.  If the consulting team has held up their end of the bargain, be honest about that and be thankful that you have a consulting partner that has performed.  This is a valuable, and rare commodity.    That said, if the situation stems from actions taken, or not taken, by your consulting partner, you must confront them.  Demand an explanation.  Demand a remedy.  Determine whether or not the relationship is good for your company.
• If it is the consulting team's fault...
• Don't be afraid to switch the team out for another team.  Look, if it really is their fault, unless you are exceedingly close to finishing the project, it is likely that the actions will be repeated.  I am risking professional exile here, but there really are firms that have a "change order" strategy for their business.  This means that they will bid your project at a low dollar amount to win your business, then they will bank on change orders (requests/approval for more money and time) being processed.  Firms like this are counting on you to fear changing them out.  The mindset is: you've come this far with us, you will be hesitant to make any changes, so open up the checkbook.  If you feel this is what is occurring, I will say it again...run...run like the wind.
• What to look for in a replacement for the consulting team
• Some say that the definition of insanity is to do the same thing every time and expect a different outcome.  There's a great deal of truth in that and quite relevant when selecting a new consulting partner.  If you are set on switching out the consulting team, be sure to do your diligence on new prospects.  Look for a firm that has the type of client references you would respect.  Tell them about the situation you just faced and ask them how they would have dealt with it.  Be frank with new prospects.  Let them know that the stakes are high because you've asked for more money and time, and we all know you only get to do that once.  As a consulting professional, I hate to say this, but perhaps a financial holdback (some % of the billing fee) is in order place some skin in the game.  That may make sense and can create more urgency, etc.  But of all the traits to look for in your new consulting partner, I would submit that you need an expert that actually has turnaround experience.  Find someone that really has dealt with really bad project situations and literally turned them around.  Kind of like you just did (by following the rules within this invaluable blog...:)).  Find someone like you.

So there you have it, a quick and dirty primer on how to deal with a the EPM version of the Titanic.  I've hit the high points but have definitely skipped a lot due to time constraints.  If you have any questions or want additional insights, feel free to email me at tantunez@percentix.com.

The Percentix/Prithvi EPM Consulting Acquisition

As most of you know, Percentix, Inc. was acquired by Prithvi Information Solutions, Inc. in mid-October of this year (visit http://www.percentix.com/ for more information on the acquisition).  Today I would like to answer a few questions surrounding the nature of the deal and what it means for our clients and the marketplace in general.

Q: Why did you decide that an acquisition strategy was in the best interest of Percentix's clients and employees?

A: There is no question that the nature of the deal was strategic.  I believe that there are three primary strategic reasons for the deal.  Firstly, Percentix was seeking to partner with a larger company that would provide a platform for solid, consistent growth.  We talked with many prospective business partners but found Prithvi Information Solutions to be the best balance between the inherent benefits of a large, multinational, publicly traded company and a culture of entrepreneurship.  Percentix has always been extremely entrepreneurial, particularly when compared to its competitors.  Looking at our historical revenue mix, we have traditionally secured new business via competing in very difficult RFP processes against much larger companies, and did not rely on an approach that was solely "relationship based".  Instead, we took a "value based" approach.  I think the Percentix way is simple: we are smart, we are motivated, we know how to innovate, and we can win - irrespective of the competitive landscape.  Maintaining this entrepreneurial culture is critical to our long term success, as are the traits a large company brings.

Secondly, Percentix is a company of bold, innovative ideas, ideas that can become a reality with the assistance and expertise of a larger company such as Prithvi.  I've been involved with EPM for nearly a decade, and over those years, and countless implementations, I truly believe that the nature of EPM consulting is headed for a major set of changes, changes that few firms are willing or able to face.  The combined Prithvi/Percentix entity will have the expertise and the value chain necessary to set the newest trends in our industry.  We are extremely excited about this.

Lastly, our clients will be much better served as a result of this transaction.  Specifically, we now have the ability to establish a company-wide relationship with our clients, fueled by the deep IT service offerings that Prithvi brings to the table.  Clearly, as a standalone company, Percentix offered world class EPM consulting capabilities, however, we did not have the ability to respond to many of the other more traditional IT requests that we see on a daily basis.  Now, as a combined entity, we can provide services ranging from ERP implementations to business intelligence to establishing a global data center.  Most large IT organizations have a difficult time providing EPM expertise because they view this area as "too small".  Prithvi Percentix offers the best of both worlds: world class EPM services and world class IT services. 

Q: Can you describe the acquiring company?

A: The following information is provided in a press release. 

Prithvi is a global provider of IT Consulting and Engineering solutions. Prithvi's decade of experience helps it to continually innovate and address latest imperatives in IT industry. Our operations began in the year 1998 with our registered office in Hyderabad, India and US head office located in Pittsburgh (PA). Prithvi's global network of development centers and sales offices are in Europe, Middle East and Asia Pacific. Prithvi operates under five strategic business units jointly addressing a wide spectrum of client needs. Our solutions are particularly advanced and powerful for these vertical markets: Healthcare, Retail, BFSI and Telecom. With services that range from consulting to comprehensive project implementation, our industry specialists understand business and will help incorporate them quickly and effectively. We strive to achieve best quality of service by constantly examining and measuring the processes by which we deliver our solutions. For more information, visit us at http://www.prithvisolutions.com/.

Q: What changes will we see at Percentix due to the acquisition?

A: Percentix will operate as a wholly owned subsidiary of Prithvi.  As such, the changes on a day to day basis are minimal.  Changes will be most visible to our clients and prospects as we offer full service IT capabilities and enjoy the backing of a publicly traded company.  Today, Percentix employees continue to serve in their pre-acquisition capacities and we have no plans to change that set of duties.  The Executive Management team remains in place.

Q: Were any employees laid off due to the acquisition?

A: No.  All employees remain and no changes have been made or are forecasted to be made.  In fact, we are interviewing extensively right now, looking for the right mix of business/technical skills within future consultants that match our needs.

Q: Was this acquisition in response to any negative changes such as the economy?

A: Absolutely not.  Our tenacity and ingenuity allowed us to really weather the downturn quite well.  Despite the relatively small size of our business development team, our pipeline of business is the largest in the history of the firm.  This deal was closed based on strategic factors.

Q: What new service offerings will be available to Percentix customers based on the acquisition?

A: Well, we will be able to offer a long list of new service offerings to customers based on the deep IT strength within Prithvi.  For more information on Prithvi's IT service offerings, please visit http://www.prithvisolutions.com/.  Moreover, Prithvi Percentix is developing entirely new lines of business that will leverage the synergies of the acquisition.  Subsequent white papers and blog articles will provide details as they become finalized.

Q: Why would such a large company want to buy a small-sized company?

A: To the consternation of some of our competitors, this deal does involve a $300+ million publicly traded company (Prithvi) acquiring a small private firm.  I say "consternation" because it really lends itself to the large customer value/brand that Percentix has been building over the years.  We deal with big projects at big companies, plain and simple.  Many of our engagements involved multi-million dollar budgets that spanned multiple years, and our relationships/references are maintained at the highest levels within our customer base.  Likewise, we operate with the entrepreneurial spirit of small firm combined with the business operations of a large company (CXO level).  We have behaved and operated as a much larger entity.  This is in contrast to our competition (of comparable size) which tends to operate as a set of subcontractors on retainer.  Such a business is established for short term profitability and refutes the idea of a creating a process-driven organization that derives fundamental value for clients over the lifetime of the relationship.  We have a 5 to 10 year business horizon, which may seem odd to most given our size, but we believe this permits us to provide the most value to our clients.  Frankly, the fact that such a large established company like Prithvi would acquire us is really a source of pride for me and my management team.  It validates our strategy and purpose.

Q: What synergies do you expect out of the deal?

A:  The synergies we will experience with our new parent lay primarily on the business development area, resulting in cross-selling opportunities that are sure to result in more growth than we could have ever managed on our own, and in new product/service development.

Q: Is there any overlap with the acquiring firm?

A: Other than back office functions, there is very little overlap between the two firms.  Prithvi was looking to establish a footprint in the EPM space and believes that our methods/processes offer them the best long term opportunity to do so. 

Q: What is the structure of the deal?

A: Percentix will operate as a wholly owned subsidiary of Prithvi. 

 

 

 

EPM Technology Can Help Your Company Avoid Financial Restatements

From reading the news, one might believe that restatements are fast becoming the "norm" rather than the exception.  In reality the vast majority of publicly-traded companies haven't had to restate their financials and take their fiduciary responsibility seriously enough to put the right internal controls in place BEFORE things get so messed-up that they need to do a restatement.

CFO Magazine recently had an article on Sarbanes Oxley 404(b) compliance:  Does Sarbox Reduce Restatements?  The article states that companies that don't have their internal controls verified by outside auditors are 46% more likely to have a restatement than those that do.  So, if you were the CFO of a non-accelerated filer - companies with market capitalizations under $75 million - (much less a CFO of a company with a market cap over $75 million) why wouldn't you spend the money to have your auditor verify your internal controls (and more importantly actually put  adequate internal controls in place)?

• Time - CFOs have a lot on their plates and external filings, while important, can surely be pushed down the list when you've got debt covenants and low cash reserves taking top priority
• Quality - Having audited financial statements is simply "enough" for many boards, or was, until recently. Many companies are still "transitioning" to the new reality under SOX and frankly, with some of the changes recently proposed in congress, are waiting to see what that reality is.
• Cost - Auditors (internal and external) and consultants cost money and at it's definitely easier to get money for a project when a restatement is necessary than when you "might" have to make one

To be sure, managing the balance between Time, Quality and Cost is a difficult proposition but not an insurmountable one.  Below are the three things that my experience has shown companies should look for in any project you do around improved financial consolidation, planning and/or reporting:

1. Flexibility - Implement a tool/technology that gives you more than just internal controls. There are many tools in the market today that are purpose-built to provide BOTH internal SOX compliance AND improved reporting.
2. Scalability - Don't create something you're going to grow out of in the next three to five years. Look for tools and technologies that easily scale up and support large numbers of users both at corporate but also out in the field (they're going to want to look at the reporting after all...)
3. Supportability - If it takes an army from IT to run or you need a degree in applied statistical theory to understand, it might not be the right solution. Tools and technologies that can be owned and operated by finance but supported by IT are best. This puts the power to make changes quickly in the hands of finance and ensures that it's built on a sustainable infrastructure.

If you put a tool/technology in place that's flexible, scalable and supportable you'll have a much better chance of maximizing your ROI on the money you spend (cost), getting the most capability and accuracy out of what you implement (quality) and ensuring that the time you spend isn't wasted on something that will end up as "shelfware" a few years from now (time).

Five Steps for Effective Drill-through

Imagine this, you are in Microsoft Excel and looking at the P&L for the last month and some numbers look odd.  Where to go next?  More often than not you will then open a session to your general ledger system (Peoplesoft, Oracle E-Business Suite, etc.) to research the numbers.  You are not alone, in fact we recently surveyed a Fortune 1000 company and discovered 9 out of 10 analysts would want to drill back to the source general ledger system. 

To mitigate this pain, Oracle has made a conscious effort have the drill through seamless to the end user.

Oracle has released a new module to the Hyperion Workspace, called Enterprise Resource Planning Integrator (or ERPi).

Before you jump into the research on what ERPi is and what can it do for you, here are five winning steps to consider when making the decision to drill back from the Hyperion environment to your general ledger system.

1) Determine that in fact your Hyperion user base has the need to drill back to the general ledger system.  Do your users find it difficult to drill through today?  As like any finance related project, getting buy in from the user community will ensure project success in the future.

2) Where do your users drill back from?  Is it from a Microsoft Excel Essbase Connection, Hyperion Financial Report and/or Planning Web Form?  If you answered yes to these you are definitely ready for EPRi.

3) Ensure you have or planning to install Hyperion EPM version 11.1.1.3.  EPRi is a module that requires an 11.1.1.3 environment.

4) Do you have the right ERP systems?  ERPi currently supports certain versions of Oracle and Peoplesoft (see whitepaper for more details) with SAP scheduled next year.

5) Once you get through the technical hurdles, now comes the implementation.  Do you have the right people on finance team to implement an ERPi project?  Should you seek expertise outside your organization/company?  These are all valid questions, and probably the most difficult to answer.  To aid with your decision, the whitepaper below has more details on ERPi and its implementation.

To learn more, download our whitepaper on the FAQ surrounding the EPRi module now.

Dashboards vs. Windshields

Let's do a test, the next time you're going somewhere in your car, get in (be sure to buckle-up, as I can almost guarantee an accident with this test) and try to get where you're going by ONLY looking at the dashboard.  Don't look at the rear-view mirror, your side-mirrors or the windshield.  Crazy, right?  But this is exactly what many of the organizations try to do when it comes to understanding their performance.  Leading organizations need to have dashboards but they also need to leverage the other tools at their disposal to effectively navigate their way to the future.

So, if we keep with the car analogy, what are the tools that leading businesses can use to measure and improve performance?

Windshields = Strategic & Annual Plans - Do you have a strategic plan?  If so, when was the last time it was updated?  Do you look at it throughout the year?  Does it map out the economic and competitive landscape?  Does it include feedback from your current customers and clients and (maybe more importantly) prospective customers and clients?  The strategic plan, when done right, gives your organization insight into where you're trying to go AND through economic, competitive and customer analysis what the possible road-blocks may be on the way.  I've worked with hundreds of clients over the past ten years and the ones that stand-out as exceptional had well-defined strategic plans that were tightly integrated with their annual planning cycles.  This takes a commitment to understanding more than just your business but also that of your competition and economic factors that can influence your future.  Not an easy task, to be sure, but can help your organization avoid "head on collisions".

Rear-View Mirrors = Reports (Customer-Centric) - I'm sure you've all heard the line in bank commercials: "Past performance is not a predictor of future returns".  A tautology if I've ever heard one, but past performance can be indication of the trend future returns are likely to have if no changes are made (internal or external).  Understanding the Voice of the Customer (VOC) is probably the single best predictor of future returns there is.  What I've found is that many organizations either don't know who their target customer is and/or have a hard time determining how to start a conversation with their existing and potential customers.  Reports showing your to current customers over the past 1, 2 and 5 years as well as your backlog, by customer, and pipeline, by customer, are invaluable in understanding where you've come from.  Take the time to analyze why the road was smooth at times (high order volume and/or margins) and why it was rough at times (low order volume and/or margins).  When you understand why your customers are selecting you and why your competitors customers aren't you'll have a much better idea of how to better serve your target market.

Side-View Mirror = Market Research - Does your organization have a way to educate both senior executives and departmental mangers on the external and competitive landscape?  If you don't there's a good chance decisions are being made that are almost exclusively based on internal factors.  Marketing and/or Finance is usually best suited to get this "peripheral" information.  When you have a good understanding of the economic (finance) and competitive (marketing) landscape, it's much easier to back around corners or understand who's coming up alongside of you in the marketplace.

Dashboards = Dashboards & Analytics - And so we come to the subject of this blog, the dashboard.  Dashboards provide a way to combine internal AND external information but primarily show the internal workings of an organization.  Fuel (cash), speed (bookings, billings and backlog) and other indicators by function such as finance, human resources and operations are the standard dashboards components in most organizations.  When you combine your strategic and annual plan data with external data such as financials from your publicly traded competitors and external economic factors, the dashboards get a lot more interesting, and useful.  Again, past performance is not an indicator of future returns but when combined with the windshield and the mirrors you get a more-complete picture of your surroundings.

I'm not telling most of you who are reading this anything new but I hope I'm stimulating some discussions on how your organization is "driving" toward the future.  In short I hope your organization:

1. Has a strategic and tactical plan
2. Knows who your clients/customers really are
3. Knows what your clients/customers really want
4. Knows something about the economic environment you're operating in
5. Can provide the above information to decision makers in a timely and accurate manner

I can't promise an accident-free trip but I can promise you'll enjoy the ride a lot more!

One final note, if you do actually try this experiment in your car, I take no responsibility for any damages incurred to you, your property or others during the course of the experiment...

 

CFO Question: So how many reports should I have in my organization?

Let's use the 80/20 rule today. 

In the hundreds of meetings I have had with CFO's, VP's of Finance, Financial Planning Manager's, etc there is one question that seems to strike fear into their respective hearts: how many reports should we have?  I suppose the reason for this is twofold.  First, given the simplicity of the question, Executives worry that the number they provide will be either too large or too small.  Secondly, Executives worry that they will be ridiculed if they provide an answer of "I don't know".  So, I'll give you the Economist's answers: it depends...but we can provide a good range for most situations.  Clearly the differences between organizations drive varied reporting needs, however, if we narrow the question a bit, without diluting the end goal, we can provide some fairly good rules of thumb. 

In the end, enterprise performance management is about managing the business, and it is not about reporting.  If we isolate the true management of the business, using the CFO's perspective as our proxy for report volume, I believe we can provide much better guidance.  In my experience, a typical CFO, and his or her direct reports, can effectively manage 80% of the business operation with the use of 10 to 20 reports.  Within these 10 to 20 reports, using EPM technology, a finance professional can analyze various cost centers, roll ups, etc with extreme precision and accuracy.  Relying on more than 10 to 20 reports suggests an overuse of technology and a misunderstanding of the core business.

The remaining 20% of the business can be analyzed and managed using ad hoc reporting tools and databases.  Now, be sure to pay attention to these "outlier" reports because they will lay the foundation for new ways in which to analyze the numbers.  Analysts are extremely crafty and resourceful, often mining millions of rows of data to secure a new insight into the business.  Quite iterative, this process will yield new reports that take into account market changes, competitive movement, etc AND will also reveal holes in your current data, which is to say some of the data required to manage the changing nature of your business does not exist because it is not currently recorded...which can lead to changes in the underlying ERP system. 

So, use the 80/20 rule with respect to reporting.  Don't' let anyone lead you to believe that you must build thousands of reports simply because the technology can do so a bit more quickly.  It's smart business and will save you a great deal of pain and effort in the long run.

Are You A Chief Financial Officer Thinking About Enterprise Performance Management? 5 Keys to Success for CFO’s

I've spent the better part of 8 years working with CFO's, VP's of Finance, Corporate Controllers, FP&A Managers, etc on Enterprise Performance Management (EPM) related initiatives.  Spanning verticals ranging from metals and mining to retail to medical devices, the keys to success from a CFO's perspective remain the same, in my opinion.  Initially, there is a tendency to "over think" what needs to be done, coupled with a deep admiration for the technical sophistication EPM tools have acquired over the years.  And although my clients differ in their core businesses, the keys to success, as well as the levers of failure, remain relatively constant.

One key point to keep in mind about this blog, it will not be focused on tips and tricks for administrators or how to build a better calculation (there are plenty of blogs about this).  Instead, this is a blog meant for Executives contemplating an EPM solution or managing an existing EPM solution.  This blog will be business focused because that is where the true value of these systems lies.

So here is a quick primer, admittedly based on both my successes and failures, that will assist CFO's considering EPM solutions or CFO's with existing EPM/Budgeting, Planning, and Forecasting deployments that have not met expectations. 

Top 5 Keys to Success for CFO's Considering EPM Solutions and Software

1.  The most important investment you will make is not in EPM software. 

Perhaps this is the consultant bias in me but there is no question that an accurate diagnosis of where you want to go is required. Sometimes referred to as "visioning" or "diagnosis", CFO's should expect to spend anywhere between $50,000 to $500,000 (depending on the size of the contemplated deployment) analyzing the basics. As rudimentary as this sounds, it is rarely done. More often than not, there is a race to buy the "technology", ostensibly fueled by demonstrations that cause even the most seasoned of CFO's to superimpose their organization into a prebuilt software demo. My preliminary estimates conclude that companies which do not conduct a thorough up front analysis typically spend a factor of 2 to 3 times the original financial estimate. Lastly, be extremely wary of consulting firms that provide you with a fixed bid or "rock solid" estimate of implementation costs without going thru an initial diagnosis phase. Most EPM firms will skip the initial step because they are more attuned to dealing with the technical components of an implementation. 

2. Your data is probably not as good as you think. 

I know what you are doing to say: "I've spent all of this money on ERP systems and consulting and my data is probably not right?". Well, it's a bit more complex than that but suffice it to say that most companies have actually increased the amount of manual excel data manipulation that occurs outside of the ERP system post-ERP implementation. The reason for this is simple, ERP systems are great at processing millions of transactions quickly but are not made for business analysis. Good financial analysts get around this by dumping data into Excel and creating robust models. Many clients struggle with getting clean financial data (actual data and metadata - think cost centers, product categories, etc) into their financial planning or consolidation systems. And the stakes are high. Bringing a EPM system into a production environment is difficult enough, but to bring a system online with actual data that is incorrect is the single quickest way to lose end user confidence and acceptance. So, think about your data before embarking on an EPM implementation. A good firm will never overlook this critical point.

3.  Face the reinvestment realization and manage it.

Over the course of nearly a decade, I have seen that the reinvestment realization component of EPM is often ignored by Senior Executives primarily because of the incremental financial cost. Here's the harsh truth, two things are sure to change over time: the way a company reviews/analyzes/plans for the business and the underlying technology. For most companies, these changes occur within a 3 to 5 year period but there are companies that are inherently so dynamic that they will fundamentally change their forecasting/budgeting methodologies annually. These business changes will lead to material changes in the EPM deployment, which of course will lead to incremental costs in time and money. Similarly, expect newer and enhanced versions of the software to surface every 1 to 2 years. EPM technology is constantly changing and I strongly advise my clients to seriously consider upgrades every 1 to 2 years. Although this might sound like overkill it really saves clients a great deal of pain in the long run. The longer you postpone an upgrade, the more difficult it will become to upgrade from technical and business perspective. These are sophisticated tools and should be treated as such. I have seen upgrades postponed for 5 years, which ultimately led to a much more difficult upgrade path for the client.

4. Projects tend to have challenges at the beginning...and definitely at the end (Change Management/Deploy). 

I briefly addressed the challenges faced at the beginning of project in point 1: lack of investment in diagnosis. Clients are probably tired of hearing me say this but I believe that is a singular truth. In the middle of a project there is a "heads down" mentality increases the difficulty required to identify problem areas. To be sure, the "build", or middle portion of the project, is creating true value that end users can utilize to manage the business. However, EPM projects have historically had a rough track record with respect to Change Management. Why? Too much focus on technology. Plain and simple. Make sure you spend, at a minimum, as much time and money on the final stage (Deploy - testing/training/documentation, etc) of the project as you do on the initial stages (Diagnosis and Design) of a project. Do not make the mistake of rolling a system that has been partially tested and give end users every opportunity to receive proper training sessions. I know this sounds simple, but again, much like the diagnosis phase of a project, it is often overlooked because so much effort is spent on the build phase.

5. Focus on three key themes: Simplification, Standardization, and Communication.

The best EPM projects are "about" something. In my opinion, if project team members, at the highest and lowest levels, cannot explain what the project will achieve in one sentence, you probably have a problem. After numerous engagements across various industries, I have found that simplification, standardization, and communication are three key themes that really drive to the heart of a truly world class EPM project. A quick chat on each:

• Simplification - Simplification does not mean your EPM solution will not be sophisticated, and in fact, I would strongly argue the contrary. Over engineered EPM systems, and believe me there are many of these, represent a fundamental lack of understanding. It is much easier to compensate for this lack of understanding with high powered calculations or fancy dashboards than it is to truly ask the right questions of Executives and end users. Within your EPM project, look to simplify the most critical business points: create simple models that accurately reflect the business, design a system that is intuitive, remove manual data entry and use driver based planning, eliminate useless reports, etc. For every part of the system, you must always ask "how can this be made simpler?" because a process can typically be made simpler, but discovering how this can be done is more difficult than it sounds.

 

• Standardization - To really have an impact with EPM you must standardize. The efficiency gains reaped from standardization are, by most studies, within the 15% to 35% range depending on the circumstances. Standardization takes many forms but the most basic are data definitions/naming conventions, look and feel, modeling techniques, global business drivers, etc. Again, you are probably surprised that I am stressing this point but, in my experience, even the best of companies forget this point for a number of reasons.

 

• Communication - So much of EPM is centered on communication. Focus on process for just a second: if you are a corporate department managing the budgeting/forecasting process across the enterprise, consider how much time you spend communicating dates, submission rules, guidelines, etc to your end users. I spent a few years as an FP&A Manager at Toshiba Semiconductor and can fully appreciate how much time is spent on such tasks. With EPM, you can eliminate a great deal of the overlapping and repetitious communication that occurs on a daily basis with your end users. Stress to your team the importance of using the system as a communication tool.