Specialized IT Services focused on Data Management | Speak with Us 877-634-9222
Art of BI: Top 10 Reasons to Migrate Integration Services to Essbase Studio
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.
Contact Us
Christian is an innovator in analytics and data warehousing design, best practices, and delivery. With more than fifteenyears of decision support and data warehousing with key experiences at Office Depot HQ, Sierra-Cedar, and Capgemini, he oversees the Oracle Analytics Practice which includes the technical development and delivery of Oracle BI collaboration software, data warehouse solutions, Oracle BI/EPM projects, and packaged analytics solutions at Datavail.
You have piqued my interest! I believe!
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.
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.
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.
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?