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

14 September 2017

10 Years Before the Mast with ODTUG

10 years, and counting

10 isn’t quite as impressive as 20 – more like half as impressive – but a decade is a long time in technology and even in a geek’s life.  Time to see real changes in his knowledge, work, outlook, contributions, and personal life.  I won’t bother any of you with the latter except to note that I still have four cats as I did in 2008.  The rest I owe, without exaggeration, in large part to ODTUG.

I’ll make a note that this post is one of my more philosophical ones.  If you’re looking for technical advice, go read someone else’s blog.  If how you can better yourself and make a difference in your professional and personal world, read on.  

Think of this post as a love letter to a user group.  Yeah, I’m weird but what I relate is true, I promise you that.

Just what is ODTUG, Cameron?

OMG, you read my blog and don’t know?  I am (heh, I flatter myself but still), one of that august gaggle of geeks’ greatest cheerleaders.  And why not?  Through ODTUG’s Kscope (nee Kaleidoscope and the Oracle Developer Tools User Group), I’ve seen and presented (more anon on that subject) countless sessions, laughed, occasionally gritted my teeth in frustration (although that had more to do with personalities than the organization itself; I can only imagine what they thought of me), slept way too little, learnt more than I could possibly have imagined, and, most importantly of all, met fellow geeks and geekettes that have utterly transformed my life.  That’s just the conference.  There’s also six years on the board of directors, rising from a n00b with the wettest of ears to finishing on the Executive Committee, and most importantly, two years acting as the EPM liaison to the board.  I’ve written articles for the ODTUG newsletter, presented webinars, helped organize and present at meetups all over the country, interviews at conferences, promotion any which way I can – the list goes on and on.  I have been called lazy.  I don’t know why.  All of this work, all of the time, all of the sacrifice is because I love ODTUG.  I’m not the only one as ODTUG thrives because there are many just like me.  You’d have done the same given the opportunity.  You still can.  You should.

For the record:  ODTUG is the bestest, most awesomest, greatest Oracle technical conference in the world, full stop.  Join and it’ll change your life.  Don’t believe me?  Read on, Gentle Reader.

Where it all started

Although it amazes, astonishes, and dismays me (it has been quite a passage of time) to write this, I have worked in the EPM space since the day I got out of school starting with Comshare’s Commander EIS (think standard reporting via touchscreens and mainframe OLAP  ‘cos executives couldn’t handle keyboards), Arbor’s Essbase, Hyperion’s Essbase, Planning, and Financial Reports (HAL too I suppose but with great reluctance because it was an ETL abomination), and then Oracle’s Essbase, ODI, Planning, PBCS, Oracle Analytics Cloud, PL/SQL, and I’m sure a few other technologies I’ve forgotten.  

But that latter list of technologies that I have (barely) mastered would never have happened without ODTUG.  Let’s address the four Ws and one H of what today passes for journalism.

When and where?

Who amongst you remembers this?

As an aside, does anyone still use the term, “Middleware”?  That’s as obsolete as HAL.  Yeah, I hate that product.

Who?

I can think of a handful of EPM friends and colleagues whom I first met in New Orleans that are still active in ODTUG:  Joe Aultman, Gary Crisci, Natalie Delemar, Glenn Schwartzberg (Although I think at the time he viewed me as an annoying gadfly.  Come to think of it he still does.), and Tim Tow (I’ve known him since 1995 but it would be churlish not to mention him).  The list has since expanded many, many, many times.

How?

NB – I have no idea why I hung on to the program schedule from 2008 nor why I was able to find it for this post.  Blog Kismet, perhaps?

See Napoleon (my favorite insane dictator, actually the only one but only because of his many aphorisms) A1-A3?  That was just a largeish conference room with space for no more than 100 people.  And that was all there was for the whole conference.  The only subject:  Essbase.  For EPMers, Kaleidoscope 2008 was small, intimate, and utterly mind-blowing in the quality of content, depth of knowledge, the chance to put faces to message board handles, the meeting of like minds, and feeling of excitement.  There was literally nothing to touch it and we knew it was special.  ODTUG have moved from strength to strength and the conferences have grown enormously but in my mind the best one was the first.

What

That’s all on an emotional level.  From a technical level, at least personally, it was a train wreck.  Why?  Because it showed me how complacent I had become with my technical skills.  I liked to pretend that I had a solid technical skill set but sitting there in the audience showed how wrong I was when it came to design (what the Hell is a hockey stick?), calculations (heh, will this MDX thing stick around?), VBA (okay, I knew that pretty well but as the saying goes:  Complacency, shattered), on and on and on.  I’m still running to catch up.

IF self-awareness is the first step to improvement, then having a way to actuate that change is vital; Kscope has been that mechanism.

Even my lousy memory recalls this:

And this:

Yeah, one room, but there were a few more than a hundred people there.  

And that one room at Kaleidoscope 2008 for sessions?  Try 11 rooms with five timeslots per day.  Yes, really.   And that’s just EPM.  

That’s an awful lot of expertise, freely given, and if you’ve got two brain cells to rub together and ability to swallow your ego, an amazing chance for you to learn and contribute right back to the EPM community.  Re the ego bit:  some people (mostly consultants) are a bit hopeless when it comes to this but I like to think that yr. hmbl. & obt. svt. is smart enough to adopt the position of, “Huh?  Duh.  Help.”  which then leads to The Knowledge.  My father likes to say I have two ears and one mouth and it’s best to use them in proportion.  Most Kscope attendees do.

Again, for those in the Oracle EPM space, there’s nothing, absolutely nothing, like ODTUG’s Kscope.

Virtue is its own reward aka Why

That bromide is true.  At ODTUG there are as I noted many ways to give back from the Saturday service day to presenting to volunteering to buying me a cup of coffee.  Okay, I made the last bit up but you get the idea of generosity.

Professionally, the knowledge that I’ve gained in attending, presenting, networking, and volunteering have been rewarding.  Truly, without ODTUG I’d be unemployed or at least never reach my potential such as it is.

I like to joke that I couldn’t sell death during a plague and for the most part that’s true, but when it comes to encouraging people to volunteer, run for the board, present, write articles, you name it I have been successful.  That’s not because I’ve suddenly become Dale Carnegie, it’s because the opportunity and value and comradeship that ODTUG is simply draws geeks in.  I’ve watched others grow as they become involved and while the hard graft is all theirs, it’s incredibly satisfying to be there at the start.

Beyond the real satisfaction that comes from giving back to our community, ODTUG recognizes achievement.  I’ve been beyond lucky to be recognized for this but I’m most certainly not alone.  

We even get nice gongs.

NB – Yes, the below is “Look at me!  I’m awesome, aren’t I?”  Cf. my earlier comment about ego, I have one too although I do try to throttle it down.  But that’s not the point.  I highlight the below because it’s both a way of illustrating that ODTUG recognizes achievement and the way in which it does it.  And yeah, a bit of self-praise.  So sue me, I’m an American and that’s what we do.  At least I don’t have a Facebook account.

How

Best new speaker, 2009

This one was a surprise to put it mildly.  I worked for a consulting company on what I am sure was the 2nd worst project I’ve ever been on – the contention for 1st switches between two others that I will not bore you with – and I stupidly tried to save it.  That meant literally working 100 (yes, really, working till 3 am and then waking up at 5 o’clock) hours on the project, manning a booth, and presenting a session at 9 am on Thursday.  I think by that point I was so tired and annoyed that whatever few filters I have were dead and buried.  I got lots of laughs (who gets laughs after the Wednesday night event and when the subject is MaxL?) so I think that was largely the reason.  Or ODTUG recognized a geek at the end of his tether and pitied me.  A word to the wise:  Don’t Be That Guy.

In any case, I was beyond amazed to get this in the mail:

I’m still not sure I deserved it but as Gary Crisci once said, never argue with good fortune.  The kaleidoscope is pretty cool.

Volunteer of the year

Even more of a surprise was being included in the 2010 Volunteer of the Year award.  This one I’m positive I didn’t deserve because I was on the SIG for three months or so when it was awarded.  I did in fact argue with YCC on this one because truly it was the work of others but I was told to embrace the non-suck.  I did but again, it’s a bit embarrassing.

Sorry for the bad photography.  Robert Capa I’ll never be.

2017 Essbase best co-speaker

Last, and definitely not least, I won the Essbase best co-speaker award this year.  I’m 100% positive that this was due to my co-speaker, Pete Nitschke, but again, who am I to argue with deluded and mistaken judges of great taste and discernment.  

Here we are, Pete and I.  I’ve got the schnozzola for Uncle Sam and Pete is quite a bit thinner than John Bull and to be fair not exactly British but, as I like to remind him when I take the piss out of him after he’s indulged in what is undoubtedly a cathartic session of anti-Americanism, he’s got a Queen on his currency we Septics don’t.   Regardless, it was tremendous fun working with this Antipodean and it was beyond nice to be recognized. While the below is as near to 100% accurate as damn it in its depiction of the two of us, I’m not sure steamships were our subject (Hybrid Essbase and Planning was the subject and Oracle, would you please bring Hybrid support to PBCS as it really does revolutionize Planning?).

I think the inclusion of Columbia and Britannia was a nice gesture too.  See, Women in Technology is as old as the hills.  Or is that Women in Battleships?  Women With Flags?  

Here’s the award.  The kaleidoscope even works despite its fragility.  Seemingly anticipating my clumsiness, ODTUG provided a spare wheel.

Yes, it is nice to be recognized.  Yes, it is very American to brag.  Sorry, but all of this is in way of proving another point, to wit, if I can do this, so can you.  

You can attend, present, blog, Tweet, write books, volunteer, run for the Board of Directors, run meetups, & c..  Really.  All of this and more.  And you’ll even get nice doodads for your office credenza although that really isn’t the point.  Why not?  If a lazy bore like me can do it, why can’t you?  Exactly.

10 years

It’s hard to believe that it’s been that long since 2008 but indeed it has and the years have flown by.  As Monty Latiolais once said, our time in the sun is complete.  It has been a fantastic run, a spectacular one even.  I couldn’t and wouldn’t have done it without ODTUG.  I encourage you to invest blood, sweat, and tears into ODTUG because that hard work will pay you back a thousand fold as it has for me and so many others.

Be seeing you.

05 May 2017

The Compleat Idiot's Guide to PBCS No. 21 -- Change is the only constant

Plus ça change, plus c'est la même chose

I use a lot of Oracle EPM products:  Essbase (all the time), Planning (some of the time), Essbase Cloud (more and more of the time), PBCS (some of the time), FDMEE (never of the time but I need to do more (some?) of it), HFM (even looking at the export file gives me the hives) etc., etc., etc.  Does this make me an expert?  A generalist?  A dilettante?  Jack of all trades, master of none?  You decide as I certainly can’t.

That’s a lot of products, regardless.

Do I need to relearn them every six months?  Nope.  EAS is EAS is EAS world without end or at least since 2005-ish.  Good, bad, or indifferent (although you’d have to be willfully deaf not to know about the direction Oracle is taking wrt on-premises EPM), the UI has stayed the same.

If a static tool is a dead one, I fear that on-premises is at least in God’s waiting room.

Nothing’s Gonna Change

Don’t believe me?  Cast your eyes downwards.

9.3.1

Did I see this first in (I think) 2006?  Is that possible?  Probably.

11.1.1.3

It’s pretty much the same with that stupid ship’s wheel – Wheel of a ship = navigator which is not nearly as clever as someone in Hyperion’s product management group thought it was.  Can you even see it?  I just thought of it as a poor man’s Start menu.

11.1.2.3, 11.1.2.3.500, and 11.1.2.4

Now things are looking a bit more modern.  NB – This may actually have changed in 11.1.2.2 but I never implemented that release so I just don’t remember.  In any case, there is not much (none, actually) functionality change and just a tweak of the colors.

AFAIK, only the colors have changed.  And oh yeah, it works much better in Firefox than it does in IE, a 180 degree change.  Gah, I hate IE so that’s a good thing.

Same as it (n)Ever Was

In light of Oracle’s channeling of Patton channeling (mistakenly apparently) Frederick The Great (What, you come to this blog for just EPM geekiness?) when it comes to Cloud, Cloud, Cloud, Oracle’s motto is L’audace, l’audace, toujours l’audace.   And what that means is that the UI (and quite a bit of the rest of the toolset) changes.  In the example I’m going to give below, I hadn’t seriously looked at PBCS’ UI in about seven months and upon return was…confused.

The first set of screenshots are from approximately a year ago (so early 2016) that I used for a Kscope presentation.  There’s no other way (well, I guess if you work at Oracle and can get someone to cough up an old VM) to see what PBCS used to look like other than someone else’s screenshots.  And no, I won’t be able to (and don’t want to) examine each and every change.  

Instead I’ll focus on three use cases:  application management, inbox/outbox, running a job

LCM

Old

Not just old, Workspace old.  Yes, big icons, but Workspace all the way after that.  Workspace was the to access Application Management aka LCM.

As noted, there was no way to do this in the Simplified User Interface or as Jason Jones noted, the Candy Crush UI.  What do we like:  SUI or CCUI?  You decide.

This is typical Workspace design:  it looks like Windows Explorer and there’s an awful lot of information that way.  I actually prefer this approach as busy as it looks.  It’s a PC/Mac paradigm, not an iPhone/iPad interface.

Yeah, it’s hard to read.

But, given that I like to keep my Windows 7 looking as close as I can to Windows NT 4.0 that shouldn’t be all that surprising.

And yes, a screenshot of my desktop while writing this post is a bit of an Infinity Mirror.

Things Change

Remember Workspace?  Note that Workspace is gone and it ain’t never coming back.

Now go either to the pretty buttons to get to Migration:

Or use the navigator.  Yes, it’s back.  That unnamed and unknown product manager has had his revenge.  What’s nice (I am capable of a very small amount of grace) about the new navigator is that I can access everything from anywhere.  Now I like the concept of a navigator.  I still don’t miss the graphic.

Once into Migration aka used-to-be-Application Management-aka-used-to-be-LCM the UI is a lot easier to read but has way less information per screen.

But oh yeah, prettier.

In-N-Out with the old inbox

What a difference a year makes

What about changes between versions of the SUI?  

Note again how this version of the Navigator (which doesn’t have a link to Application Management):

Differs from today’s Navigator:

Back to 2016:  Navigator?  Wassthat?  Nope, we go to the Console to get at the Inbox via the Application screen.  NB – Today PBCS doesn’t have a Console.

Now we’re at the Inbox/Outbox Explorer.

Upload that file from your local box.  Yes, I’d script the whole thing but I am reviewing the UI.

New Explorer Revue

That was then, but as noted there is no longer a Console.  How then do we get to the Inbox/Outbox Explorer?  

Either through the front page’s Overview…

Or via Navigator’s Application/Overview link.  Choice is good.

It isn’t much of a change, but the Overview, Cubes, Dimensions, and Activity Reports are no longer on the side but are now tabs on the top of the Application pane are written out instead of icons.  These are minor differences but can be a bit confusing after a long absence.

The Explorer looks much the same as before.

Get a job

The UI of the past

Here we back to the beginning of 2016.  Schedule the job with a run-it-right-now property via the sadly-no-longer-with-us Console.  Click on the calendar icon (second from the top) on the left hand side and then “Schedule Jobs”.

Run it now, now, now.

Pick the job.

Confirm that it’s to be run.

And here it is a-runnin’.

Meet the new boss, same as the old one.

In 2017, go to the Navigator and then pick Jobs.

Getting into the Scheduler is a bit of a different path.

But once in, the scheduler looks and acts the same.

So no real change for the rest of the process.

Yup, it’s the same.

Whew, so at least one bit that’s the same.  For now.

Planned obsolescence

Talk about perishable goods.  I’ve documented the change between a fraction of PBCS’s administrative UI in 2016 and 2017.  I like to pretend that while I’m not writing for the ages, at least my posts are good for a year or two.  Given what I’ve shown you, that isn’t likely.

My whining aside, why belabor all of this?  Simply that your skills, skills that could once be mastered and then left on the figurative shelf, are going to go stale.  Stale means obsolescent, and obsolescence  means unemployment.  It’s always been this way but we’ve had time to adjust during that gap from 11.1.1.3 to 11.1.2.4.  No longer.

And there are a lot of changes across far more than the UI.  A lot and something that you’re not all that likely to keep up.  

So what to do?  RTM.  

Oracle and their documentation team very kindly (perhaps they take pity upon us?) provide a complete (compleat?) list of all of the changes from 2015 through the present month by month.  A feature changes?  It’s there.  But wait, you get more:  readmes, documentation links, and even videos.  I know I write a lot about Oracle’s documentation (eh, I write this blog, such as it is, books, presentations, etc. so why wouldn’t I be in favor of documentation?) but my point here is that they spend lots of $,¥, €, and £ to make this all happen.  And they need to ‘cos the product changes all the time; the UI is a minor component of the constant change of the Cloud.

PBCS and EPM are but a subset of the other cloud products Oracle has on offer.  Gentle Reader, I encourage you in the strongest terms to explore.  It’s the only way we can survive.

Be seeing you.