essbase and hfm, a real-world guide to extended analytics ... · essbase&and&hfm...
TRANSCRIPT
![Page 1: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/1.jpg)
Essbase and HFMA Real-World Guide to Extended Analytics and
Essbase Analytics Link
Brian MarshallUS-Analytics
![Page 2: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/2.jpg)
AGENDA
l Introductionl Why are we doing this?l Why is this so difficult?l What is Extended Analytics?l EA Implementation Challengesl What is Essbase Analytics Link?l EAL Implementation Challengesl So which should I pick?l Q&A
![Page 3: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/3.jpg)
Introduction – About Brian Marshall
l 10+ Years IT and EPM/BI Experiencel Began career as a software and database developer at a small software firm.
l Developed specialization in Microsoft BI offerings.
l Focused on Oracle EPM, primarily Hyperion Essbase and Planning, with some HFM.
l Presented at Kaleidoscope 2010-2014 and various regional events.
![Page 4: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/4.jpg)
Introduction – About US-Analytics
“Focused and Committed”l Dallas-based Industry Leaders, Pioneers and Trustworthy for 13 yearsl Focused on enterprise performance management applicationsl Over 50 professionals dedicated to EPM and BIl Oracle Platinum Partner and Oracle BI Pillar Partnerl Oracle’s highest level of partnershipl Advanced degrees and certifications (CPAs, CMAs, MBAs)l Seasoned Infrastructure practice: 400+ installations/migrations l Unique blend of deep technical expertise and business acumen with hundreds of implementation cycles, driven towards a results-oriented, customer ROI
l Strong project leadership & proactive account managementl Corporate culture of integrity with 100% customer commitmentl Full Service Solution Provider
![Page 5: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/5.jpg)
About the Demo
l Extended Analytics is 11.1.2.3l Essbase Analytics Link is 11.1.2.2 (there is not 11.1.2.3…yet)
![Page 6: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/6.jpg)
l To ignore HFM, but still get the data.l HFM licenses are not cheap.l The use of Essbase reduces load on the HFM server.
l Planning and Essbase applications need actual data.
Why are we doing this?
![Page 7: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/7.jpg)
l HFM and Essbase store data completely differently.
l HFM applies eliminations and adjustments at upper levels.
l Meta-Data is difficult without Meta-Data management.
Why is this so difficult?
![Page 8: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/8.jpg)
l Relational extract of HFM data into a star schema.
l Included with any HFM license.l Managed via Workspace.l Three Extraction Types:● Standard● Essbase● Data Warehouse
What is Extended Analytics?
![Page 9: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/9.jpg)
l Meta-Data is virtually useless.l Automation can require use of the API or Star Command Center.
l Requires a relational database and possible a DBA.
Extended Analytics Challenges
![Page 10: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/10.jpg)
l EA is definitely free.l EA just works.l If you are on 11.1.2.3…its actually supported.l Everyone already uses it anyway, so if you have questions, there are plenty of answers out there.
l While a DBA may be necessary up front, generally once the build is complete, maintenance is easy.
Extended Analytics Benefits
![Page 11: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/11.jpg)
l Essbase Analytics Link provides several mechanisms for extracting data from HFM● Transparent Essbase Partition● Replicated Essbase Partition● RDBMS Data Extract
l Not just basic extraction, but mapping and translation● Mapping tables in data store
What is Essbase Analytics Link?
![Page 12: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/12.jpg)
l Meta-Data is less useless, but still not great.l May still require a relational database and possibly a DBA.
l Automation options require PowerShell scripting.
l EAL is definitely not free.l EAL is not technically supported on 11.1.2.3…yet.
Essbase Analytics Link Challenges
![Page 13: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/13.jpg)
l Can be easily administered by any Essbase admin.
l Can be as simple or as complex as you would like.
l Excellent at simple replication of HFM.
Essbase Analytics Link Benefits
![Page 14: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/14.jpg)
l Configure a template.l Select a DSN.l Perform the extract.
EA – Getting Data out of HFM
![Page 15: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/15.jpg)
l Multiple extracts● Base Data● Eliminations● Additional top-sides
EA – Getting upper levels out of HFM
![Page 16: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/16.jpg)
l Data● Load rules with views into the HFM extract.● Stub members for upper level data like eliminations or top-side adjustments.
l Meta-Data● DRM is preferred.● EPMA is a back-up.● Parent-Child query back to the extract.
EA – Getting data into Essbase
![Page 17: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/17.jpg)
l Transparent Partitions● Great if you just need to replicate HFM functionality● Provides near real-time updates of data on an easy to modify interval
● Not so great if you need to integrate the HFM data with anything else
EAL - Ways to Extract Data
![Page 18: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/18.jpg)
l Replicated Partitions● Great if you need the data to physically live in Essbase
● Great for Essbase admins that don’t have access to a relational database or the knowledge necessary to maintain one
● Won’t provide real-time updates as quickly● Requires more complex scripts for scheduling (powershell)
EAL - Ways to Extract Data
![Page 19: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/19.jpg)
l Relational Database● Great if you need to move the data to another Essbase database or another type of source altogether
● Again, won’t provide real-time updates as quickly● Again, requires more complex scripts for scheduling● Requires an additional RDBMS and the knowledge to use one
EAL - Ways to Extract Data
![Page 20: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/20.jpg)
l Transparent partitions won’t really work for thisl Replicated partitions are great for Essbase-savvy users● Calc script exports are your friend
l Relational extracts are great for SQL-savvy users
l Data regions are very important
EAL - Integrating HFM Data
![Page 21: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/21.jpg)
l Open discussion.
So Which Should I Pick?
![Page 22: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/22.jpg)
Essbase Analytics Link Demo
![Page 23: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/23.jpg)
Extended Analytics Demo
![Page 24: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/24.jpg)
Q&A
![Page 25: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/25.jpg)
l Open the HFM application.l Click Extract.l Click Data.
EA – Extract Data from HFM
![Page 26: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/26.jpg)
l Select your POV.
EA – Extract Data from HFM
![Page 27: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/27.jpg)
l Select your extract options
EA – Extract Data from HFM
![Page 28: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/28.jpg)
HFM
Add an HFM Server: Add an HFM Application:
![Page 29: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/29.jpg)
EAL - Essbase
Add an Essbase Server: Add an Essbase Application an Database:
![Page 30: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/30.jpg)
EAL - DSS and Data StoreConfigure your DSS (you only need to do this once): Add a Data Store:
![Page 31: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/31.jpg)
l Now you can finally create your actual bridge
EAL - Building Bridges
![Page 32: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/32.jpg)
EAL - The Bridge – Summary
![Page 33: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/33.jpg)
EAL - The Bridge – Data Synch
![Page 34: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/34.jpg)
EAL - The Bridge – Properties
![Page 35: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/35.jpg)
EAL - The Bridge – Target Grid Design
![Page 36: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/36.jpg)
EAL - The Bridge – Essbase
![Page 37: Essbase and HFM, A Real-World Guide to Extended Analytics ... · Essbase&and&HFM AReal/World&Guide&to&Extended&Analyticsand& Essbase&AnalyticsLink Brian&Marshall US/Analytics](https://reader030.vdocuments.us/reader030/viewer/2022040402/5e836fd79a0d78442a4d3de6/html5/thumbnails/37.jpg)
EAL - The Bridge – Extract