Analytics outside of my work

My first encounter with Essbase started in 2007 when I started my career and never looked back. I loved working in essbase and how different it was compared to other databases. it wasn't that difficult for me to make a switch-over with the knowledge of relation Db's as I was a very quick learner.

It's not just Essbase that I love but I am in love with data and anything that is related to data and analytics. As part of my work, I work on Essbase applications and outside of my work, I tend to analyze data that is available public and try to analyze the data. This isn't that easy as the data that is available is not complete. that's what I love. I love to fill the gaps / identify where the gaps are and come up with solutions.

If the data is not available, I just scrape the data from websites / social networks and look at what people are talking about

Sounds good till now but what tools / programming languages I use?

I use R mainly for analyzing the data as I felt comfortable and relatively simple

I do use Python if there is something which I don't find in R. Mostly, I have used Python where huge amount of data is involved and R tends to give me problems as my system is not that highly configured

I have been busy working on something of my interest to be applied on what I am working on. I will be able to post it soon in couple of days / in a month

Comments

PBCS/EPBCS - ASO exclude shared & Dynamic

As you all are aware that Oracle releases patches to EPM cloud every month (EDMCS is released every 2 months) and the patches are applied on first-week of Friday in Dev and third-week of Friday in Prod I did a post long back about a challenge that I have faced in on-premise and how I have addressed that. New functions were released in Nov-2018 release of PBCS. Below is an excerpt from the readiness document. You can find the document here New Aggregate Storage Functions in Calculation Manager The following Aggregate Storage functions have been added to Calculation Manager. These functions filter the shared and dynamic members from the Point of View (POV). The functions can be used in the POV of an Aggregate Storage custom calculation or allocation. @FilterDynamic(Dimension Name, Member Name) removes all dynamic members from the list of members @FilterShared(Dimension Name, Member Name) removes all shared members from the list of members @FilterSharedAndDynamic(Dimensio

EPM Cloud Tips & Tricks - #1

The first EPM cloud product was released in 2014 and it's been six years till date. I was recently part of an FCCS implementation project. I know what you might be thinking. Coming from completely essbase and planning background and been working on it for almost 12 years and doing an FCCS project? Well, it turned out that way and it was a change for me too than being in my comfort zone and took it as a challenge. I have been very busy for over the past one year and I didn't really had a chance or time to get back to my blogging and sharing my knowledge. The project finally went live and I am going to share my bit of learnings. Some of it you might alread know The first tip is going to be an easy one and those who have worked in FDMEE / Data Management in the cloud, you might already know it. But, this is very important when it comes to FCCS as zeroes are valid from Balance Sheet standpoint Data Management by default doesn't load zeroes. Below is a excerpt from the document

EPM Cloud (PBCS/EPBCS/FCCS) - Report Bursting & Reports scheduling

The first product of Oracle EPM cloud was launched in 2014 and it's been 5 years and over the course of these 5 years, Oracle has every EPM product in cloud to what is available in on-premise. With so many products under the EPM belt each with its own functionality, there is a real need to have a single unified reporting tool that can handle all your reporting requirements across all your EPM products at one place. EPRCS (Enterprise Performance Reporting Cloud Service) is the Oracle direction to address all the reporting needs for any organization of any size. If your team is responsible for the management, narrative and external reporting with the ability to author, collaborate and a solid approval process, you definitely have to consider implementing EPRCS at your organization EPRCS can connect to your EPM Cloud products, Essbase cloud and also to your Fusion Applications Essbase app. It addresses all your financial, management, narrative and disclosure reporting. I am not goi

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

Search This Blog