The generic rule in Essbase is that calculations FIX on sparse members because sparse members are what define the number of blocks.  When you want to limit the members of the block on which the calculation is executed, an IF statement is appropriate. Read more

 

How many times have you been in a situation where you have to traverse through hundreds of lines and errors from an Essbase data load only to figure out that all the rejected records are caused by an issue with one member?  You load the file again and wham – another error file with issues you didn’t see the first time.

Although this is typically less of an issue in a production environment, these situations are very likely in the development and testing phases of a project.

In2Hyperion is introducing another free tool that will navigate through errors and summarize the reasons for the rejects.  Read more

 

It was a pleasure meeting a ton of new people in the industry at Kscope 2013, and being exposed to another great city.  It included 4 nights on Bourbon Street and 4 days of fantastic presentations.  Attendance was up 17% from last year!

Once again, I thank all those who presented and organized the event.  I want to extend a special thank you to all the attendees who recognized in2hyperion for its work in the Hyperion community.  Because of the number of people who offered to pay me for the In2Hyperion Excel Ribbon, I am now accepting donations. Your generosity will help fund the maintenance of the ribbon and the website. Donate Now!

Read more

 

OK, I have opened up a ticket with Oracle.  Now, they want my logs.  Frustration sets in, and I wonder…how long is it going to take to figure out where they all are and which ones are important?  If I miss one, my resolution will surely get delayed. This is all I need!

In newer versions of the Hyperion environment, Oracle has made some huge improvements. Read more

 

I attended many Hyperion Solutions conferences back in the day.  I really enjoyed the experience, but after the first couple of years, I didn’t feel like I was getting my money’s worth.  I started to wonder if I knew all there was to know about Essbase, as every presentation I attended seemed very basic.  Was I that good?  Did the benefit of attending these conferences shift from knowledge gain to networking? I decided to stop attending.  Read more