Request a Consultation

CheckPoint Consulting Blog

Not so long ago an Oracle finance survey found that more than 50 percent of finance managers in global companies specified a lack of visibility into reporting. Many also admitted difficulty in controlling the quality of financial data across the reporting process.

read more

Smart Lists have become a little smarter in EPBCS with Dimensional Smart Lists. Dimensional Smart Lists are enhanced only in EPBCS to make data mapping easier among cubes. Here are some succinct steps to walk you through the set up.

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 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

Not only is Calculation Manager required when upgrading to more recent versions of Planning, but it is also required when migrating to PBCS.  In recent conversations with users, I have heard that this is still a hot topic as many companies are still on older releases.  Depending on the version you are migrating from, the necessary steps will differ.  This blog article explains how to migrate from version 11.1.1.3 and forward by exporting and importing the business rules.

read more

Our Enterprise Performance Management landscapes are changing. With an increased emphasis on efficiency, reporting and a new found stress on the information technology industry, being a project implementation leader today is very different than being one in 2006. With the changes in the industry, it’s easy to lose track of how the product has changed significantly over the years.

read more

In the first part of this blog I discussed the dilemma facing decision makers as they look to the future of EPM within their environments.   I discussed the myriad of choices the modern CIO faces with ‘how’ and ‘where’ to deploy a Hyperion EPM solution.   I covered the ideas of TPS (Time, Place, Source) and gave same insight into the value of delivering more within each of those categories than has been traditional.  Today I’m here to talk about how we go about achieving that.

read more

The title above may have you wondering what business software and jungles can possible have in common. In a strict sense, the answer is very little, but a close look at the ever-shifting IT landscape and the analogy pretty well explains itself. I’ve been working with IT infrastructure, and in particular ‘Hyperion’ infrastructure, for the past 20 years. In all of that time, I really cannot think of the IT world being less settled than it is today. We’ve had changes in the Hyperion world over the years. We’ve moved beyond simple consolidation software (those Enterprise days) to analytics (Essbase and Arbor) to multi-server and Java based technology (I’m looking at you Hyperion System 9) and then into virtualization and hosting. But all of those states of sea-change were gradual, and in many respects the EPM world was behind-the-times. What we are seeing now is a game of catch-up in EPM world, and in all of the business facing systems that feed EPM or that EPM feeds

read more