Kscope16 Apex sessions I'm interested in

Apex?  Whhaaaaaat?

Although it may be somewhat hard to believe, in fact yr. obt. svt. has technology interests outside of EPM many of which – like what would it take to really build that fusion reactor in my back shed – are likely best left unexplored.

What is best explored is an exploration of what else Kscope16 has on offer.  As most everyone knows, my quite-a-bit-smarter-not-at-all-genetically-or-familially-related-but-somehow-confused-for-me-brother Martin D’Souza, is Mr. Apex.  Although explaining Apex to me required Martin to exercise patience and lots of really small words, I now have an appreciation for Application Express aka Apex.  For those of you as clueless as I (so, exactly no one but bear with me regardless), it took a while for the penny to drop:  Apex’s concept of a relational back end and programmatically generated web code is what builds practically all of the web sites you visit except maybe ones like this.  

Good grief I – and I’ll bet you – spend a lot of time on the web:  message boards, technical documentation, user group portals, really cool upcoming conferences, this idiotic web site.  Given that just about all of the EPM products are web based, and are becoming even more so over time, and are in fact conceptually Apex-like, it occurred to me that I ought to actually try to understand what’s going on under the hood.  This is a block for hackers, right?  And what better conference than Kscope16 for understanding that?

And with that…

Paranoia

Data breaches are everywhere on the web.  Everywhere.  It’s nice to know that Kscope developers get it in the form of defensive measures.  I suppose they’re exercising their inner paranoia which nicely matches with mine.

Security from Tim Austin

APEX Security: Discussing Real-World Security Risks, Jun 28, 2016, Session 10, 2:00 pm - 3:00 pm

APEX Security: Anatomy of a Cross-Site Scripting Attack, Jun 29, 2016, Session 18, 4:30 pm - 5:30 pm

I think, I hope, I pray that attending Tim’s sessions on real world security makes the paranoia go away.  I hope.

Internet of Things

Will EPM ever be part of IoT?  I am not holding my breath.  For those of us who are not terminally dull, Anton Nielsen is running a lab on just that (IoT, not being terminally boring as I am the world domain lead for that) via his Hands-On Training: Build Something! IOT = Internet + Oracle + Things lab on Jun 27, 2016, Traditional HOT 3, 2:00 pm - 4:15 pm.

My code never sucks.  Never.  Never. Ever.  

How does that go?  Admit nothing, deny everything, make counter-accusations, never change your story.  When things go tits up, obviously someone else buggered up the code.  And Peter Raganitsch agrees. Ah, I just read his summary more closely so that isn’t strictly true:  he’ll be talking about how to find the bugs, not shift the blame.  Where’s the fun in that as blame shifting is my modus operandi.  Given that I am kidding it behooves me to attend his It Wasn't Me: Finding Bugs in APEX Applications session on Jun 28, 2016, Session 12, 4:45 pm - 5:45 pm because sooner or later someone else is going to figure out my code stinks.

Why is Apex doing so well?  

Apex is cool.  EPM?  You decide.  Perhaps we can crib a page from Juergen Schuster’s Why? session Jun 27, 2016, Session 6, 4:30 pm - 5:30 pm.  I do think in the end that it boils down to Apex geeks being far cooler than we EPMers.  Seriously, we need to figure out why they have meetups, why their exclusive conferences are so awesome, and why they are kicking EPM’s conference butt.  

Is that enough?

It ought to be.

There’s some really good content in the Apex track even if we never ever ever plan on writing a link of code in that framework.  Security, IoT, code quality – these apply to us in equal measure.  

I hope to be at each and every one of these sessions and I hope you will be too.

Postscript

Blog Hop

Thanks for attending this ODTUG blog hop! Looking for some other juicy cross-track sessions to make your Kscope16 experience more educational? Check out the following session recommendations from fellow experts!

• ADF/MAF sessions not to be missed, as recommended by Apex expert Scott Spendolini:  http://spendolini.blogspot.com/2016/05/my-must-see-adfmaf-sessions-at-kscope-16.html
• BI and Data Warehousing sessions not to be missed, as recommended by EPM expert Dayalan Punniyamoorthy: http://onlyhyperion.blogspot.com/2016/05/Kscope-6-blog-hop-BI-Data-Warehousing-sessions-not-to-miss.html
• Big Data and Advanced Analytics sessions not to be missed, as recommended by Data Warehousing expert Kent Graziano: http://wp.me/p25i8c-Rz
• Database sessions not be missed, as recommended by BI expert Stewart Bryson: https://medium.com/@stewartbryson/what-you-positively-have-to-see-in-the-database-track-at-kscope16-e98615851202#.g74pqn1xp
• EPM sessions not to be missed, as recommended by Database expert Danny Bryant: http://dbaontap.com/2016/05/26/kscope16-blog-hop-epm-sessions-not-miss

Things that go FOOM!

As a child of the Cold War, anything that involves acronyms like AEC or NRC or IAEA makes me positively squirm in my seat no matter how intriguing the thought may be.  Even solar radiation is something I avoid.  Playing with that stuff without fully understanding it (or wearing a dosimeter)?  Madness.  Apex?  Coolness.

Be seeing you.

Time to submit that Essbase abstract

Time to submit

No, not to my awesome will, altho’ I must confess to having a slight Svengali-like effect (or is that repulsive-to-all-who-know-me effect?) when it comes to ODTUG’s Kscope15.

Time for what?  Time for Essbase abstract submission for you only have till 15th October 2014 to get those submissions in and Uncle Essbase Wants You to do so as soon as possible.

Why oh why oh why would you do this?

Because you want to present at Kscope15?

Because Kscope15 is the best Oracle users conference there ever has been or ever will be?

Because a chance to present at Kscope15 is the ne plus ultra of your speaking career?

Because Essbase is awesome, and Kscope15 is awesome, so obviously the two together is awesome2?

Those are the obvious reasons.  But there’s more, more, more on offer:

• Your registration fee, which ranges from an ODTUG member Early Bird cost of $1,500 to an OMG-you-are-so-late $2,250, is waived if your presentation is accepted.
• You have received much from the ODTUG EPM (ahem, we all know that really means Essbase) community; this is your chance to give back.
• Want to build your personal EPM brand?  Showcase your firm’s consulting awesomeness?  Prove that customers really do it better than a bunch of soi-disant expert consultants?  Presenting at Kscope is the way to do that.

And what oh what oh what would you present?

Here are the subtopics.  If you can’t find something to submit under these areas, you don’t love Essbase.  So why are you reading this blog?

• Administration - automation via scripting or other tools, configuration at the Essbase server or application level, monitoring and troubleshooting, backup and recovery, and security management.
• Optimization - managing and improving Essbase performance - speed, concurrency, or storage. Also includes new features or techniques to solve well-known problems in a higher-performance way.
• Design - metadata design and dimensional analysis, application and database structure, partitioning, calculation approaches, and engine (BSO, ASO, Hybrid) selection considerations.
• MDX - multi-dimensional expressions against either ASO or BSO. ASO member formulas and calculation scripts can be involved, but consider whether the focus is the MDX itself or if the presentation belongs in ‘Calculation’ instead.
• Calculation - ASO and BSO calculation scripts, member formulas, calculation Manager for Essbase, and new or interesting approaches to specific calculation problems.
• Essbase-related technologies - integration between Essbase and Oracle or non-Oracle tools, interaction with other parts of the EPM stack, Essbase Studio, client tools, the APIs and Web Services, and Essbase Exalytics-related topics. 
• Other Essbase - business problem-focused presentations, managing Essbase projects or support, Essbase ‘internals,' and session topics that do not fit into the other subcategories.

Surely that’s enough

ODTUG is asking you to submit an Essbase abstract and summary.  I am asking you.  What, you want me to get down on my knees and beg?

How about this for a plea, a call for action, and a rousing cheer for Essbase at Kscope15:  You have good ideas (otoh, you read this blog, so maybe not…), you have passion, you love Essbase, you are a Kscope devotee, in short, you should have already submitted an Essbase abstract.  If you haven’t, good grief man, why haven’t you submitted that abstract?

I am looking forward to your Essbase abstract.  

Be seeing you.

What Kscope13 sessions am I looking forward to, Cameron edition

Introduction

In my five previous posts I’ve covered the Essbase, Planning, EPM Foundations and Data Management, EPM Reporting, and Everything Else sessions I am looking forward to (and admitting that I am somewhat unlikely to attend as I would need to be Cameron * 5 to do so and that is a scary prospect, even to me).

But what about my sessions?  Am I ever going to give you at least a hint as to what they are all about?  Am I, indeed.  I like to think, in my humble (ahem) way, that I in fact have some slightly useful information to impart.  You may not agree but after all you are reading this blog.  If you think my presentations stink and yet you’re still here you must at least admit you are somewhat confused.  OTOH, if you think my presentations aren’t half bad (and if they aren’t better than that I have wasted hundreds of hours on them, which I suppose is possible), you may be interested in the following sessions.

Top Six Advanced Planning Tips

When: Jun 24, 2013, Session 4, 1:45 pm - 2:45 pm

I am copresenting this with Jessica Cordova and it’s a chance for the two of us to impart some of the lessons learnt and techniques we’ve picked up over the years in Hyperion Planning-land.  Jessica is the primary, and me the junior on this one and you’ll understand what that means in a moment.

A bit of a side note

Actually “Six” in the title is something of a misnomer because in fact we are only going to present three sessions.  Ah, I hear you (and I do, really, in my mind, which is confusing because of course one hears with one’s ears) exclaim, “Wot?  ‘e said six an’ now he says three.  ‘e’s barmy ‘e is.”  Writing dialect is tough, especially when your inner Cockney only extends as far as really liking the Lambeth Walk.  I lay blame at the feet of my love for British war movies which, just like American ones, always have a mix of men from civvy street and there’s always someone from south of the Thames.    Also, their RSM’s have great script writers.  Wow, quite an excursion into the Weird Entertainment Cameron Likes.  

And we now return to our regular programming

Anyway, Jessica and I wrote our sections, rehearsed them via GoToMeeting, and realized that we had quite a bit (a lot) more than 50 odd minutes worth of content.  So our choice was to either cut sections out entirely or skim through our topics.  As the whole point was to do advanced topics we were in a bit of a bind until I realized that we could put up what sections we are doing up to a vote and do the balance at an ODTUG webinar after Kscope.  We are going to pinky promise on this and we all know that means that is a promise unto death.  Also, this will be an opportunity for you the audience to decide exactly what you want from us – it will be Kscope session democracy in action.  I hope you’re willing to indulge this slightly off beat approach as I think what we have to say is pretty good.

Monday Night Madness/Hyperion EPM Open Mic Night

When:  8:00pm to 10:00 pm

There is an Open Mic Night at Monday’s after-session fun.  Like a fool, I have volunteered to be one of the speakers in case there is a dearth of volunteers.  Also like a fool, and quite true to form (so I am repeating myself) I didn’t realize that one is not required, nay, is not allowed to write a presentation for this.  I wrote one.  Good thing I’ve got a really cool demo to go with it.  

We’ll see if I do this but if I do, I have got a really awesome twist on focused aggregations in Calculation Manager/Planning except this time the products are  Calc Scripts/Dodeca.  All I’ll say is that I have a way round the big problem with focused aggregations in Calculation Manager.  It is fast, fast, fast, fast.

Exalytics - An Apples to Apples Comparison

When:  Jun 25, 2013, Session 6, 8:30 am - 9:30 am

I think this has to be the Kscope group project to end all group projects.  By that I mean that John Booth, Tim German, Dan Pressman, and I all got together on the Mother and Father of all benchmarking tests.

Thanks to the generosity and quite possibly world record patience of Mark Rittman of the eponymously named Rittman-Mead, we have access to an Exalytics box.  What oh what oh what to do with it?  Why benchmark it against a really fast generic Linux box (that John bought with his own money – we are committed, or nuts) of course.  I also love that these severs are named Asgard and Zeus.  Naming the servers after mythological figures was coincidental and I think indicative of their speed.  Both environments are fast and put to shame anything I have ever seen at a client.  This project encouraged me to buy a mega laptop (well, mega as of summer 2013 – 32 gigs of RAM, 8 CPUs, and a SSD); I shall never buy one with a physical drive again.

What are our results?  As is usual, we are testing this down to the very last minute (some, like me, would argue that we are testing this beyond the last minute), so I honestly cannot say.  I will bet that whatever box you’ve got, we’ve got our hands on a faster one.  :)

Practical SQL for EPM Practitioners

When:  Jun 25, 2013, Session 8, 11:15 am - 12:15 pm

I’m terribly excited about this because I have found that I spend more and more of my time in projects using SQL to do all sorts of interesting and unusual (at least for an EPM geek) things.  It’s really opened my horizons wrt the roles I can play on a project and I find writing SQL code to be oddly therapeutic.  Yeah, I’m weird.

I’m going to use practical examples that I have used in the real world to show a bunch of techniques and approaches that I’ve found useful.  Of course, just like the Planning presentation I have more, much more, than I can possibly fit into a single session but I can temper that deficiency by blogging about it here.

As I was not all that long ago firmly in the “SQL means SELECT * FROM …” camp it’s been quite a transformation in skills for me and a valuable one to boot.  If you do EPM, and I don’t just mean Essbase and Planning, and yet are not at a SQL hacker like me I encourage you to attend.  

Lunch n’ Learn

When:  25 June, 12:45 pm to 1:45 pm

I’m sharing the dais with my much-admired former boss, Tracy McMullen (I have no idea what her title is now other than Mrs. Awesome but when I worked at interRel, she was Director of Consulting) and Chris Barbieri (Chris, I admire you too, even if you hate Essbase for reasons of technological jealously (Mr. HFM)  or maybe just sheer perverse bloody mindedness); John Booth moderates.  These are always free-wheeling and open ended.  I do get quite hungry.  This time I’m bring an energy bar.

A BSO Developer's Introduction to ASO Essbase

When:  Jun 26, 2013, Session 13, 11:15 am - 12:15

I actually didn’t sign up to do this presentation but was instead asked to do it.  I’m not an ASO wizard by any means but that actually was a good thing for this presentation because the topic is in fact how to approach ASO when one is a BSO geek.  

Yes, this has been done to death at Kscope but I think I bring two unique approaches to this subject.

1. I use Sample.Basic, the BSO database that just about everyone knows, as the subject for my conversion.  It is both harder and easier to convert than you think.  As everyone (hopefully) knows what Sample.Basic is all about wrt calcs, dimensionality, etc., I can use the familiar constructs of that database to explain a plethora of ASO topics.  Although ASO and BSO are very different technologies one can use many BSO constructs to understand ASO.
2. I used Dan Pressman’s standout ASO chapter in Developing Essbase Applications to dive deeply into the ASO kernel and understand how to design ASO databases for performance.  This was really exciting for two reasons:
1. I need to understand how tools work.  IOW, “I gots to know”.  Hopefully in a less cinematically violent way than Dirty Harry but I at least share that innate curiosity about How Things Work.  Have you ever seen a bitmap index?  You will, and it won’t make your head explode.  I now know how ASO works, or at least as well as anyone who doesn’t have an @oracle.com email address does.
2. I thought that Dan’s chapter was simply amazing, but also very, very dense.  I don’t mean that as a criticism in any way – it is a difficult and highly technical subject and a complete explanation of it is therefore obliged to be just as difficult and highly technical.  I read the chapter six times from beginning to end in an effort to understand it as well as multiple phone calls with Dan.  I am happy to announce that I think I have made more accessible what I consider to be the most important work on Essbase extant.  Do I cover all of what he wrote about or even delve into it at the same depth?  No, that simply isn’t possible within the 50-odd minutes (that time thing keeps on popping up, doesn’t it?) allotted to me but I think if you’ve read Dan’s chapter and did a big “whaaaa?” you should come to my session.  With its lessons under your belt you’ll be able to tackle Dan’s work again and again.  Btw, Dan is reprising his session from last year (quite unusual in Kscope but such is the import of his work) on 25 June from 2 to 3.  Even if you go to Dan’s session I encourage you to come to mine – the bitmap, the bitmap, the bitmap is difficult to understand at first but it is the essence of ASO performance and I cover it from a beginner’s perspective.  Did I mention I was excited?  :)

Fwiw, this was a very difficult presentation for me to write because so much of it is theory – I tend to think of myself as more the engineer type who takes theory and applies it as opposed to a physicist who strictly stays on the theoretical side of things.  So a bit of a stretch but if you are a BSO developer or someone, like me, who has seen some real dogs of ASO applications and guessed that BSO design principles may not apply, come to this session.

Conclusion or my ODTUG cup runneth over

I’ve figured out that in addition to the above two full presentations, plus the Planning copresentation, plus the benchmarking presentation, plus the open mic presentation, plus two private presentations for ODTUG/Oracle, I am somewhere in the neighborhood of 4 ½ to 5 presentations this year.  As I write all of my presentations from scratch (I do not exactly have an army of minions who do this for me) that is an incredible amount of work.  I would guess somewhere around 300 to 400 hours and it came at the expense of just about everything that wasn’t work related; there are others (hello, Dan) on these projects who have put in even more unpaid time.  Yes, I love Kscope, but maybe I can love Kscope14 a little more by trying just a wee bit less.  We’ll see if that actually comes true.  

In any case, I think I’ve got some great things in store for the next week and I will be live blogging starting Saturday with the volunteer event.  

Be seeing you round Kscope13.