Want to know The Truth About CPM?
Showing posts with label Support. Show all posts
Showing posts with label Support. Show all posts

12 May 2014

Might I learn something from Oracle Support?

Might I learn something?

I might and there’s a strong possibility you might as well.  Read on and find out about a new initiative that Oracle Support are running to help you get the most out of, well, Oracle Support.  I cannot see how you would not want to do this unless of course you find nearly endless searching through what is a huge website whilst your boss/clients/peers are beating on your head with, “Did you figure it out yet?  Do we need to file a SR?  Did you figure it out yet?  Did you?  Did you?  Did I mention that it’s really important that you figure this out?  Right now would be a good time to do so.” to be oh so enjoyable.  No, probably not.

What oh what oh what is this all about

If you are an Oracle customer, or an Oracle partner of Gold level or above, you have the ability to browse Oracle’s Support site, download patches, log Service Requests (SRs) if you are a partner  of Platinum or higher (customers can always do this so long as their maintenance is current), and download patches as well.  

There are many resources out there on the web:  blogs, message boards, Twitter and they are all (well most – I don’t get the blogs that are copy and paste regurgitations of the documentation; I also understand although I do not approve of sites that simply take Support KB articles and replicate them) pretty good.  But nothing trumps the breadth and depth of Oracle Support.  I like to think of this as the difference between paid troubleshooting, workaround finding, and general knowledge dissemination and those who do it for free, like yr. obdnt. srvnt and many others.  I don’t think one replaces the other (okay, except for those illegal sites – and no, I am not going to link to one as they are depressingly easy to find), they are instead complementary.  A blog like this one might cover a function or feature in one of the many EPM tools; Support will tell you how to fix one of those systems and even help you prevent problems.  I can only do the latter if you hire me and maybe not even then.

As I alluded to in the introductory paragraph of this post, Oracle Support is big.  Big in terms of content by product, big in terms of products, big in terms of sheer size.  Like I wrote, just big.  And with size comes confusion as one must filter out all of the other products that Oracle sells.  I seem to remember Thomas Kurian mentioning at an ACE Director briefing (note to all -- this is as close as I come to the Oracle power structure) that there are over 2,000 products with the Oracle brand and Oracle Support covers them all.

To reduce this potential confusion Oracle Support have launched all manner of education in how to use Oracle Support.  The latest initiative is an Oracle Support accreditation exam.  Italia Norwodworska of Oracle support sent me an email suggesting that I might like to check it out.  As I am one of those who is often confounded by the Support website, this sounded like a really good opportunity to learn more about a site I don’t often use, but when I do use it, I really need to use it as efficiently and effectively as possible.  Remember those quotes in the introduction?  Those were real life examples.  Ah, stress, how I don’t enjoy you.

What does it look like?

The Level 2 Accrediation for Business Analytics (I seem to have skipped level 1 but as always I do not let a lack of proper technical preparation slow me down) exam is a series of videos that explain how Support works and how to best use it.  Going through every one of the videos is recommended unless you really do know it all.  For the most part I just listened to it and jumped back to the videos when something I really didn’t understand was discussed.  The nice thing about videos like this is that you can play them as many times as needed till you grok the subject.

In case it is not obvious, you watch (or half-watch and listen) each of the subject areas and then take the test at the end.
This being the age of social media (and inexpensive animation) you will get pictures like the below to help drive a concept home:
Hmm, she reminds me of a grade school teacher telling me, “Cameron, you are a moderately bright boy, but you do not pay attention.”  True, that, even today.  But I did try to pay attention and as you’ll see from my not totally stellar score, I did manage to mostly pay attention.  The school-like aspect of this exam will become obvious later.

I’d like you to meet Joe

Joe is a stock photo and considerably better dressed than any Essbase admin I have ever met.  And I say this as someone who is just rolling off of an Essbase admin gig (don’t ask and I am officially the World’s Worst Essbase Admin as I kept on proposing new and hopefully better practices instead of just doing my job).  Here he is – I think his eyes follow me wherever I go in a room.  Creepy.  OTOH, Joe has what looks like a wicked cool 17” laptop so maybe he isn’t all bad.  At the same time, he never seems to move.  As I wrote, creepy.
All kidding aside, you will get to meet Joe at the beginning of every video and then Stalker Joe (as I have named him) goes away.  He’s just a bridging device and really isn’t so bad.  Having had a good look at those of us in the EPM community (and I most definitely include myself in this category), perhaps it is best that Oracle used a model.

The heart of the matter

Snarky (and really, unworthy) comments by yr. obdnt. srvnt. aside, this exam is quite valuable.  Dave Farnsworth, former EPM consultant (sadly now retired) once told me about buying books on one’s own nickel:  “If I get one new idea out of a book, just one, it’s paid for itself.”  I managed to learn at least four new things from this exam.  Did I mention it was free?  Quite the deal.

Things I should have known, but didn’t, and now do

What is a PowerView?

It’s the way you filter products within Oracle Support so you don’t get KB articles on how to get that bucket of prop wash for the IBM Series 360 (I am making this up in case it isn’t obvious) but instead just focus on the products you want to use.  It’ll be available the next time you log into Support.  I always wondered/was too lazy to figure that out, but I should have.

Terminology, vocabulary, and definitions

What’s the difference between a Patch Set, a Patch Set Update, and a Patch Set Exception?  Damfino.  Actually, now I do.

Patch Set

Patch Set Update

Patch Set Exception

Just to recap:
  • Patch Set = Large number of merged patches, are cumulative bug fixes, and change the release number.  Remember all of the posts on 11.1.2.3.500?  That was all about a patch set.
  • Patch Set Update = Low risk, cumulative patches, designed to be applied on a regular basis without forcing product recertification.
  • Patch Set Exception = Single fix for a single problem, applied via Opatch, handed out to customers with lots of pain.

I must shamefacedly admit that I have had no idea what these have precisely meant since, oh, 2007 and Oracle’s acquisition.  There’s lots of good information like this in the videos.

Art following reality

Here is a generic boss woman (sensible heels, suit, short hair) dealing rather adroitly with the geek in glasses.  Hmm, lose the blue eyes and the tie and it could be me, right down to the Rocky from South Philly at the Art Museum looking down the Ben Franklin Parkway towards City Hall pose.  Yeah, I come from Philly.
Let’s see if we can read some other truths into this screen shot:
  • Jolene (for I have named her such) has way better fashion sense than the geek.  This is damning with faint praise, but still it is worth noting.
  • She will be his boss in six months if she isn’t already.
  • Jolene secretly hates Cameron the geek and likely for good reason as she can run technical circles round him.  Also, she doesn’t think she’s Rocky Balboa.   Cameron shouldn’t either.  Look at that physique – he’s fooling himself.  The physical similarities (right down to the big head and glasses) are perhaps a bit too close for comfort for this writer.

Some fairly obvious advice that is surprisingly often not followed

I can think of many times where servers, usernames, and even passwords get posted to public forums.  Don’t Be That Guy.
Seriously, the above is really good advice.  Heed it or rue the day you posted confidential information for world+dog to see.

Teacher is going to ring my bell    

Class cutup, clown, or idiot? Only the exam can tell the tale.

Clicking on the Take The Exam link moves you to an Oracle University exam.  Gulp.
It’s a 30 question multiple choice exam – shades of school all right.  Most, but not everything, on the exam is in the videos (there is an assumption that you actually use the tools) and it took me about five minutes to go through the test.  You can review questions at any time and all in all it’s an effective interface.

Read ‘em and weep

I did actually take the videos seriously although perhaps not seriously enough:

A passing score, but will it get me into the university of my choice?  There’s that report card again with “Must try harder” in the margin.

What have I learnt from all this?

A couple of key things:
  1. The videos are quite good with information that I should have known but did not.  Sad but there it is.
  2. Even if I got a fair-to-middling score, I learnt new things, cf. the above comment.  This is all that really matters.
  3. It is pretty painless to watch these videos and take the test – I reckon you will need just under 40 minutes if you do it all at once.
  4. Sit up straight, no slouching, and pay attention!  Sorry, that was just a PTSD school moment – Oracle are actually quite friendly.  They want you to succeed as it’s better for all concerned.

I really applaud Oracle for coming up with this – it’s straightforward, entertaining (I wouldn’t have written all of those mildly funny comments if I didn’t enjoy it), and informative.  Take the test and I’ll bet that you too will learn from it.

The proof of the pudding is in the eating

Oh sure you say (you do say this, don’t you?), Cameron is merely shilling for his corporate masters.  Au contraire.  I dream of the massive amounts of dosh, cash, moola, bread, cabbage, simoleons, and spondulix that the various companies I write about send me.  In my dreams alas and alack, because it is actually the other way round.  Also, I have no corporate master.

What I mean by that is that I just stumped for a lovely, shiny, good-for-365-days Gold Partner agreement.  That’s $3,000 + tax of my not-terribly-big company’s money.  Why?  Gold Partners can access Oracle Support.

Yet another example of why being an independent ain’t all beer and skittles but Oracle Support is worth it and my money is where my mouth is.

Be seeing you.

21 March 2013

Where in the world is Cameron, day 5, Australasian edition

Not the beginning of the end, but perhaps the end of the beginning

I’m not one to quibble with WSRC, but the ODTUG SP Australia conference is at day two of two and that means that I am finally coming to the end of Cameron’s Most Excellent Australasian Conference Adventure. It figures that my body is finally sort of, kind of, used to the time zone difference because I will be jetting away tomorrow. It took me a week to get used to the time here and I expect another week of sleepiness when I get home to the States. OTOH, I have lots of real Cadbury chocolate (see yesterday’s rant on the stupidity of US chocolate manufacturing practices – Something Must Be Done), I have really had a great time here, and learnt quite a bit about BI and EPM.

But none of the above really matters – what does matter is: did the conference attendees get value for money? Given the depth and breadth of the sessions, the passion that the presenters brought to their sessions, and the high technical level of the presentations (despite protestations to the contrary re “being technical”), I’d argue that yes, the attendees got their money’s worth, and more.

I was a little apprehensive about helping select sessions (read: beg Oracle Australia, James & Monroe, M-Power, Bambi Price, and just about anyone I knew in Australia to help put together the speaker list – oh dear, I am now on the hook for repaying favors but it is all worthwhile) as the Australian market differs somewhat from the US of A’s. Yes, the market details are different, but at the end of the day we are all trying to solve the same problems with Oracle’s BI and EPM tools. The attendee survey will tell the tale (how could a BI/EPM conference not try to wrap metrics around an event?), but based on conversations I’ve had, I think it will be a solid win.

Taking OBIEE to the Next Level, Maneesh Disawal, 9:00 am to 10 am, ACDT

Maneesh is taking us through a definitely-not-standard approach to making OBIEE more useful. It’s nice to know that hacks aren’t just an EPM-only approach. And besides, a good hack isn’t a hack at all, but instead is Just Really Cool.

It’s interesting to see how much OBIEE overlaps with EPM – yes, yes, I get it, Oracle are bringing the two together, but still, it’s interesting to actually observe it. Most ODTUG conferences have me running round like a chicken with its head cut off. I am really enjoying actually being able to sit back and listen.

Another thing I am noticing about OBIEE is how IT-oriented it is. This isn’t a bad thing but it is evidence (if it were needed) that there is still quite the gap between the BI and EPM worlds. Their eventual merger will be interesting to watch.

Essbase ASO – A Brave New World in Australia but not for the Rest of the World, Steve Hitchman, 10:15 am to 11:15 am, ACDT

This session hasn’t occurred yet, but it’s up next. m-power worked with my buddy Dan Pressman and utilized his Rules of ASO Essbase. I’m very excited to see what they have on offer. Update – The session is in progress right now.

Oh, this is embarrassing, but kind of awesome at the same time. Dan Pressman, ASO wizard extraordinaire, just had a slide devoted to him and His Really Big Brain. What else was part of the slide? Why an advertisement for Developing Essbase Applications. Yes, it is a good book, and internationally loved.

Steve is going through the ASO design principles Dan has tried to hammer into my head:

  • No formulas, unless you must
  • Stored instead of dynamic hierarchies, or at least Multiple hierarchies enabled
  • No more + and - operators, instead just + and flip the data signs to get round the dynamic hierarchy
  • Gary Crisci’s MDX chapter in Developing Essbase Applications just got mentioned as well as a resource (Are Gary and Dan soon to become Australian citizens? Could be.)
  • Do the simple stuff in MDX, do the complex logic in BSO and import results into ASO
  • Alternate YTD hierarchies to come up with YTD values through ASO’s aggregation capabilities
  • Solve order to handle variances

Oracle BI and Oracle Essbase: Today and Tomorrow, Stephane Roman, 11:30 am to 12:30 pm, ACDT

Stephane is taking us all on a journey through Essbase and OBIEE integration in the next release of the OBIEE stack. They are To Become One.

Stephane is reviewing Sample.Basic aka My Very Favorite Essbase Database In The Whole Wide World (MVFEDITWWW). It’s nice to know that The Beverage Company’s business continues forward. Who wants to bet that when Sample.Basic was created that a bunch of Arbor Software developers sat round and said, “Eh, a good first effort, but we have to replace that with something better, but soon.” Soon never came.

Watching Stephane’s presentation, I realize that I have a career decision to make – am I going to jump on the OBIEE bandwagon to get a leg up on the tool or just passively wait for the Bus Named OBIEE to run me over. Maybe getting flattened will be pleasurable? Probably not. So much to do, so little time.

One thing that is funny about OBIEE (and why I personally think things aren’t quite there yet wrt product convergence) – it takes an Essbase database in all of its Essbase awesomeness and turns it into a logical star schema. That is…odd looking. I realize this is how OBIEE federates data but it is still a little jarring for an Essbase developer to see.

Slay the Evil of Bad Data in Essbase with ODI, Cameron Lackpour, 1:30 pm to 2:30 ACDT

This is the same presentation I gave at NZOUG 2013 and I always enjoy a chance to spread the ODI gospel. My solution doesn’t exactly use standard ODI functionality but one of the great things about ODI is that, to quote one of the attendees at ODTUG SP Australia likes to say, “There’s always a way round a problem”. ODI is great at enabling those ways around issues. I am a super fan of the tool.

Growing with Business Analytics - Keeping Updated and Informed, Paul Anderson, 2:45 pm to 3:45 pm ACDT

I finally get to meet Paul – I’ve seen his posts on the Business Analytics – Proactive Support web site.

Oracle Support are doing great things with making the support of the not-exactly-simple EPM tools. They are trying to preempt problems before they occur. One might argue that they are trying to put themselves out of business. I think that isn’t likely to happen any time soon but it is beyond great to know that Oracle understands the importance of fixing problems asap and maybe even preventing the issues before they even occur.

Master Notes, feedback, Advisor Webcasts, patches, product certification, social media/My Oracle Support Communities (hint, use this in lieu of Service Requests when your problem doesn’t involve fully-engulfed-in-flames Essbase servers), product version certifications, patch communities, product specific communities (HFCM and Endeca), Remote Diagnostic Agent (RDA), whew, you get the idea. Oracle Support are doing a lot of interesting things.

Closing Panel, Richard Philipson and Cameron Lackpour, 3:45 pm to 4:30 pm

This is an anything-goes, hit us with your best shot session. They are a lot of fun at Kscope and I am hoping that this will be more of the same. However some topics like do you like wheat or white toast are beyond the pale. Okay, I kid, I kid, wheat every time. Rye vs. wheat will have to remain a secret. Everything else is fair game. :)

Keep tuned

Almost done – I will put in my final thoughts when the party’s over.

Be seeing you.

04 February 2013

Patching 11.1.2.x the wizard way

Introduction

Yes, the thought of me writing much of anything on infrastructure is slightly (completely?) laughable given my fully documented and freely admitted serial incompetence in this area.  However, not everyone has the luxury of saying, “Damn it, Jim, I’m an application consultant, not an infrastructure geek” and truth be told I get pulled into these situations, at least tangentially, from time to time.  And of course because I’m in a roll-your-own one man consulting band, I have to occasionally patch my development system as well.

You are likely not in that spot (once upon a time the EPM market was full of we hardy independent souls – we now seem to be a vanishing breed of which only the fittest/most stubborn remain but I digress) and need to do the patching, or at least manage, or maybe just have an appreciation for what is entailed in the process of patching and maintaining your company’s not-architected-for-scaredy-cats EPM system.

If this is a task that strikes fear into your heart (actually, if it doesn’t strike fear into your heart, you’re not paying nearly enough attention) then you are in luck for Oracle Support (thanks, T.) have pulled out all the stops and have produced their very own Patching & Maintenance Advisor: Enterprise Performance Management (EPM) 11.1.2.x(1517258.1).

What’s it all about, Cameron?

It is a wizard-based (you wondered about the title of this post, I’ll reckon) approach to:
  1. Why you should patch (this isn’t too hard to fathom)
  2. How you patch (ah, the details, where Old Scratch lives)

The goal is to get you to carefully consider the potential  impact, possible considerations, and concrete actions you need to take, step by step, from a 11.1.2.NotEverPatchedNoWayNoHow release to the very latest version of 11.1.2.WowEvenOracleDoesn’tKnowAboutAllOfThesePatches.

My story of woe, agony, and defeat, that you can now avoid

I wish this had existed, oh, about two years ago when I was on my very first 11.1.2.0 Planning implementation.  The installing consulting company (whom I shall not name ‘cause getting sued isn’t in my list of things to do) insisted that patching was not necessary.  I thought this was likely one of the dumber things I had heard from a consultant’s mouth (and yeah, I’m a consultant and I say some pretty dumb things from time to time) but I had nothing to fight this with other than, “Why on earth would you not want to head off known issues?”  As you might imagine, he was Infrastructure, and I was Applications, and that battle was lost before it began.  It was fun a few weeks down the road whist watching the client put them through the wringer when things didn’t work.  That patching I wanted up front eventually happened but oh what a waste of time and effort.

If I had had a time machine to get this patch advisor (cf. Mr. Peabody’s Improbable History and yes, I look disturbingly like his boy Sherman) from the then future, I could have gone to each one of the sections of Support’s step by step guide and rebutted their every claim with the icing on the cake of, “Well, that might be what you say, but Oracle Support (you know, the vendor) says…”  Yes, I have revenge dreams and whoever gets to do this really ought to have pity on me and post their success to this blog’s comment section for my Schadenfreude moment.  :)  

What oh what does it look like?

Just like this:

This is in line with other advisors I have written about before.  It is a wizard with subsections off to the left to show what needs to be completed in each section.

Wizard steps

Each overall phase of the patching process has individual step by step guides.  Every one of the guides takes you to a new document that, at the very least, provides food for thought.  And maybe ammunition against someone who maybe shouldn’t be in the installation game.  Ahem.

Evaluate

  • Business Plan Value
  • Increase Supportability
  • Overview of EPM Patching
  • Business Plan Considerations
  • Glossary Of Terms

Plan

  • Define Proactive & Reactive Patch Plans
  • Define Patch Test Plan
  • Define Patch Implementation Plan
  • Identify Patches / Patchsets to Apply
  • Read Patch Documentation
  • Assess Impact
  • Milestone Checklist and Feedback
  • Glossary Of Terms

Test

  • Apply Patch Test Plan
  • Verify Patch Install Has Been Successful
  • Verify That Backup / Recovery Works
  • Document Lessons Learned
  • Milestone Checklist and Feedback
  • Glossary Of Terms

Implement

  • Verify That Backup / Recovery Works
  • Apply Patch Implementation Plan
  • Verify Patch Install Has Been Successful
  • Milestone Checklist and Feedback
  • Glossary Of Terms

Pretty comprehensive, eh?  The advisor really spoon feeds the whole patching process.  Thanks, I need all the help I can get and I suspect I am not alone.

But wait, there’s more

Would you believe there are more goodies to be had?  As they might say at my current client (bonus points if you can place this by US state), you betcha.

What oh what oh what are the patches for each one of our beloved EPM products?  There’s a very nice and concise list of links to all of the patches (you can sort of see part of it in the screen shot above).  Of course it is now a pretty rare thing that only one product is being used at a time (I would say almost impossible given how Shared Services and sometimes EPMA are part and parcel of practically every implementation).  Would these have been handy during my losing argument with the installer, mighten it?  You betcha again.

DescriptionDocument ID
Available Patch Sets and Patch Set Updates for Oracle Hyperion Shared ServicesDocument 1481942.1
Available Patch Sets and Patch Set Updates for Oracle Hyperion Financial ManagementDocument 1321453.1
Available Patch Sets and Patch Set Updates for Oracle Hyperion Reporting and Analysis, Financial Reporting and Interactive ReportingDocument 1360962.1
Available Patch Sets and Patch Set Updates for Oracle Hyperion PlanningDocument 1395593.1
Available Patch Sets and Patch Set Updates for Oracle Hyperion EssbaseDocument 1396084.1
Available Patch Sets and Patch Set Updates for Enterprise Performance Management Architect and Calculation ManagerDocument 1400076.1
Available Patch Sets and Patch Set Updates for Hyperion Financial Data Quality Management and FDM ERPI IntegratorDocument 1400561.1


Did you know there was a Hyperion Patch Reviews Community?  Nope, neither did I.  But now we both do.

May this bring an end to these questions on OTN

I am not totally sure why OTN (and to a lesser extent, Network54) has become the home of infrastructure-related questions when there are so many good resources in Oracle Support.  The two Johns (John Goodwin and John Booth) seem to answer most of these but I have to wonder if the original posters even bothered to look on Support.  Remember, if your company has an EPM product (actually, any Oracle product) you at least have read access to Support.  The answers Support come up with are the official word (this stuff gets vetted through a process ever so slightly more rigorous than OTN or Network54 or this blog) and ought to be at the very least your starting point for all things infrastructure.  With this patch advisor, I hope to never see (and never post myself) another patch question on OTN.

Be seeing you.