Essbase BSO Parallel Data Loads
As I continue down the path of my Essbase testing and benchmarking, I’m always looking for ways to make Essbase lay waste to hardware. As I was working on my new benchmarking application, I needed to load a lot of data into a BSO cube. I’m impatient and noticed that the data load was terribly inefficient at using the available hardware on my server. Essbase was using a single CPU thread to perform the load. So how can we make this load more intensive on the server and more importantly…faster? Essbase BSO Parallel Data Loads! I know what you’re thinking, you can’t load data to a BSO in parallel. That only works in ASO, right? Wrong! Now, admittedly the ASO functionality for parallel loads is a lot more flexible, but starting in 11.1.2.2, BSO now has a basic way to perform parallel loads. Before we get to that, let’s take a look at the SQL load that was performed. The data set is roughly 10,000,000 rows. This is the basic MaxL code used: import database EssBench.EssBench
Hyperion EPM Month in Review: January 2017
Welcome to the second installment of the Hyperion EPM Month in Review. This month was pretty busy with 44 contributions by the community (45 if you include this post). Adashek EPM Gary has a quick update letting us know that the Smart View 11.1.2.5.620 has been released. Cameron’s Blog for Essbase Hackers Cameron has a pair of posts this month. First he held Chris Rothermel hostage until he created a post that shows us how to delete multiple files with EPM Automate. Next up, he shows us around the new EPM Cloud Documentation Portal. DEV EPM The DEV EPM crew starts off 2017 with a post covering 2016. They also tell us that they will be at Kscope17! They also have an OTN article on Building a 100% Cloud Solution with Oracle Data Integrator. Eric Erikson’s Oracle HFM and FCCS Blog Eric gives us a look at the new Oracle Data Visualization Cloud Service. On the other end of the spectrum, he has a post about locking entities. This is a functional and technical question all rolled into one.
Next NTxHUG Meeting Announced for February 16th
The next North Texas Hyperion User Group (NTxHUG) meeting has been announced and it will be on Thursday, February 16th, 2017. The event will be hosted in Irving at the Oracle office. You can find more details here: NTxHUG Website We’ll be getting started at 3:00 PM then heading to a happy hour at The Ranch in Las Colinas nearby. I’ll be presenting along with someone from Oracle. This quarter we’ll be discuss on-prem Hyperion tools. This includes a road-map and then integration across the stack. The Oracle Office is located at this address: 6031 Connection Drive Irving, Texas 75039 The following happy hour will be at The Ranch at Las Colinas at this address: 857 W John Carpenter Fwy Irving, Texas 75039 At the end of the post you will find a handy map with a pair of pins: the Oracle office in question and The Ranch at Las Colinas. I hope to see all you local to DFW there! [iframe src=”https://www.google.com/maps/d/embed?mid=17ymdBBU4dbXD1PKC8MOzPH8K6Oo” width=”640″ height=”480″]
Kscope17…here I come!
I’m very pleased to announce that I will be speaking at Kscope17 in San Antonio. I will be giving a presentation on Essbase performance in virtualized environments. This will contain a lot of content that you will see here, or already have seen here. I’ve very excited that this presentation was accepted as I’ve been working for over a year to get everything ready to actually present. You can find more here. The official title of my presentation is: IT Made Me Virtualize Essbase and Performance Sucks: Making Essbase Fast In Any Environment I’ve had the pleasure of speaking at Kscope everything year since 2010. I believe that Kscope is far and away the best Hyperion-related conference in the world. I also enjoy getting together with a large number of like-minded Hyperion Nerds. This year should be an amazing experience just like every year before. This year we are back at the JW Marriott outside of San Antonio. For those of you that haven’t been to this particular resort, it is pretty amazing. It has
Hyperion EPM Month in Review: December 2016
The Hyperion EPM Week in Review has clearly become more than I can manage on a weekly basis. So, I’ve decided to do a monthly update for the time being. If things slow down, I’ll get back to a weekly update. So, welcome to 2017 and the review of Hyperion EPM in December of 2016! As part of this change I’ll also be structuring the posts a little different. Because over the course of a month many of us post more than once, I’ll be adding sub-heading for each of the contributing blogs along with a link to their main site. I welcome any feedback everyone has. Adashek EPM Garry had three posts last month. First he announced that he was selected to present at KScope17. Congrats Gary! He also lets us know about the new 11.1.2.4.704 patch for Financial Reporting. This is a particularly important update given that Oracle will no longer support the desktop client soon. While he’s updating us on patches, he also has a post about the new 11.1.2.4.210 patch for
Happy Belated New Year!
Welcome to 2017! This post is way late as I continue to recover from a ridiculously busy Q4 and the Holidays that go along with that. 2016 was my second year of blogging, and I’d like to think that it was a successful year. In 2017, I published 83 blog posts. I’m not sure that I’ll get anywhere near that number this year, but I’m hoping to make every post count. This year I hope to focus more on continuing to build out my home lab to support new and interesting things. I’d also like to spend more time with cloud technologies like FCCS and ARCS that I haven’t spent as much time blogging about so far. Here’s what I hope to post on in general: Essbase Performance (you should see a lot on this given my presentation looms) PBCS FCCS More fun with PowerShell More posts about the Lab Perhaps a guest-blog or two? I’ll finish off this post by stealing an idea from Jason and posting my top 10 blog posts from 2016: