Want to know The Truth About CPM?

11 May 2011

Cool free stuff from Oracle and how to get more of it


Do ginormous multinationals just give away valuable information?  Apparently, if their name is Oracle, and the department is Oracle Global Support, the answer is, “Yes.”  Pretty amazing as you’ll see in a moment, and the quality is good.

What is the free stuff?

How about every new version installation note, release note, mandatory patch list, supported platform matrix, troubleshooting, general knowledge, and tool tip Oracle Support can come up with, by product?  

As an example, the Essbase (my very favorite database in the whole wide world) Master Note Index [ID 1105886.1] covers, in the very first Troubleshooting article (there are seven articles in total as listed below this table):
Document 1291202.1 Oracle Hyperion Essbase and Aggregate Storage (ASO)How to archivesDoc ID 584534.1 How To Create an Aggregate Storage (ASO) Database

Doc ID 584913.1 How To Find The Size Of An Aggregate Storage (ASO) Database in Essbase?

Doc ID 584585.1 How To Set The Aggregate Storage (ASO) Pending Cache Size Limit?

Doc ID 980315.1 How To Automate The Aggregation Process On An Aggregate Storage (ASO) Database?

Doc ID 980377.1 How To Assign Expense Reporting Tag in an Aggregate Storage (ASO) Database?

Unable to Compact ASO OutlineDoc ID 1291128.1 Unable to Compact an Aggregate Storage (ASO) Outline

Cannot Load Outline into MemoryDoc ID 947934.1 Error "1250053 Cannot load outline into memory" When Editing an ASO Outline After Upgrading to Essbase

Sort Operation Ran Out of MemoryDoc ID 596566.1 Error: "Sort operation ran out of memory. Please increase the size of aggregate storage cache."

Error Updating ASO OutlineDoc ID 800076.1 Error Updating ASO Outline "Hierarchy [DimensionName] is too complex: maximal width member number exceeds 64 bits. See application log for details."

Data Load Takes LongerDoc ID 816703.1 ASO Data Load Takes Longer in Essbase 9.3.1 Compared To Essbase 9.2

Failed to Open FileDoc ID 888642.1 When Creating Aggregate Storage (ASO) Database Error "1270076 Failed to open file [%s]: a system file error occurred. Please see application log for details"

Migrating ASO Outline Crashes EASDoc ID 1223357.1 Migrating an Aggregate Storage (ASO) Outline Crashes the Essbase Administration Services Server (EAS) When Using 64 bit Installation

Outline Restructure Takes LongerDoc ID 755871.1 Restructure of an Aggregate Storage (ASO) Database Takes a Long Time When Outline Change Logging is Enabled

There are also these articles:
Document 1089114.1 Oracle Hyperion Essbase and ODI
Document 1089108.1 Oracle Hyperion Essbase and Shared Services
Document 1090635.1 Oracle Hyperion Essbase and 64 Bit
Document 1105799.1 Oracle Hyperion Essbase and API Scripting
Document 1082973.1 Oracle Hyperion Essbase and SmartView
Document 1105876.1 Oracle Hyperion Essbase and EIS
Document 1090680.1 Oracle Hyperion Essbase and Partitioning
Document 1105830.1 Oracle Hyperion Essbase and SQL Interface
Document 1105831.1 Oracle Hyperion Essbase and Unicode
Document 1105894.1 Oracle Hyperion Essbase and Product/Technical Issues

Each one of those articles has individual notes.  Amazing stuff, eh?  This is just for Essbase.  There’s a lot more out there.

Let’s define “free”

Okay, a qualification – this really cool stuff is free if you are a customer who has a valid maintenance contract or an up to date Gold partner (I’m pretty sure below that level it’s no soap, radio, although if a Silver or below partner logs in a gets this stuff, let me know and I’ll amend this post ) or above.  Meet those requirements, and all this is yours.

But wait, there’s more

You say you love an Oracle EPM product other than Essbase?  Hard to believe, but true.  Apparently Oracle shares the love, because there are guides for all of the products (okay, I didn't search for Close Management or Profitability but I'm willing to bet they're out there -- first one to comment on this post with the link wins a mention and I'll revise accordingly) in the form of pdf files.  That means there are many, many notes chock full of good information.  More than you can imagine and if you can log onto http://support.oracle.com, you can have them for the asking.  


Did you know there was also a Planning version of this, at
Oracle Hyperion Planning Master Notes Index [ID 1083483.1]


Yes, I covered this before, but for the sake of completeness:
Oracle Hyperion Essbase Master Note Index [ID 1105886.1]

Financial Data Quality Management

And of course one for FDM:
Oracle Hyperion Financial Data Quality Management Master Note [ID 1126261.1]

Hyperion Financial Management

I can’t imagine there are too many green-shaded geeks at Cameron’s Blog For Essbase Hackers, but in case you care:
Oracle Hyperion Financial Management Master Note Index [ID 1083469.1]

But wait, there’s even more than there’s more

Did you know about the Notes Indexes?  As Alfie Elkins would say, “Not a lot of people know that”.

Do you want to know how to more effectively use Oracle Global Support?  If so, ODTUG KScope11 is the place to be.  

Is this an idle promise?  Nope.  On Wednesday, 28 June 2011, at 3:00 pm (that would be getting towards the end of the Greatest Oracle EPM Conference Ever, aka ODTUG KScope11), I’m hosting the Tech Support panel session where we will focus on good support practices – these Master Notes Index articles are but one example.

I used the word “we”.  I exaggerated -- pay no attention to me as I’m just the idiot kicking off the session and running around the room with a microphone taking your questions.  It’s Oracle’s support organization that is up on the dais and they’re the ones to whom you should ask all of your support process questions.  

More stars than there are in the heavens

No, this isn’t MGM circa 1939, but the fantastic group of Oracle Support staff that will be at this symposium.
NameTitleTechnical area
Carol CriderSr. Principal Tech Support EngineerEssbase
Larry GeraghtyPrincipal Tech Support EngineerHFM
Matthew HendricksPrincipal Tech Support EngineerSupport/development relationship
Kamila PavlaskovaPrincipal Tech Support EngineerFoundation/infrastructure
John KelloggSr. Mgr. Customer Support - EPM/BIKibitzing from the crowd
David ValociekSr. Dir. Customer Support - EPM/BIKibitzing from the crowd

These are some of the most best support people Oracle has – I know one fellow blogger (Hi, Glenn) who had this to say about Carol, “I am thrilled that Carol Criter will be there, I really admire her.  She has been around forever [and] is like a super support tech. She works with people on really big problems.  I worked with her on [Client X’s] issues”.    Dear readers, you may not believe this, but Glenn really did IM the above to me this evening, completely unprompted.  If Glenn’s excited, I’m excited, and you should be as well.

Would you believe even more than even more than there’s more?

Last one, I swear – did you know that KScope11 is going to have a Support area at the conference itself so you can go directly to Support and interact directly with Global Support superstars?

Tim Tow is owed a big round of applause for this – he’s championed it from the beginning and Oracle, in the forms of Al Marciante and David Valociek, more than stepped up to the plate with resources and people.

I’m happy just to bring you the news.

See you in Long Beach.


Deepthi said...

Hi Cameron,
Thanks so much for sharing these links. I really like your posts on the forums and am a great fan of your Essbase hackers blog.

But when I open the link and give my credentials it throws an weblogic/apache bridge error all the time :(


Cameron Lackpour said...


Which links didn't work for you?

As a test, I tried Document 1291202.1 and it worked just fine after I logged into Oracle Support. Are you sure you have a valid id?


Cameron Lackpour

Javier said...

I was going through your blog, reading up on TRACE_MDX, when I stumbled on this post.

(You had me at "free stuff".)

Anyway, I saw the high praise for Carol Crider and I wanted to echo them.

A few years ago, we had a problem with Essbase connections that had us scratching our heads bloody.

Carol asked maybe 3 questions and provided the solution immediately. It was a port-conflict issue between Essbase and Solaris. I was very impressed with the way she narrowed down and identified the issue.

She even had time to put in a dig at Solaris. She mentioned something about port numbers being registered by software vendors but, and I quote, "Solaris, in their infinite wisdom..."

It was fantastic.

As it turns out, your post was published a few days after Carol helped us. Here's the relevant post from Network54.