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

11 December 2016

Passing 300

It all began one summer

It seems so long ago (2,770 days or 396 weeks or 91 months or 7.6 years – but who’s counting?) that I first put pen to paper – Yes, I did.  Really.  I’ve now moved on to word processors for drafts and am thus so 21st century. – and started this blog.  And why the (re)counting?  Because this little corner of EPM inanity has hit 300 posts.  That’s an average of 39 posts of Stupid Programming Tricks, Compleat Idiot, Stupid Shared Services Tricks, Stupid Planning Tricks, and other sundry bits of EPM frivolity per year.  I pity you for reading this dreck.  Come to think of it, I pity myself for writing it at such a pace but on balance I think I feel worse for you.  

But it is a landmark of sorts and an opportunity to reflect on why this blog continues when so many contemporaneously launched blogs are moribund or nearly so.



So yes, 300 posts and yet some of you are still here.  Why?

Don’t know much about Essbase/PBCS/Planning/FDMEE/etc.

I seem to be forever chasing Oracle’s EPM seemingly ever-expanding products – how do I do X, how did someone else do Y (and how can I “borrow” their approach), why doesn’t that !@#$ing Z work?  Some of my fellow EPM practitioners seem to glide from tool to tool and solution to solution with nary a show of effort (Glenn, Celvin, TimG, TimT, Dino, and Pete I’m looking at each and every one of you.  With envy.).  I assure you that yr. most hmbl. & obt. svt never, ever, ever gets from A to B without a fair amount of pain.  Solving the problem is always fun, staring at it (best of course when in front of other people, the more senior the better) in complete incomprehension not so much.

So are you this?

Or this?

Everything I've Got Belongs To You

There are the greats in this industry – any industry really – and then there are the rest of us.  Is that so bad?  We’re not the smartest guys in the room but at least we get to be in the room.  Yes, I think I just insulted every one of you, Gentle Readers, but my point being that this blog’s primary purpose to help you and me get from A to B.  Maybe the fact that you read work-related blogs (obv. not just this one), read EPM books, follow EPM geeks on Twitter, and read and post on messageboards means that in fact you’re amongst the smart set.  Surely the smart ones use resources to solve their problems; surely the dumb ones don’t.  See?  I just rescued myself from having exactly zero readers.  Hopefully.

All kidding aside, this blog as it exists today would be pointless without you.  Thank you for putting up with what has been described as an idiosyncratic (read:  long winded with detours into obscurity) approach.  I hope you take the time to click on all of my laboriously-gathered links.  Goal one of this blog:  make you better EPM geeks.  Goal two of this blog:  make you all wish it was 1967 aka peak American popular culture as it’s a giant wasteland after that.  Let’s turn the clock back.  At least you’ll appreciate what your parents or grandparents (or in some cases great-grandparents) grooved to.

I’ve got your number

Google (Blogger and Google Analytics) is funny and by funny I mean inconsistent.

Here’s Blogger’s numbers:

Huzzah!  I’m closing in on a million page hits.

And then there’s Google Analytics:
Not-huzzah because it’s telling me that I’m closing in on half a million page views.  

It’s a riddle

A couple of interesting notes about the above:
  1. People don’t read this blog around Christmas.  Not a huge surprise there.
  2. My readership is going – slowly – down.  Why?

For the first, it’s nice to know that people have lives.

As for the decline (and it is real, alas) is I think based on two things:  number of posts per year (I hit my high in 2014 of 52 posts and readers vs. 40 the year after – less new content = less readers) and competition from other posts as well as Twitter and other social media.  I haven’t tried to count the number of EPM-related blogs extant today but it surely has to be about 50.  When I started it out the number was more like 10 although as noted most of those are dead, dead, dead.  YouTube, Facebook, and Twitter are yet more avenues for those who want to learn.

Or this blog sucks and is getting worse all the time.  You decide.

Why shouldn’t I

I like to think that actually the blog is getting better.  I’ve purposely hit on a combination of series posts such as the Compleat Idiot series on Planning in the cloud, Programming Stupid Tricks for unrelated Essbase, Planning, whatever-they-are tips and tricks, and community outreach posts such as live (sort of) blogging of Kscope, OpenWorld, and now meetups.  

You may have noticed that I’ve switched to a longer and more in depth approach in my Compleat Idiot cloud series.  There’s an awful lot to learn about Oracle’s cloud products.  Lots of innovation, yes, but also lots of work learning the tools and then keeping up with them.  I can’t think of how to do this except through this detailed way as so much innovation is coming out of the movement to the cloud.  Love the cloud or loathe it, money is being poured into the products in a way that simply hasn’t existed before.  That means the products change and expand constantly and that likely means the Compleat Idiot series won’t either.  That also means my life won’t get a lot better because some of these posts are over 50 pages when written in Word.  Ouch for both you in the reading and me in the writing.

While solutions to problems are what we’re all after, there is more to life and a career than code.  I’ve used this blog as a soapbox to encourage you in the strongest terms to get involved with our little community.  As an example, my involvement with ODTUG has utterly transformed my professional and personal life.  If it happened to me, it can happen to you.  Grasp the ring.  Reach.  Blow your horn.

Where I can, I’ve tried to also impart what little wisdom I’ve picked up in 20+ years of consulting in a 25+ year EPM so-called career.  Sometimes I shake my head at the folly of others when it comes to solutions (hubristically complex), code (ugly, hardcoded, slow, wrong – sometimes all four at once), and even social interactions (Is there anyone more awkward than a geek?  Thought not.) and then realize that I almost certainly did the same thing at one point or another.  Smart people learn from others’ mistakes.  Think of this as a plea to be smart and occasionally listen to me as I’ve made every mistake there is.  

The other bit of advice I’d give you is don’t be afraid to be a contrarian.  That of course doesn’t mean you’re always right, but reflect on why people say what they say.  Is a technical recommendation for the good of customer or is for the benefit of the speaker?  Is product X the solution that everyone follows because a vendor is pushing it or would some other simpler and cheaper approach work just as well?  

In a word:
 

Try to See It My Way

Have I fulfilled this blog’s mission?  Here’s what I wrote on 10 May 2009:
What about the “hacking” in the name of this blog? Hacking can mean all sorts of bad things and that’s what villains do. Good hackers are more interested in taking an ordinary tool (but so cool) and doing out of the ordinary things in a geek chic way.

To that end, I’m going to try to share with you some of the dumb things I’ve done and how you don’t have to do them, how to make Essbase do things it “can’t” do, and generally make Essbase dance.

Lastly and most importantly, I’ll also share code/techniques/approaches. I welcome your comments (constructive please, I have an average ego and it is bruised when pummeled) and most of all your suggestions for improvements. I’ve never written a piece of code that hasn’t been improved through examination by a fresh set of eyes and as a consultant if I can’t fix where I wrote it, I’ll make it better next time.

And, despite the title of this web site, I won’t limit the scope of my postings to Essbase. I’ll include anything else that touches Essbase, from Planning to Dodeca, to who knows what.

That, for good or ill, is pretty much what this blog is all about.  Through the passage of time I’ve forgotten about “geek chic” and shall henceforth casually drop it into conversation.

All kidding aside, I’ve tried very hard to live up to my vision of education and outreach and I think on balance I’ve managed to do it.

Watch what happens

So where does this blog go from here?  Will there be another 300?  Will I lose my ever-lovin’ mind and actually do this again?  Maybe.

So long as I’m involved in this little industry, I feel I have no choice but to keep learning.  Whether that’s through this blog, speaking at conferences, writing books, or in some other completely-monetarily-uncompensated form, I’ll keep on learning and sharing.  One day, hopefully not too (actually, yes, hopefully given what that entails) long from now, I’ll retire and this blog will come to an end.  I’m not dead yet and I’ve got a lot of livin’ to do so expect more of Cameron in one form or another.

Because of you

So yes, this blog exists because I use it as a mechanism to teach myself but making it public with a readership that rounds down to zero would be pointless.  Thank you for your support, your comments and corrections, and your continued readership.

Call me

Want to see a topic?  Have a question (hopefully) answered?  You can reach me care of this blog or via Twitter or via LinkedIn or reach out to me in person at meetups, Kscope, and Open World.

29 June 2012

The end of Kscope12

It’s over, it’s over, it’s over

Well, it is sort of like the end of a love affair.  I suppose loving a conference is a Strange Love indeed but there it is.  (Yes, sometimes the song references are a bit of a stretch, but think of it as my attempt to broaden your musical horizons.)  And sadly Thursday (yeah, yeah, I’m late) was the last day.

Early in the morning

Dan Pressman, ASO wizard extraordinaire, gave his chapter presentation from the book.  Although I love each and every chapter in Developing Essbase Applications, his is the one that excites me the most.  I always want to know how things work and “How ASO Works and How to Design for Performance” is our best hope of understanding how ASO Essbase works under the covers short of working for Oracle Development.  

Then a last panel for me – Planning All Stars (so how did I get included?) – this time as moderator with John Booth, Tony Depew, and Jake Turrell as the panelists.  It was a pretty freewheeling (any time panelists start insulting each other it’s at least entertaining but it was all in good fun) discussion with really good audience participation.  I do enjoy these and have found that the sheer terror of moderating diminishes with time.  Or I was so tired I didn’t care.  I vote for the latter.

And then it was time to wrap up what has been a great conference.  If you were there, you know what I mean.  If you weren’t, what are you thinking?  Get thee hence to KScope13.

The Best is Yet to Come

Did you know you can register now for Kscope13?  If you missed Kscope12, you missed the chance of not abasing yourself in a mad scramble for a free ticket (I believe brass knuckles came out as did maces, broadswords, Krav Maga, and possibly a Trident submarine).  Yes, free is good and you missed it.  However, did you know that you can submit your abstract now?  If your abstract is accepted, your conference fee is waived.  ODTUG is always looking for good, innovative, interesting, and informative sessions.  Submit one now – who knows what will happen?

Do I ever stop asking leading questions?  Yup, right now.  This is the end of my day-by-day Kscope12 coverage.

See you in New Orleans!



28 June 2012

Last full day

Oh, it’s hard to believe, and a bit sad, but it’s true – today (at least the day I am writing this and maybe posting) is the last full day of Kscope.  It has been an absolute blur from beginning to end and my level of tiredness is perhaps beyond the ability of my favorite beverage in the whole world, aka coffee, to alleviate.  I must consume more of this magical elixir.  It is just that kind of conference.

Went the day well

Yes, yes, yes, this is Cameron’s perspective but of course this is Cameron’s Blog For Essbase Hackers.  What else would you expect?

I started the day off with an interview of the older brother I never had (of course he claims that I am the younger brother he never wanted) about the overall awesomeness that is Kscope.  As if there was any doubt in your mind, I am referring to My Man in California, Glenn Schwartzberg.  Somehow, sometime, our very possibly slightly overly familiar interview will be out there on the web.  It should at least be entertaining.

And that interview finally got me:



After the criminal misadventure that was Glenn applying the temporary tatoo, we went to the end of Markus Shipely’s session Beginner’s Guide to ODI for Oracle EPM Developers.  Ah, ODI, I love you and hate you.  Mostly love.


Apparently ODTUG has really lost their mind – I was on another “experts” panel – the Essbase Experts Panel along with Dave Collins, Gary Crisci, and Tim German.  Given the discussions, I think it was really the Smart View Experts Panel.  There’s a lot of interest in that product.  Here’s MMIC after the session – he kibitzed from the audience and corrected us as required, as he always does.

I had booth duty and while the promoting and while the selling process (I am not exactly a sales guy) Developing Essbase Applications has been absolutely fascinating and educational, I am not sorry that, for at least this conference, it’s over.  


Here’s a sad photo of a now abandoned booth.

The last session I attended was Gabby Rubin’s A Forward Look at Essbase.  I can only relate two pieces of information from that:
  1. I cannot tell you anything at all about what he said.  Was he even there?  I doubt it.  For sure he'll deny it.
  2. You totally should have been there.

Tonight

Oh my goodness, what can one say about a rodeo like this – I am going to let the pictures tell the words.



 Tomorrow

There’s still the half day tomorrow, and I do have a Planning panel I am going to moderate tomorrow 28 June 2012, 10:30 to 11:30 in Wisteria/Sunflower (which I did sort of forget about, whoops – I am a bit overstretched).  


A bit out of order, but the day will start with fellow author Dan Pressman’s ASO Learn How ASO Really Works and How to Harness That Power for Good (his chapter in the book), then go to me being moderator (why am I awake – no, I don’t know either) of Planning All Stars Panel.  I may just collapse after that.

Regardless of the my deteriorating physical state, we are sadly now on the downwards slope.  I’ll post tomorrow with a wrapup and a preview of next year.

27 June 2012

What comes after one? Two.

Basic math is getting hard
As in day two of the conference (of course this is being posted on day three).  Did I mention I was tired?  I’m typing this in Gary Crisci’s “Intro to MDX + ASO” as his session ambassador and the screen is just swimming in front of my eyes.  Ugh.  I can barely figure out what comes after two.  Could it be three?  Who knows.

Does this mean I’m having fun?  Well, I’m learning a lot, and presenting (today was my melodramatically named Script or Die!), and sitting in on fellow Developing Essbase Applications authors’ sessions, and minding the book booth (more anon), and generally running around like a chicken with my head cut off.  So I guess that’s a good conference.

We’re sold out

We brought 100 copies to the conference and we are completely sold out as of 11:15 am 27 June 2012.  Amazing.  We are hot, hot, hot.  Not too hot, as Fahrenheit 451 is the burning point for paper.  We actually had a fight over the last book but one of the parties didn’t bring his credit card and the other one did.  Here’s the lucky last buyer of the book:



Of course Developing Essbase Applications is available on Amazon, so if you missed out, buy it here.

Lunch n’ Learn

I think ODTUG is a little bit out of their mind, as they included me on the Lunch n’Learn panel which was moderated by Andy Jorgensen and  included Tony Scalese, Tracy McMullen (I keep on running into her), Chris Barbieri, and yr. obdnt. srvnt.

It was a lot of fun and it is almost possible we correctly answered one or two questions.

Mixed emotions

I am, in case you haven’t noticed, a tremendous fan of ODTUG’s KScope.  My one complaint, and it is a large one, is that I simply cannot attend all of the sessions I need.  The content is so good, so broad, so deep, so valuable, that I frankly resent the fact that I am not able to be in four places at the same time.  Arrrgh.  I guess if KScope stunk, I would be happy, except then of course I’d be annoyed because it was worthless.  At least I wouldn’t feel that I needed to be in multiple places simultaneously.  This desire to be in multiple sessions is I suppose the curse of success and one that I’ll gladly take, but I am working on my cloning experiments.

26 June 2012

Missed it by that much

Sorry about that, chief”.  What, you aren’t a Mel Brooks fan?  Would you believe that Don Adams was a WW2 Marine and fought on Guadalcanal and then became a DI before going into acting and comedy?  Careers can be funny, especially when mine is examined.

KScope12 is turning out to be that marathon run like a sprint.  I couldn’t even manage to get out a report of Day One on time.  I was simply too busy when I had any energy and no energy when I had (extremely brief) downtime.  Such are the hallmarks of a great conference.

Here’s the crowd (actually, it got to almost SRO, so I was quite chuffed about that) getting ready to hear me talk about my chapter in the Developing Essbase Applications – “Slay the Evil of Bad Data in Essbase with ODI.”


I only rehearsed it, oh eight times, and while practice didn’t deliver perfection at least it didn’t result in outright disaster.

Oh, did I do that?  Why yes I did.

The above was quite serious but Kscope is that unique mix of work and fun.  The latter part of that combination evinced itself during the General Session.  Words pretty much fail me (and while I have never kissed the Blarney Stone, I could almost be Irish – I do like Guiness) with this one:


If you weren’t there, you should have been because it was…memorable.  That’s ODTUG’s board of directors getting ready to roast Mike Riley, former retiring president of ODTUG.  Scary, eh?

A really awesome keynote

I am an Essbase/Planning/ODI/EPM geek.  Or maybe I professionally live in a silo.  Cary Milsap?  Who’s that?  Okay, maybe I am just a dope because apparently everyone knows him.  Having gone to his keynote presentation, I have to say I now know why people are so enthusiastic about him.  He was, in a word, AWESOME.  Self-deprecating, humorous, warm, sharing, wise, insightful – these all describe his session.  I literally quoted him twice last night to two different people.  He was that good.

End with a bang

You know, I really, really, really need to get a phone with a better camera.  Oh well, this is the audience shot of EPM Midnight Madness.  Toufic Wakim, Tim Tow, Chris Barbieri, Tracy McMullen/Edward Roske, Natalie Delemar, yr. obdnt. srvnt., Eric Helmer, and Mark Rittman all played our version of Hollywood Squares.  As I have never in my life watched the show, I was somewhat bemused by being included in this august gaggle of geeks.  And oh yes, replicated, transparent, and linked are the three types of Essbase partitions.  ‘Nuff said.

More today, maybe

I am going to try to write today’s events, uh, today.  No promises.