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.


Friday, August 22, 2014

Is it really fame and fortune?

Fame and fortune and everything that goes with it, I thank you all!

I was reminded about this line from a Queen song as I returned from a speaking tour in Latin America through Oracle Technology Network and the Oracle ACE program.  I travelled to 6 countries in 15 days and may or may not blog about it later. Back to the song; I was asked a few times about how much Oracle paid me to do the tour and was I an Oracle employee. While Oracle paid for the airline and hotel, I paid for food and incidentals and no I don’t work for Oracle. In reality, with lost income and expenses, it costs me a lot to do the tour.

So why did I do it?  Is it for fame as the song says? While I found it funny that participants in other countries wanted to take pictures with me and others on the tour, I didn’t do it for notoriety. It is not fame or infamy that drives me to share my limited knowledge.  As I explained to one person, through the years working in technology, others helped me along the way. They patiently answered my questions, suggested solutions, shared their knowledge and gave me encouragement.  Like most others in the Oracle ACE Director program, I am giving back to the community that helped me. The current overused phrase is paying it forward but this fits to well in this case to use any other phrase. 

My good friend Cameron Lackpour spends too many hours doing the same, researching, giving his knowledge for free for the betterment of the community, all at a great personal loss as much of what he does is non-billable.  Why do I bring this up? I is certainly not for a pat on the back for your pity (for me or MMIP, Cameron), but to urge you to get involved in the same manner.

It sounds like a cliché, but volunteer work is an incredibly rewarding activity. In part volunteering is giving back to the community that helped you get where you are professionally (and even personally) – call it paying forward, or paying your psychic debt, or just helping others as you have been helped. But there’s a deeper aspect to volunteer work as well. Humans are imperfect moral beings, but one of our better drives is to Do Good Things. It just feels good to be good. Try it, you’ll like it.

I know what you are going to say “I don’t know as much as Cameron does or Glenn pretends to (, so I can’t help”. To this I say poppycock. Firstly you probably know more than you think you do and can help others with their questions. Secondly, even if it is true that your knowledge is limited, you can still help. Get involved with your local user group, on-line community, favorite conference, or write a blog about your experiences, trial and tribulations. If you read my blog, you are part of the Hyperion EPM community, are stalking me, or are weird. The Hyperion EPM community is a growing living entity that only gets better by sharing.  I know Cameron is looking for people to help with the ODTUG EPM community that just started up. Become involved, if not with that then with something. Pay it forward and have a personal satisfaction that you helped and I will thank you all!

 

post script. I communicated with Cameron about this post since I mention him heavily in It and got this response:

This is Cameron aka MMIP. If you are interested in getting involved with ODTUG’s EPM community, I encourage you to sign up at ODTUG’s volunteer page: http://www.odtug.com/volunteer

We have many exciting initiatives including:

· Local meetups

· Content sourcing for:

· Webinars

· ODTUG Technical Journal articles

· EPM Newsletter articles

They are starting up and need volunteers to make them happen. This is your chance to define the future of the EPM community.

To Glenn’s point, don’t be shy about contributing. When I first met Glenn at Kaleidoscope 2008, he wasn’t:

· My friend

· An Oracle ACE Director (only an ACE)

· An Oralce EPM community rock star

· A trusted advisor and voice to many

But he is today, in large part because of his endless and valuable volunteer work. I’ve done my best to emulate him and the results have been very rewarding. The same can be true for you. I look forward to talking to you on an EPM community initiative conference call and look even more forward to the great work you’ll do.

Be seeing you.

Sunday, August 3, 2014

OBIEE and Essbase a few observations

I’m sitting in a hotel room in Panama writing this post. Why you might ask. I’m in Panama as part of an Oracle Technology Network (OTN) Latin America tour. I will be going to 6 countries in 15 days.. Perhaps at the end I’ll blog in detail about it.  As I write, Edward Roske is in Brazil doing the same thing. Why am I writing this instead of out exploring? I will be later today as the local host arranged a tour for the visiting Oracle Ace Directors.

This post on OBIEE and Essbase is based on my creation of my KScope 14 presentation and quirks I noticed Note I was using Essbase 1112.3.5 and the latest patched version of OBIEE 11.1.1.7.1.X (I don’t remember the X). I was using a VM instance of the Sample Oracle supplies and was using Essbase Studio with it to create the cube. I then brought the cube back into OBIEE and also into Publisher to create a Mobile dashboard.

My initial problems came trying to install the BI Admin console on ly laptop. I run Windows 8 (not by choice) and IE 11. BI admin would not install no matter what I tried. I also had problems with Enterprise Manager and Analysis. I worked around these by using remote desktop to an environment that had lower versions but only after spending hours trying to make these applications work.

After I got things working I created a relational schema in an ORacle instance and tried to import the DLL and sample data from Essbase Studio. The tables created with no problems and created the keys and indexes as needed. When I tried to load the data, I got errors The import did not account for transforming dates into the correct format. I added cast statements to each row needing it and it worked fine, but I should not have had to do it.

Next, I brought in relational tables into OBIEE for creating my Essbase cube through Studio.  That was very easy until I started talking to Wayne Van Sluys a great OBIEE resource. He wanted me to create all sorts of logical tables and aggregations in my business mapping layer to turn my snowflake schema into a star schema and allow aggregation summaries.  If I had wanted to use the data source to do anything but feed Essbase Studio, (report from the source, do federated Essbase/relational reports) I would have had to go this work which seemed very daunting. Luckily, I only wanted to feed Essbase Studio, so it was easy. Just bring in the source, move it to the business model and presentation layers and I was done.

Next, in Essbase Studio, when I brought in the OBIEE tables, Studio did most of the work for me. In the Minischema, Studio would not let me do joins between the tables (This was defined in the relational source) but it would and needed me to set up the self join for the parent/child accounts table. It was easy-peasy (as Cameron Lackpour would say) to create the hierarchies and build the Essbase cube from this. Of course the sample tables were set up with Essbase in mind

I brought the completed cube back into the OBIEE RPD just because I could. I actually did not use it there. I just wanted to show for consistency of reporting how to do it. there were a few little quirks. I had multiple alias tables and although I only asked that the default table be used, When I got to the presentation layer all of the aliases showed up. I did remove them easily enough, but it was extra steps. Also for accounts,

I had set it up a a value dimension so I would not worry about if additional generations were added. In the presentation layer, I changed the ugly wording of “gen7,accounts” to “All Accounts” as it is more meaningful to the end users.

Working with Mobile App Designer (MAD)proved to be more of a challenge than I thought it would be based on the demos I’ve seen. It could be a distinct possibility that I don’t know enough about it, but the multiple steps were difficult. For those of you how don’t know, MAD bypasses the RPD and uses queries from BI Publisher.  My first issue was trying to create the MDX query. The Query designer gave me problem after problem. I finally bypassed it, wrote my query in EAS , tested it and pasted it into the the query editor in Publisher. I found I  had to do very simple queries as complex queries with multiple row or column members would not work in subsequent steps.

Once I had the query in place, I went into the actual query designer). It is a simple drag and drop interface and I got the basics pretty quickly. Because the input query, you are limited in what you can display. I will say I spent hours trying to get a single graph with three dimensions represented, Products, Periods and measures. I could never figure out how to do it, so I ended up with a graph for each quarter. It would have been more impressive if I did figure it out. I ended up going back to the MDX and making it simpler after trying multiple different things. Just before KScope, a new version of MAD came out, but I’ve not had a chance to see if it would have been solved my problems.

I know this is a long post without pictures, but I thought you might be interested in my ramblings about using OBIEE and Essbase for my demo. Using OBIEE against Essbase is much easier than using it against relational as I found out and I was able to complete the demo it a fairly short amount of time even if I did have issues. If you are going to go down this path, don’t travel alone, bring along a friend who knows OBIEE to help you with the obstacles along the way, you will be happier for it.