Do you know who runs the ODTUG EPM Community?

Probably not, but you should

Have you ever wondered who makes the ODTUG EPM Community initiatives come off?  I don’t mean Kscope (there’s a Conference Committee for that) but instead the webinars, the Kscope EPM Monday Night EPM event, the Technical Journal articles, the regional meetups, and the quarterly newsletter?

In large part, you do Oh Gentle reader do when you present a webinar, or have fun on Monday night, or write a whitepaper, or help out with the newsletter, or attend a meetup.  But who organizes those initiatives?  Why do they even exist?

‘Cos

These initiatives exist, and engage you, and succeed because of volunteers.  Volunteers who are just like you or yr. obt. svt. only crazier more dedicated.  They’re ODUTG volunteers that serve everyone in the EPM community within and without ODTUG.  That’s right – ODTUG is the foundation of these enterprises but they serve all EPM practitioners everywhere.  It sounds kind of awesome and it is.

They (and yes, I’m going to get to them in a moment so please bear with me) recruit webinar speakers (hey, if you’re interested in presenting an ODTUG webinar, sign up here), organize the Monday Night Kscope event, recruit Technical Journal writers, appleseed EPM meetups, and recruit writers, write articles themselves, and edit the quarterly newsletter.  None of this happens by magic and all of it happens for “free” to your benefit.  Have you noticed how these activities have picked up over the last year?  That’s not a happy accident but instead the outcome of a group of talented and hardworking individuals.

We happy few

This is the first in a series of posts on ODTUG’s EPM community and in future posts I’ll highlight each of the volunteers, but for this first go round I shall leave the panegyrics to a simple listing of the volunteers and their roles and responsibilities.  As promised, more detail will follow.

• Gary Crisci, EPM community lead emeritus*
• Gary Adashek, EPM community lead
• Jennifer Anderson, social media (Twitter, Technical Journal, webinars, newsletter, blogs) lead
• Janice D’Aloia, meetups lead and newsletter editor
• Chris Rothermel, social media
• Courtney Foster, Kscope Monday Night Madness
• Erin Davis, YCC coordinator

*A note and a happy one about GaryC (two Gary’s overwhelm my limited mind so I refer to them as GaryC and GaryA, probably to their intense annoyance):  GaryC is a recently elected ODTUG board member and as the EPM community is run by EPM community members, not the Board of Directors, he had to find a replacement.  I’m glad to note that GaryC has a namesake colleague GaryA just as interested in the EPM community.  Also, the almost-the-same names keeps my level of naming confusion to a minimum.  Sort of.

What about yr. obt. svt.?

I’m very happy to report that I am entering my last year on the board (not actually happy about that) and thus my last year as the EPM community liaison to the BoD (Hmm, not happy about that either but such are term limits.  That’s the way she goes.).  What does that title mean?  While I would love to tell you that it means I expend an enormous amount of hard work, that the success of these initiatives are due to my sterling efforts, etc. the role really is only keeping an eye on what the EPM community does and bringing any requests for funding or direction to the attention of the BoD.  It’s an easy billet.

More coming

As noted, you’ll see more on the EPM community, what we’re doing, and how you can contribute as well as benefit from these volunteers’ hard work.

Be seeing you.

Transportation Predictions for 2016

Everybody writes “year in review” stories.  But rather than dwell on the past, I’ve got the guts to predict the future!  Here’s what will happen in 2016 in the transportation world.

METRO-NORTH:    Slowly but surely, the railroad will drag itself out of the quagmire it’s been in since the Bridgeport, Spuyten Duyvil and Valhalla crashes.  On time performance will hold strong even through the winter, thanks to the dependable new M8 cars and mild weather.  Ridership will continue to climb, causing further crowding and SRO conditions on some trains.

STAMFORD GARAGE:     After waiting for its chosen developer (and Malloy campaign contributor) JHN Group to sign a contract two and a half years after being tapped for the massive TOD project, CDOT will pull the plug on its deal and replace the old garage on its own (taxpayers’) dime.

TOLLS & TAXES:   Governor Malloy’s quest for $100 billion to pay for his 20-year transportation plan will prove universally unpopular when his Transportation Funding Task Force finally issues its recommendations (originally due after Labor Day) in January. The panel will call for higher gasoline and sales taxes, tolls, motor vehicle fees and a slew of other unpopular ideas.  The legislature will react by slashing the Governor’s unrealistic plans, reluctant to have its fingerprints of anything the Task Force suggests.

EMINENT DOMAIN:          Governor Malloy will try again to impose state control over transit oriented development, reintroducing his stealth bill to create a Transit Corridor Development Agency (all of whose members he would appoint) with the power to seize any land within a quarter mile of a rail station. 

FLYING:       Returning to profitability, airlines will continue to squeeze more seats onto fewer flights, making flying an ordeal.  Frequent flyer rewards will be harder to get as desperate passengers will pay to ride in business or first class, leaving fewer seats for upgrades.

AMTRAK:     Acela will become increasingly popular, allowing the railroad to raise business fares.  Last minute seats will be harder to get, but the railroad will still refuse to expand service by buying new railcars.  Traditional “Northeast Corridor” trains will still be jammed as the railroad tries to compete with discount bus carriers.

HIGHWAYS:           With an improving economy and inadequate rail station parking, people will jam I-95 and the Merritt Parkway in even larger numbers, increasing commuting times further.  Gasoline prices will continue to decline thanks to cheap oil, sending even more people to the roads.

UBER WAFFLES:     State and city authorities will come down hard on car services like Uber and Lyft, imposing on them the same regulations and taxes now born by taxis and limos.  After “leveling the playing ground”, Uber-type services will raise fares, passing those costs on to passengers.

Will all of my predictions come true?  Check back in a year and we’ll see!  Meantime, happy traveling in 2016!

The Compleat Idiot's Guide to PBCS, No. 2. – Philip Hulsebosch's blog

Yeah, I’m stealing the content

Well, not really, more like giving a little publicity to a blog that most of this particular blog’s readers do not read.  

It’s by Philip Hulsebosch.  For those of you who don’t know Philip, he’s an accomplished EPM practitioner who has presented multiple times at Kscope as well as a prolific writer of white papers.

For some odd reason (Dear non-anglophone readers, please enjoy the following example of cultural arrogance) this blog is written in German instead of English.  Given that my German mostly consists of types of beers and descriptions of delicious meat dishes, I have been happy to turn to Google translate to get a rather good account of Philip has been up to.  

For the record, I understand that people not in the States speak other languages.  Once upon a time, even yr. obt. svt. could speak Vlaams.  Disuse has ended whatever I could communicate in something other than English.  Although some would argue that even my native tounge isn't something I've really mastered.

For those of you who are not fully monolingual, here’s Philip’s post in the original German:

http://www.hyperionimklartext.de/pbcs-fuer-eine-woche/

And here it is in the Queen’s English:

https://translate.googleusercontent.com/translate_c?depth=1&hl=en&ie=UTF8&prev=_t&rurl=translate.google.com&sl=auto&tl=en&u=http://www.hyperionimklartext.de/oracle-hyperion-planning-cloud-fuer-frittenbuden/&usg=ALkJrhhp1Y_hURHboqkEsi9VuIIyjA6MgA

Or to shorten that:  PBCS for a week.

What’s it all about, Alfie?

Do I have to put in that Michael Caine reference again?  Just listen to Cilla Black sing.  What a fantastic movie.  But I digress.  Again.

Moving beyond British movies from the 1960s, Philip covers:

• Data center location
• Planning user roles
• Reports
• Data export (quite a bit on this)

What I particularly like about Philip’s approach is that he is coming at these functions as someone who has experience in on-premises Planning but is a Cloud n00b.  Sort of just like me and perhaps you as well.

I have high hopes for many more posts from Philip.  You should too.

Be seeing you.

One of these Smart Views is not like the other, one of these things does not belong

You must look for the clew

A hat tip must be given to Gary Adashek aka @GADASHEK for it is his hard work and (apparently) incessant nagging that got this superduper feature.  See, mega multinational colossus software companies do listen to their customers.

Have a looky loo at the below two screenshots.

More than one red herring

Things you should discount:

• Excel 2013 versus Excel 2010
• Slightly different formatting styles (I used the bold red for data to show that I could write to an intersection via a ugly filter)
• Cell C3 versus B5

Do you see it?

Standard

Something new has been added

Still can’t see it?  That’s not very Holmesian.  

Gotcha!

Perhaps the subtle visual hints below help.

Going walkies

Let’s clear out that grid.

Click on “Insert Attributes” and the magic occurs.  

There they are, the five attribute dimensions from Good Old Sample Basic aka MVFEDITWWD.  No more guesing or going into the Member Selection dialog.  Finally!

There is one teensy weensy problem

That Insert Attributes selection?  It performs a retrieve.  Sample.Basic retrieves the top of the house on 0.016 seconds but for all of my love of this database, it isn’t exactly a real world example.

How do I know that Insert Attributes does this?  I know because I tried this out on an ASO database with 15 attribute dimensions (I swear, not my design) and Smart View…went away for a while.  Bummer.

Imagine that retrieve against a BSO database.  Double bummer.

Could Oracle fix this?  Absolutely – just turn off the retrieve when the dimensions are on the sheet.  It isn’t as though the data value would be any different and the function would be faster, much faster.  Also that would give the user a chance to remove the attributes he doesn’t want.  Surely this is possible, says the geek who actually has zero idea how hard this is.  Never let it be said that I let my ignorance get in the way of my wishes.  Oops, wait…

How do you get this?  It’s as easy as pi.

Simply download the latest version of Smart View.  For those of you reading this in December 2015, that’s release 11.1.2.5.510.  What could be easier?

Again a big thanks

Gary Adashek is the one to thank, not yr. obt. svt. as I would have figured this out in approximately eleventy billion years.

This is pretty cool and proof that Smart View’s progress continues apace.

Be seeing you.

Want to read the official word about Hybrid? You’re probably missing this.

A note

Before I torpedo sales of Developing Essbase Applications:  Hybrid Techniques and Practices, what I’m about to relate does not replace it, but instead supplements the Hybrid chapter Tim German and I wrote.  Keep on buying the book, hopefully in lot cases of 100 so I can sooner or later make back my fairly exciting legal fees.  For real and for true, the Hybrid chapter covers a bunch of very practical as well as theoretical (I have yet to hear from anyone at Oracle that we goofed) concepts.  What you’re about to read has some of the practical orientation but nothing currently in the way of architecture.  Thank goodness for that, say my six coauthors.  And me.

I whine, Oracle listens

The above title  is likely not a 100% accurate statement.  Probably something like, “Yr. obt. svt. whines, in desperation and despair Oracle does its very best to make me shut up and go away,” is quite a bit more likely.  Regardless of motivation, Oracle’s EPM documentation team read my last post on PBCS documentation and that documentation’s general awesomeness (and it really is awesome – miles better than the traditional documentation) and caught my whine (whinge for those of you formerly or currently in the British Empire) about the dearth of Hybrid documentation.  It turns out that there is documentation about Hybrid, and some of it is quite interesting.

The catch is not to read the 11.1.2.4 but instead to read the 12c documentation.  One might have thought that, having written all about EssCS which is after all a Cloud version of Essbase 12c, I might have given a thought to reading that release’s documentation but nope.  Read on, gentle reader so that you may not sin as I did.

The seventh son of the seventh DBAG son

In the 12c DBAG, there are no further than tweleve references to Hybrid.  This is a Good Thing.  Also, I can’t count but couldn’t resist the temptation to use that line.  Maybe 12c always means twelve points?  You decide.

The bits in bold are my emphasis.

Using Hybrid Aggregation

There are a few interesting suggestions here and a rather important one.

The following are some scenarios where hybrid aggregation is likely to improve calculation performance:

• A block storage database has sparse members that are not level 0, and are calculated according to hierarchy (rather than by calculation scripts).
• A sparse Dynamic Calc member has more than 100 children.
• You are using a transparent partition between an empty aggregate storage target and a block storage source. If the formulas on the aggregate storage target are simple and translatable to block storage formula language, you can achieve fast results on block storage using hybrid aggregation.
• You are using a transparent partition between two block storage databases, and calculation performance is a concern.

The really interesting

Minimize the size of blocks, if possible. Consider adjusting the Create Blocks on Equations setting, or in the case of calculation scripts, using the SET CREATEBLOCKONEQ ON|OFF command.

And there we have it – Hybrid design advice, suggesting that smaller is better.  True or not?  Only benchmarking can answer that question, but it’s one I plan on trying out.  You should too.

Working with Attributes

If hybrid aggregation mode is enabled, you can set the solve order for attribute dimensions and their base dimensions, eliminating the need to tag members as two-pass. In hybrid aggregation mode, the default calculation order (also known as solve order) matches that of block storage databases, with some enhancements. If you wish to use a non-default solve order, you can set a custom solve order for dimensions and members.

Solve order in Hybrid is here.  Note that this is not supported in 11.1.2.4, but it is a sign of things to come.

More about Hybrid Aggregation Mode and custom solve order

Can attribute dimensions in ASO have their own solve order?  I don’t think so.

Per the DBAG:

When hybrid aggregation mode is enabled, the default calculation order (also known as solve order) matches that of block storage databases, with some enhancements. If you wish to use a non-default solve order, you can set a custom solve order for dimensions and members in hybrid aggregation mode.

The default solve order in hybrid aggregation mode is easier to decipher than standard block-storage calculation order, for these scenarios:

• Forward references, in which a dynamic member formula references a member that comes later in the outline order. There is no outline order dependency in hybrid mode.
• Aggregation of child values based on outline order more closely matches aggregation using equivalent formulas.
• Dynamic dense members as dependencies inside sparse formulas. If a sparse formula references a dense dynamic member, the reference is ignored in hybrid mode, because by default, sparse dimensions are calculated first. You can change this behavior by assigning a custom solve order to the sparse dimension that is higher than (calculated later than) the dense dimension’s solve order.
  

Wowsers.

Optimizing Calculations

Not all that much going on here, but it’s there regardless.

Hybrid aggregation mode is available for block storage databases. Hybrid aggregation for block storage databases means that wherever possible, block storage data calculation executes with efficiency similar to that of aggregate storage databases. See Using Hybrid Aggregation.

See also the ASODYNAMICAGGINBSO configuration setting topic in the Oracle Essbase Technical Reference.

Essbase Features No Longer Supported or Deprecated in Previous Releases

Want to know what’s deader than disco before 12c aka 12.2.1.0.0?  See the ReadMe for what’s in 12c.

Retrieving Relational Data

This one is a red herring as it refers to XOLAP, not the Hybrid query processor.  I thought that XOLAP was a deprecated feature but no, it’s Hybrid Analysis that’s dead as a doornail.  

The Tech Ref

This is where I spend most of my time with Essbase documentation.  If I knew MDX, BSO calc scripts, or MaxL better, I wouldn’t need to refer to this quite so much but I’m never going to be called Mr. Memory so I’m glad it exists.  Here’s the gen on the interesting Hybrid bits.

ASODYNAMICAGGINBSO

This is the same as 11.1.2.4 but it contains an intriguing note:

Alter Application set cache_size and Query Application get cache_size, for managing the size of block- storage application cache.

Does this mean that the aggregate cache can now be changed?  It sure suggests it although the setting was there in 11.1.2.3.500 and 11.1.2.4 and it had no actual effect.  Fingers crossed that this actually works.

Functions Supported in Hybrid Aggregation Mode

There are lots of functions listed here, too many to count.  What’s interesting is that only 19 out of all of those functions are noted as not supported.  Yet.

ASODYNAMICAGGINBSOFOLDERPATH

These subdirectories are similar to those found in aggregate storage application directories. When the application stops, the directories are removed, and when the application restarts, they are replaced.

This one seems to go back and forth.  I think that in 11.1.2.3.500 this was the behavior and in 11.1.2.4 the folders persisted.  Gentle Reader, this one is for you to find out.

Alter Application

Want to set the aggregate cache?  Use alter application’s set cache_size to do so.

Again, let’s hope that it can actually be set to greater than 32 MB.

Query Application

Want to know how big that aggregate cache actually is?  Use query application sample get cache_size;

MAXFORMULACACHESIZE

Formula cache sizing applies to both BSO and Hybrid as the latter is a superset of the former so no surprise there.

So there you have it, so long as you know where to look

It’s a bit confusing and confounding to have to look at something other than the current release’s documentation but I’m really just glad it exists at all.  Hopefully we’ll see the relevant bits make it to the 11.1.2.4 documentation code stream but beggars can’t be choosers.

Again, my thanks to the Oracle EPM documentation team for helping us all out with this.  I’d have been looking at the 12c documentation about when 12c hits on-premises so this is huge, huge, huge.

Be seeing you.