Analytics | Oracle EPM | Advanced Analytics | Many More...

Yes. You have read it right and I am talking right. There is a saying that if you understand a process end-to-end you open lot of possibilities for improvement / betterment and it suits perfect in this case As the title goes, we all have started our career in Essbase (atleast in my case) and moved to to different other tools. We might have received multiple requests / written different types of calculation scripts where we have to copy a subset of data from one combination to other combination. The real problem comes when a user who is well-versed with Essbase and even knows the technical stuff better comes with a requirement which blows your mind and you had to think / try every single possibility to convince him that this is not possible. The same thing happened with me Background We use planning application for Planning sessions, Yearly Budget and monthly forecast and initially the monthly forecasting in Excel (where they have numbers as well as text) and after moving to Ora

It's been a long time that I haven't posted any posts and there are lot of posts that are pending I have recently moved to US 4 months back and settling down over here. Working on few career commitments towards Oracle EPM and I hope to keep continue with the blogging again

Oracle Product Management have released the  Statement of Direction for Hyperion Performance Scorecard  (HPS). This document is available to download from My Oracle Support (MOS) Knowledge Article: Hyperion Performance Scorecard Statement of Direction -    Doc ID 1901891.1 11.1.2 is the final release version for Hyperion Performance Scorecard. If you have "Hyperion Performance Scorecard" implemented at your place, You might have to go through the document for the Oracle strategy From the document, It is evident that Oracle future's direction is towards " Oracle Scorecard and Strategy Management " which has a very tight integration with OBIEE Below is an excert from the SOD regarding the support policies Note: You need to have a support ID to login to the support portal to access the document.

If you are working on a project or in support, there are changes when you do not have the metadata in the system and you try to load data and you get lot of data rejects.       You then try to rebuild those members and then try to load the error file again and you get some more rejects. You might be wondering why not all the errors gets updated to the log file? Is there any limit to the number of errors that are written to the file? Yes. There is a limit both for DataLoad & DimBuild which can be defined in essbase.cfg file and the limit is different for "Dimension Build" and "Data Load" If you have checked the Technical Reference, you will see three configuration settings Taken from Dbag NOMSGLOGGINGONDATAERRORLIMIT Prevents data load or dimension build errors from being written to the application log after the limit described by the value of DATAERRORLIMIT is reached. Syntax NOMSGLOGGINGONDATAERRORLIMIT TRUE | FALSE The default value is FALSE

I was busy with some related work on Hyperion and couldn't get enough time to write a post.  Last Friday was a day that will be remembered. I have passed the "Oracle Exalytics Implementation certification". Link to the certification page ( Here ). I feel proud to move ahead with this certification and even proud to be the first one in my company to have this certification. Moving ahead, would like to gain more knowledge and would like to explore more opportunities Feel free to post your queries and any topic which you would like me to talk about

     It's been around 8 years that I have started working on Essbase and from then there has always been a need to a functionality / custom tools which are not available with Essbase and have to either build one. In current world, there are lot of consultants who have built their own custom tools and few of them have made them available to public. When Oracle has made Oracle EPM set of tools available on  eDelivery  site, it has opened up the opportunities to lot of people who has started working on Essbase. This post is about for all those who might have thought that " I wish I had a tool that can accomplish this ". This post is about a collection of such tools that are available open to the public.  I would divide this in to multiple posts. In Part I, We will talk about Log Utilities Log Utilities Essbase Log Reconciler Logs are always the entry point to check for any issues / calculation but Essbase logs has always been difficult to decipher to se

Oracle has announced the public availability of "Planning and Budgeting on the cloud" known as "Planning and Budgeting Cloud Service" (PCBS). You can find the press release :  Hyperion Planning and Budgeting on Oracle Cloud Service ( Link ) It is offered at $120/user with a minimum of 10 users. Not bad for small and mid-size organizations with little user base ----------------------------Excert Taken from EMEA Partner BI EPM Blog------------------------------------------------- You can also  JOIN THE WEBCAST  for a  Partner Deep-Dive  on  Planning and Budgeting Cloud Service .This live 120 minutes technical and functional deep-dive into the upcoming PBCS offering webcast will be on Wednesday February 26, 2014 at 09:00 UK / 10:00 CET. Oracle Hyperion EPM experts will not be disappointed, but novices are welcome. We assume you are already familiar with the Hyperion Planning & Budgeting Application, and need to know how the Cloud SaaS approach effects ho

Quite a few patch updates from Oracle related to Oracle EPM Suite. You can find more about this on Support blog at " December EPM "Patch Set Updates" released (updated) ".  You need to have a support ID to actually download the patches. Would recommend you to update these patches to avoid any issues that you might face. We had an issue recently and the Essbase Database (we are on 11.1.2.2) was corrupted and we had to restore it from Backup. We have not seen that issue before and we went through the patch readme document and we are in the process of applying that patch to our system. Hope this information helps.