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

I was working on a data recast process which involves applying some complex mappings to the source data before it can be loaded to the target cube. This is quite a common exercise in applications related to Essbase, Planning and HFM. I used a database to hold all those mappings along with the source data. I would recommend this approach as you have full control on what mapping you are applying and you can keep track of what mapping changes you are doing since the data recast process is a repeatable process After the mappings have been applied, I had to do some manual addition of few accounts subtract data from few accounts. I am not an expert in SQL so excel pivot table to the rescue. All good and the data is ready to be loaded to the cube Tip #1: Standardization is the key Always use a standard load rule and a standard data load format for the data file (sort the columns from least to most and the dense dimension at the last and for columns). Also, use a standard delimiter...

Hi Everyone It's been a long time. Probably, 2 years and lot of things happened during this time. My wife got pregnant in 2015 and we had a lovely daughter born in December 2015. New place far away from home with no second hand to help, I had to take a complete care of my wife and daughter due to the complications she had during pregnancy This are settling down slowly and I have decided to move back to India due to health issues for my family to recover. It was a hard decision to make with lot of scope and opportunity in the Oracle EPM space that is available in US. I am trying to get pack in pace with all the latest advancement that is happening Having worked primarily on Essbase for the past 10 years, my focus is completely on Oracle Analytics Cloud which was released on 17-Mar-2017. Seasoned consultants who had an early access to OAC has posted various posts on OAC and what it has to offer. I will not post what other experts have already posted but rather collate all the...