The ArtOfBI.com Newsletter

Is stupid new and freshly informative on BI and EPM.

Save one little gremlin by not pouring water on its head.

Or, sign up for killer tips, tricks and other BI / EPM goodness delivered right to your inbox.

Hell just do both. Enter your email below.

Oh no what happened?
I already signed up.

BTW, Signing up gets rid of this annoying banner.

Cheers,
Christian & The ArtOfBi.com Team

Top 10 Reasons to Migrate Integration Services to Essbase Studio

  • Sharebar

Sometimes I feel like I am the only evangelist out there for Essbase Studio and I wonder why that is since Essbase Studio is such a great tool.  This is especially true when you look at its ability to connect to a myriad of data source such as OBIEE, Teradata, MySQL, EPMA Dimension Server, netezza, etc.  Below is the top 10 list of why an organization should migrate their existing Essbase Integration Services models to Essbase Studio.  If your team is not an early adopter, run it in parallel.  If your team is scared of change, have them read “Who Moved My Cheese?“.  Otherwise, let’s make it happen.  Get with the program and enjoy the fruits of this fantastic toolset made for those who believe analytics are always evolving for the better.

Top 10 List

10. It has a familiar feel to EIS but its actually intuitive and user friendly.

9. It integrates with the new features of Essbase Server 11x.  Has EIS been touched since System 9x?

8. Introspection

7. There is a step-by-step tutorial on Essbase Studio Server made just for you (here).

6. Security provisioning and roles can be assigned in Shared Services.  Deliniate data modelers from administrators.

5. Essbase Integration Services is about to get sunset and Oracle Support will go bye-bye.

4. It connects to EPMA Dimension Server out-of-the-box. Ever heard of Master Data Management?

3. Essbase Studio Models are deployable with native MaXL Scripting.  Have you tried to automate a EIS deployment?

2. Essbase Studio comes with an Integration Services Catalog Migration Wizard. (hint, hint)

1. Larry Ellison wants you to.  Seriously, Oracle’s BI roadmap is taking Studio to the next frontier, not EIS.  Its a good train…get on it.

###


Comments:
  • DPB

    You have piqued my interest! I believe!

  • Guest

    Why not list out the limitations for Essbase Studio? In talking with the Essbase Studio person at Oracle they suggested we wait until the product was patched in 11.1.2.

  • Todd Binenstock

    Here is a limitation: No ability to migrate servers or export/import studio schemas. I mistook it for "big boy software". My client is rather concerned. Seems to be a major oversite.

  • http://intensedebate.com/people/ChristianScreen ChristianScreen

    Todd,

    There are some shortcomings to Essbase Studio. It is not perfected by any means but is still a great enterprise tool and definitely a better tool than EIS.

    I may actually take a look at putting together a best practice strategy for the migration in which you speak. You need to remember that a big push in Hyperion/Oracle 11x was for the usage of the Migration Utility, Life Cycle Management, and migrating "artifacts" such as Essbase Studio schemas via this one-stop system. This may be a solid reason why you don't see the interface in the Essbase Studio file menu. Start there first going through Shared Services to access Life-Cycle Management migration utility. I haven't tried it yet, but if I get it going, I'll do a write-up on it.

  • FWIII

    Regarding the ability to bring in "Dimension Server" structures, I thought EMPA (EPM Architect) was a different product than Hyperion MDM/DRM. Can Essbase Studio access MDM structures?