Request a Consultation

CheckPoint Consulting Blog

Regular readers of my blog posts will know that I like to spend a fair amount of space talking about the ‘how’s’ of owning and managing an EPM system. In all honesty, anyone can purchase a software solution, and many companies do, but the real test comes during implementation and support. Over my many years of consulting I’ve noticed that clients who enter the implementation stage with a support and maintenance plan already in mind tend to be more successful. The same success also follows clients who start a project with some sort of future product lifecycle in mind.  But what happens when your company hasn’t had the luxury of time to be proactive, or if you have inherited a system that is out of date through an acquisition, or being used for cross-purposes? Now is the time to have an open conversation around these intricacies. The following article, and a Q&A panel I am hosting next week hope to answer some of those questions. So here are some opening thoughts to get the dialogue rolling:

read more

New Financial Reporting Web Studio and end of life for Web Analysis

read more

Essbase allows for active/passive clustering of the servers for use in a failover or DR scenario.  Oracle uses OPMN to handle the failover from one node to another in the event of a failure. The EPM Config tool, used to configure ESSBASE, does not update the OPMN.xml file correctly and needs to be manually updated as a post install step.

read more

Since 2002 corporate reporting functions have been challenged continuously. None of us have been excused from increased controls and requirements on the content that businesses report to our stakeholders. If organizations are to deliver rapid and accurate financial close data they need to be able to control and improve the entire ‘extended’ financial close process. Top organizations recognize that the ‘close’ actually begins with sub ledgers and ends with the transfer of statutory filings; therefore are adopting integrated financial close solutions that address this whole process.

read more

It’s not uncommon these days to load balance the HTTP layer for the EPM Stack. This includes using a virtual ip address or ‘VIP’. Many of our clients are also implementing SSL offloading at the VIP.  When using SSL, sometimes EAS will fail to load the EAS Console correctly. It will usually show an error with three possible bad URLs.

  • a URL that is not SSL
  • or the URL may not use the correct VIP address
  • or the URL may even be pointed to the default 10080 port

To force EAS to always call back to the correct SSL address, you can add a java argument for EAS “-DEAS_FE_URL.”

In Unix Environments:

The java argument should be added to the set CustomParamatersEssbaseAdminServices.sh (or bat). The file is found in the EPM_INSTANCE/bin/deploymentScripts/ directory. The argument can be added directly into “JAVA_OPTIONS” section of the file, or as its own entry. I prefer a separate entry so I can better see it has actually been applied.

I add these lines in the file:

They can be added at the top or the bottom of the file.

In Windows Environments:

The java argument should be added appropriately in the Windows Registry.

Related links:

  • Want to meet us in person at KScope in Chicago? Join us!
  • This Essbase Subvar Updater Tool generates a MaxL script based on a few inputs. Download a copy now.

 

 

read more

When you create a new Essbase application, one task that needs to be performed is creating substitution variables. This is usually done one at a time, selecting the application, selecting the database, entering the variable name and the corresponding value. This task gets really tedious when there are so many to add.

read more

Historically, there were a lot of reasons why Essbase applications were BSO, but now ASO is the heavy lifter - with quicker data loads, instant aggregations, faster calcs, greater dimension allowance and lengthier dimensions. With CheckPoint Consulting’s starter syntax map, make the leap from BSO to ASO easy.

read more

In the previous part of this blog series we shared three little known points around Exalytics. These discoveries were learned while implementing some of the largest North American deployments of Exalytics. These blogs are meant to be the precursor for a webinar around the entire topic of Exalytics. You can find the first blog here, the following four points are the second part of our open discussion.

read more

We’ve seen remarkable change in the last two years. For example, 2015 was a record year for mergers and acquisitions. Altogether M&A volume hit an all-time high of over $5 trillion, surpassing 2007’s record of $4.6 trillion. 

read more

In a few weeks time Ill be delivering a webinar about Oracle Exalytics.  The goal of the webinar won’t be to encourage you to run out and buy an Exalytics server, but rather to educate the public on the pros and cons of Exalytics.  As the EPM Infrastructure Practice Manager at CheckPoint, I and my team have been engaged with two of the largest ongoing Exalytics implementations in North America. We have a number of lessons learned about Exalytics and its surrounding technologies, such as ZFS and Exadata. 

read more