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

Finally the Oracle EPM 11.1.2.4 is released!!! I wish it was but it's just the Beta that got released and  they are made available at  Here They are not yet available in edelivery and the document is also not available yet. They should be available in couple of days. Wait for it to be available in eDelivery I though this time atleast I will be the first one to post but Celvin have already blogged Here followed by John Goodwin about the installation and configuration (Beta version)  Here I am late in the game :( Nevertheless I will wait for the eDelivery version :)

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