Why I created a blog

Its been many years since I first created this blog. It has remained true to Essbase and related information over those years. Hopefully it has answered questions and given you insight over those years. I will continue to provide my observations and comments on the ever changing world of EPM. Don't be surprised if the scope of the blog changes and brings in other Hyperion topics.


Tuesday, August 24, 2010

Kscope 11 Abstract submissions open and quiz answer

I got in my email today that the kaleidoscope 11 submissions are open. (they have actually been open since the conference). This is the most awesome conference and if your submission gets accepted you can go for free. The tracks for Hyperion content have been expanded and there will be a more diverse set of topics. In the past three years the presentations have all be very technical. The conference is broadening its scope and will have some case studies and more business related topics as well. This means you don’t have to be a technical guru in order to present. In fact, the conference is looking for a lot more customer (versus consultant) presentations.

If you want to look at the topic categories to choose from you can find them at: Kscope 11 Abstract page.

If you want to submit a presentation, there is a link on that page or you can go directly to Kscope Abstract submission .

The deadline for submissions is October 26, 2010 so you don’t have a lot of time. Put on your thinking caps and come up with an interesting topic. If there is something you would like to see presented at the conference but don’t feel you are the right person to present it, send me a comment and I’ll get the abstract added to the list and help to find a presenter. Or better yet find a friend, co-worker, friendly neighborhood consultant that you like and admire (no not me) and get him/her to submit it.

A few weeks ago, I put out what I thought was a pretty easy quiz. Perhaps it was too easy as I only got three responses to it. The first response was to my faithful Man in Philadelphia Cameron Lackpour who got almost all of the quiz answers correct. At least the answers I was looking for.

The first question was list two ways to display numeric zeros in SmartView retrieves. Cameron correctly answered #NumericZero and (0) (note in System 9 just entering a zero worked in some versions. I don’t know when that changed).


The first bonus question asked “How he can take non-numeric data in Excel and show it in formulas as a zero without using an "IF" statement” The answer is to use the syntax N(cell reference) like N(A3). This takes and turns the value into a numeric. Unlike Value() which Cameron described. The N() syntax turns non-numeric data into zeros so you don’t get #values in your formulaic cells. This is not a Smartview or Add-in solution, but an Excel solution. I amaze even the most prodigious Excel users with this one when I show them it.

The second bonus question asked “How can you have the classic Add-in return numeric zeros?” The answer is the same as part of the SmartView answer using the syntax (0) will bring back real zeros from the classic add-in.

Finally the last bonus question was “Why can this be a bad thing?” In the classic add-in and some versions of SmartView, numeric zeros will be sent to the database replacing your #missing with zeros. This will bloat your database, especially BSO databases and make your calculations run longer and the database consume a lot more disk space.

Thursday, August 12, 2010

Time for a quick Quiz

I finished up presenting three sessions at the DOUG semminar in Dallas on Tuesday and my voice is shot.I talk way too much.  I was amazed at how many people were there. I'll guess over 100 just to hear me talk. Well actually to hear Edward Roske, Tracy McMullen and me talk. The biggest draw was Tracy's track on OBIEE. It seems to be the hot ticket right now. In all I think it was a very good day and people got a lot out of it. I only stayed for a little of the Rangers/Yankee game that followed the session as I had a long drive back to Austin. Thank you interRel for hosting the event. (Is this a shameless plug for the company or me just being nice?)

It has ben a while since I have done one of my quizes so I thought I would give you an easy one.
Bob is a real zero in life, but he does not like missing anything.. He loves the little round orbs that are nothing. But when he tries in smartview 11 to have his missing values display as zeros he has problems. Can you tell Bob  two ways (without doing find and replace) that he can have true numeric zeros in a smartview retrieve. As added bonuses
How he can take non-numeric data in Excel and show it in formulas as a zero without using an "IF" statement
Second Bonus, How can you have the classic Add-in return numeric zeros.
Third bonus, Why can this be a bad thing?

Friday, August 6, 2010

Persenting again

This upcomming week I'll be presenting at the DOUG (Dallas Oracle User Group) meeting at the interRel office in Arlington. There will be three tacks
The Future of Reporting & Analysis , Oracle EPM 11.1.2  and Becoming an Essbase Guru

Although I am far from Guru, I will be presenting the sessions in the Essbase track.  The topics include
Configure it out. , Load rules from intermediate to Advanced. (It used to be called from Basics to advanced, but I guess my basics are more intermediate to many people) and Preparing & Optimizing for 64-Bit Essbase. All really good topics.

If you want to see all of the topics in the other tracks or the schedule, you can check it out on http://memberservices.membee.com/538/irmevents.aspx?id=19  or contact Danielle White at DOUGBIEPM@GMAIL.COM

Wednesday, July 7, 2010

Stand alone installer for 11.1.1.3 Classic add-in

Thanks to Sebatian Roux for his persistance on this. Oracle has realeased a "Service fix" for a stand alone installer for the classic add-in. It is available on Support.oracle.com. Log in, select patches and updates and type in the patch number 9147550.  (note you do have to have a valid service agreement to log in)

Here is info from the readme:

This Readme file describes the defects fixed in 11.1.1.3.11, as well as the necessary requirements and instructions for installing this release.


This service fix provides a new MSI for installing Essbase Spreadsheet Add-in separately from EPM System Installer.

Thanks again Sebatian.

Kaleidoscope summary

I am sitting on an airplane heading for home after a very busy 5 days at the conference and a few personal days braving a Washington D.C. heat wave. Not that you really care, but after the conference I took a couple of days off to view the sights of the city. My wife and I spent the 4th on the National Mall watching the fireworks behind the Washington Monument. It is a something everyone should experience.

About the conference. It was all the hype said it would be. Sunday started with the Oracle symposium where product managers gave us insight of things to be. Of course we are not allowed to blog about such things. Drats. Leave it to say that there was some interesting stuff.

On Monday the real conference began. In the opening session, it was announced that Edward Roske will be the conference chair for the upcoming year. The site of next year’s conference was announces as the Long Beach, Ca. Conference center, June 26th – 30th. So mark your calendars now. I understand if you register now, you get the lowest possible rate. Edward did say you can already submit abstracts for the conference. I don’t have connectivity now or I would blog you the site.  Another announcement at the opening session was Hyperion SIG board member and all around nice guy Cameron Lackpour was awarded the best new speaker for his presentation last year. If you have a chance, congratulate him.

I started off the conference with my session on MDX practical examples and it seemed to go well. Over 80% of the room had little to no experience with MDX so I think the presentation was at the right level. As typical I had more content than time (even for a 90 minute presentation) so I was rushed at the end. I think I will talk to Danielle White at interRel and have it added as part of the weekly interRel broadcast series. I will either have to cut it down or do it as a two part series. I think the latter would be better. Later in the day, I did Edward Roske’s presentation on ASO optimization. It was like trying to swim through jello(umm red strawberry jello with whipped cream). He had so much great content, There was no way to get through it all. In the end, I ran out of time and did not talk about a few important topics like cache settings. Luckily for people who attended the session following mine, There was a lot of overlap of content and they were able to pick up what I missed. Monday “officially” ended with a session with the Oracle Aces and a reception following. We could have been answering questions for hours, but time was limited. There was a lot of great interaction. I did not see much of the reception as I was in the interRel booth meeting people and seeing old and new friends. 

This year the conference had a room reserved for werewolf and there were games every night starting at 10:00 pm. IT worked out well. It was a full moon during the conference and the wolves came out in mass. we has multiple games going every night. Edward did not want to sleep Wed night so the game went till 4:30 am. I was lucky to make it to bed by 2 am most nights as I moderated games.

Tuesday came too early and fast. Luckily I did not have any presentations to do. I ended up doing some work for clients. I popped in and out of sessions all day long and have to say overall I was very impressed by the presenters. Most sessions had between 80 and 120 people in them  (not including the labs). I did sit through Doug Pearce and George Cooper’s presentation on a case study on how GAP (The clothing company) used a combination of BSO, ASO, Varying attributes and text measures to allow users to track the uplift of promotions. (I hope I got that all correct). It was a very interesting session.  I have worked with Both Doug and George in former lives and it was fun and interesting to watch their interaction.  The presentation had good technical content on how they overcame problems, but I would have liked to have seen a bit more talked about on what text lists and Varying attributes are (I did mention this to Doug later).

Tuesday night was the interRel client event so I was busy. We had three (or four) Werewolf games going at once in a kill all competition. The winners of each game played in a final game for great prizes (don’t ask me what I have no clue).

Wednesday was a busy day. I did a presentation on Advanced Essbase Studio tips and tricks. There was a Essbase Studio Basics session going on a few doors down, but over three fourths of my room had no to little experience with the product. I afraid some of my presentation was over their heads. The information was good and when they start using Studio, it will help them but until then I’m sure I confused more than a few people. 

I was the Ambassador for Cameron Lackpour and Markus Shipley’s (forgive me is I spelled names wrong) intro to ODI session. At Kaleidoscope, every session has an ambassador to introduce the speakers, record attendance and overall be a go-for, in case of problems. It was a 90 minute presentation and they needed every minute of it to get the information across. Cameron went into detail  on what you have to do to create an integration and then Marcus gave a real world example of how his company implemented it, solving multiple problems. They went from days, literally days, of work to get data loaded into Essbase into multi-minute long automations. It was amazing to hear how much his users love the results of the project.

I later sat in on Edward Roske’s Hacking Essbase session. The room was packed with standing room only. Edward is a great and knowledgeable speaker. He could have spent a day just with this one session and answering the crowd’s questions. He promised a mush longer session next year.

Wednesday night was the Kaleidoscope event where John Heffron (the winner of last comic standing) entertained us all. I had never seen him before. I was laughing so hard, I had tears in my eyes. If you have not seen him, I highly recommend searching him out and listening to his work. Than k you interRel for co sponsoring the event so the conference could afford him. The other entertainment that night was a band that I was not impressed with. I' will not tell you their name as for me it was not worth remembering.

Oh one special note about the event. The volunteer of the year award was given out. This year it was not to a single person, but to the entire Hyperion SIG board for the amount of work they put in to make the week a success. Thank you Gary Crisci, Angelia Wilcox, Natalie Delemar, Cameron Lackpour, Doug Bliss Quinlann Eddy, Tim Tow, Jeff McAhren and Edward Roske. The executive board could not have made a better choice. (see my note below about board elections held)

At 4:43 am on Thursday, I got a text telling me, I was doing Edward’s 8:30 session on BSO and ASO internals. So I was bright eyed and not so bushy tailed very early in the morning to give it. I was really amazed that on Thursday so early, the room had a good number of participants. I guess they had not heard that Tracy or Edward was not presenting, but I was. As typical I talk too much and ran over a few minutes, but most people did not mind and I think there was a lot of good content. I got a small break then presented my load rules basics to advanced. Lots of good questions, but to a much smaller group. The conference was winding down. 

Overall I think the conference was a great success. I heard multiple time from participants “That tip paid for the whole conference” during various sessions. While this year I did not get much time to see other sessions as I would have liked, The feedback I got from others was that the conference was outstanding.

On a personal note, I was re-elected to the Hyperion SIG board along with Joe Aultman (Autotrader), Brian Suter (Dell) and Alice Lawrence(LSGSKY Chefs) so if you have any suggestions for next year’s conference or have an abstract to present or something you would like the board to do, please let me know.

Wednesday, June 30, 2010

Kaleidoscope

I’m sorry. I said I would be blogging about the conference each day to keep those of you how could not make it informed about what was going on. Frankly I’ve been so busy that I have not had the time to do it. Monday started with a genera session. During the session a couple of things were revealed. First, The location for the next Kaleidoscope. It will start June 26th in Long Beach Ca. Second, A new conference chair was announced. It is Edward Roske.  The Keynote speaker was Lee Rainie from the Pew Research Center’s Internet and American Life project. I won’t go into the presentation itself, you can look at their web site to see statistics, but it was interesting as he showed a lot of technical trending.

I had the opening technical session of the conference with a session on MDX practical examples. While I think (hope) the presentation went well, I had so many good questions, I got off track at times and had to rush through the last part.

I ended up taking over one of Edward Roske’s presentations on ASO optimization so I spent an hour or so going over it the had lunch. The food was good,but crowded and a bit unorganized. First impression, not quite as good as last year. 

Since I’m on so little sleep, I’ll apologize for not saying more, I’ll TRY to do a recap of what I saw after the conference is over. 

Monday, June 28, 2010

Kaleidoscope Day 1

Welcome to Kaleidoscope 2010. I’ll try to blog about what is going on here for those of you who could not attend. It may be limited as I’ll be pretty busy. I’ve picked up a few more presentations and I have a lot of commitments during the week. This is Sunday, Day 1. I arrived yesterday with little problem. Taking the Metro to the hotel was easy if not crowded. I got my room at the Marriott. It is bigger than a small country(I think thanks to the number of nights I spend with them).

I’m sitting in the Sunday symposium hosted by oracle. There are about 150 people in the room. I have to say, I will not be saying much if anything about it. We have been cautioned we are not allowed to say anything about what is talked about today (aside from saying Edward’s shirt says he is a tasty villager). The whole day is on Oracle products and future and will be an interesting day.

Tomorrow (Monday) I have two presentations. MDX practical examples and ASO optimization (which I picked up at the last minutes). It will be a long night