Lakshmi Venkatachalam

Lakshmi Venkatachalam is a Solutions Architect with Oracle CPM team of Perficient.

Connect with Lakshmi

Blogs from this Author

IBM Cloud Pak for Data

OCI Essbase application – Editing outline – Browser issues

Recently when I was working on a migration project, I noticed that the Essbase on OCI has differences when it comes to editing the outline and update metadata. On IE 11: When opened, the outline won’t show members to edit, as seen in the screenshot below. On Chrome: When open, the outline usually works to […]

Claims Process

CopySnapshotFromInstance – EPMAutomate Command

There are a few things I would like to add to clarify the usage of the CopySnapshotFromInstance command.  As the documented definition goes, it mentions as a current snapshot in one place but an existing snapshot in another. I would like to confirm that it works on both current and existing snapshots.   CopySnapshotFromInstance is […]

Unable to Obtain a Connection to Hyperion Essbase

When refreshing an ad-hoc SmartView sheet against EPBCS application, you get an error saying “Unable to obtain a connection to Hyperion Essbase. If this problem persists, please contact your administrator.” Error attached here with – If you are here in this blog at this moment reading for a solution, you are one of the lucky […]

Woman Using Laptop Computer

My Approvals unit is not recognizing the year – How can I validate data in FCCS?

If you are getting Failed: Invalid data when you try to lock your period through Approvals, it is time for you to review your Validation form’s variables. Issue: In FCCS – When you are ready to validate and lock the period using the Approvals Menu – you will notice that the validation doesn’t go through […]

Drug Induced Liver Injury

Summary from Improve Consolidation Performance – KSCOPE19 Session

I attended a very good session on June 25, 2019, by Kari Hassebrock of C.H. Robinson & Coen de Steur of KPMG that explained how the team experienced performance issues with respect to consolidation / translation in FCCS and the various options they applied to tackle it. After attending this session, I could get myself […]

3 things I want to explore more on Groovy with EPBCS API-KSCOPE19

Kscope19, ODTUG’s user conference known for providing a rich opportunity for networking and education on Oracle technologies, is taking place this week in Seattle! I was fortunate enough to attend the session”Getting Started with Groovy for the Non-Technical Superstars” with presenter Kyle Goodfriend, Vice President of Oracle Practice – Accelytics who introduced how to get […]

OneStream – My High-Level Perspective

I recently got my hands on OneStream software. I can definitely say that OneStream is in vogue, especially working through many other products since the Essbase- Hyperion System 9 days, surviving the changes from Enterprise -> FDM -> FDQM -> FDMEE / Data Management, navigating through to see Planning/ HFM on cloud taking multiple forms […]

Having Trouble with Enable Sandboxes Option in PBCS Application?

Yes, it is a nuance while creating application in PBCS. Here is what you need to know about it: If you are creating a new application, you may choose the obvious solution (like me) of clicking ‘Create Application’ from Planning and Budgeting Service. Beware! When you choose to create application from above menu– You cannot ‘Enable […]

Customized Integration solution: Using JAVA API from HFM to HFM

What is that? It is a Java based program, and is used to push data from one HFM application to another HFM application. When will I need it? – Have a need to push data from one HFM application to consolidated application. – Don’t want to create a new automated solution from scratch to solve […]


Many of us may have used SET DATAEXPORTOPTIONS. But I noticed that there are some glitches in that command usage that is not documented explicitly. It can cause a “LOT” of trouble with respect to performance. I spent few hours on this and thought will share it with you all to save some time. However, […]

Where is this Hyperion product located in the Oracle stack?

Where is this Hyperion product located in the Oracle stack? Though it had been years now since the Oracle Hyperion acquisition, it is very hard for me to keep up and understand the oracle stack with respect to Hyperion.  Yes I admit I  have a very poor memory; I revisit Oracle websites many times to […]

Essbase calculations sign off made very easy NOW!

In many Hyperion Essbase projects, getting user acceptance testing complete on time for all the Essbase calculations is an onerous task. It becomes even more complicated while metadata sign off is still on its way for perfection. This is often because the end users are so used to sign off after looking at the reports as a […]