Skip to main content

Posts

Showing posts from 2015

Planning (BSO) to Reporting(ASO) Replicated Partition Issue (Not really an issue) - Solution

There was an issue reported from user that a small sheet with 15 rows and 6 columns from reporting cube (ASO) is taking around 6 minutes to retrieve and getting timed-out We tried from our end couple of times and identified that it was sporadic and tried all possible options to fix it. Sometimes, it retrieves very quickly and sometimes it takes a huge amount of time. Option 1: Outline size was around 200MB and we compacted the outline which brought down the outline size to 22 MB. But, this didn't work Option 2: We cleared aggregations (We were very sure that this will not improve performance). It didn't work Option 3: We have a database where we capture all our metadata and data loads with start time, end time and elapsed time. We noted down the times when the retrievals were faster and looked in to the database to find what process were run before the retrievals. We found that whenever a dimension build process is completed, the retrievals are faster but after that

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 a

ASO Report Optimization - Short Tip

Another short post on ASO Report Script Learning I was working on a project where we have an ASO cube and we had to extract the data from ASO cube to a different team. There were multiple requirements, where they wanted level0 of few dimensions and summary level of other dimensions I used an existing report script that was in a BSO cube and then updated the dimensions accordingly and to my surprise, the script ran for around 2 hours to generate around 20MB file I have written report scripts earlier and never did the script ran so long. It took a while for me and figured out that I was using LEV and when replaced with LEAVES, the report script ran for 40 seconds I expanded the scope of my report script and was able to generate 400MB file in 4 minutes Always use LEAVES if you need Level0 members of a dimension in ASO cube Happy Learning!!!

Oracle EPM 11.1.2.4 Released

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 :)