Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
2012 PowerPoint Presentation

2012

125 Views Download Presentation
Download Presentation

2012

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. 2012

  2. Overview • Introduction to Star Analytics • Star Integration Server • Star Command Center • Case Studies • CS #1 – General EPM Automation • CS #2 – Self-Service Automation for Business Users • CS #3 – Orchestrate Start & Stop of Services • CS #4 – Monitor Servers & Services • CS #5 – HFM & FDM Automation • CS #6 – Planning Automation • CS #7 – Automated Data Reconciliation • Review & Wrap-up

  3. STAR ANALYTICS Solid Team with deep BI background Delivering Technology to Address BI Integration and Automation Requirements Oracle Technology Partner Headquartered in San Mateo, CA Company Overview • Solutions for Automation and Integration • “Oracle EPM Ready” • Easy & Fast deployments • Customer’s Love It! Star Technology

  4. STAR ANALYTICS Star Analytics offers two products for automation and integration Star Integration Server (SIS) for integration of your BI environment Star Command Center (SCC) for automation of your BI environment Products Open Reporting Standards / RDBMS • Extracts data, metadata and security for loading in to DB or reporting applications • Supports Essbase ASO, BSO, Planning, HFM • Automated, near real-time INTEGRATION • Process Automation • Workflow Orchestration • Life Cycle Management • Audit & Compliance • Self-Service Automation AUTOMATION Flat Files Data, Meta Data &Security • Essbase • Planning • HFM

  5. Star command Center Typical Automation Environment Heterogeneous Applications Brittle Custom Code Manual Processes Lack of Control No Audit Trail / No Compliance / No Visibility

  6. Star command Center Traditional Approaches Stay Manual IT-based Scheduling Tools Scripting/Coding Traditional Approaches Result • Time Consuming • Error Prone • Not “BI Aware” • Not Built for a Business User • Brittle & Non-compliant • Labor Intensive • Costly

  7. STAR command Center Deployment

  8. STAR command Center Orchestrate applications, either on-premise or in the Cloud Deployment

  9. STAR command Center Orchestrate applications, either on-premise or in the Cloud Libraries of business functions eliminating custom code Deployment

  10. STAR command Center Orchestrate applications, either on-premise or in the Cloud Libraries of business functions eliminating custom code Business friendly interface that supports mobility Deployment

  11. STAR command Center Orchestrate applications, either on-premise or in the Cloud Libraries of business functions eliminating custom code Business friendly interface that supports mobility Central repository for compliance and audit Deployment

  12. STAR command Center Orchestrate applications, either on-premise or in the Cloud Libraries of business functions eliminating custom code Business friendly interface that supports mobility Central repository for compliance and audit Handshake with Enterprise Schedulers and Web Services Deployment

  13. STAR command Center Deployment • Orchestrate applications, either on-premise or in the Cloud • Libraries of business functions eliminating custom code • Business friendly interface that supports mobility • Central repository for compliance and audit • Handshake with Enterprise Schedulers and Web Services • Any Application with a command-line interface

  14. STAR command Center Key Benefits

  15. STAR COMMAND CENTER How does it work Process Complete On Premise Applications Run Process STAR COMMAND CENTER Unix Agent Process Task #1 Central Server Live Process Updates Process Task #2 Fetch File Resource Results Returned Windows Agent Results Returned Automation Repository Process Task #3 • Automation Binary & ASCII file resources • Unmanaged & no version control • Hardcoded values & logins Results Returned Cloud Applications Load File Resources into the Automation Repository Remote Agent • Central storage of automation resources • Audit, version control and life cycle management • Leverage dynamic variables

  16. Overview • Introduction to Star Analytics • Star Integration Server • Star Command Center • Case Studies • CS #1 – General EPM Automation • CS #2 – Self-Service Automation for Business Users • CS #3 – Orchestrate Start & Stop of Services • CS #4 – Monitor Servers & Services • CS #5 – HFM & FDM Automation • CS #6 – Planning Automation • CS #7 – Automated Data Reconciliation • Review & Wrap-up

  17. Case Study #1 Sequence tasks across different applications & servers Remove Slack-time Full Visibility to all running processes Ability to resume if errors exist General EPM Automation

  18. Case Study #2 Enable Business users to login and run own processes Access to Read / Write / Run – Dev, Test, Prod Full support for Single Sign-on with HTTPS access Self-Service Automation for Business Users

  19. Case Study #3 Start / Stop Services across all servers Distributed servers can start services in parallel Ensure application is started before moving to the next service Actively monitor from any SCC Interface No tricky code or artificial “wait times” Orchestrate the Start & Stop of Services

  20. Case Study #4 Monitor server health, services and EPM application health Tie health check into daily automation Monitor Servers & Services

  21. Case Study #5 Removal of significant amount of manual processes HFM & FDM operations sequenced with other required automation in job chain Significant increase in Oracle EPM Satisfaction HFM & FDM Orchestration with other Processes

  22. Case Study #6 Automate Set Login Level (All Users, Administrators, Owner) Automate Planning Data Copy Jobs Hyperion Planning Automation

  23. Case Study #7 Automated Data Reconciliation – Type I Flat File • Star Command Center • Data Comparison • Simple Checksum Planning RDB Repository Essbase / Planning

  24. Case Study #7 Automated Data Reconciliation – Type II SIS FDM Star Command Center Record by Record Data Comparison (via Relational) OracleRDBMS Essbase BSO & ASO HFM

  25. Case Study #7 SQL View to Compare Two Records Sets with Star’s Enhanced Error Trapping Leverages off-the-self interfaces Simple ANSI SQL SELECT e.* FROM dbo.A_FACT e LEFT OUTER JOIN dbo.B_FACT h ON h.Year = e.Year AND h.Measures = e.Measures AND h.Product = e.Product AND h.Market = e.Market AND h.Scenario = e.Scenario AND ABS(h.data - e.data) < 1 WHERE h.Measures is null AND h.Year is null and h.Measures is null and h.Product is null and h.Market is null and h.Scenario is null and h.DATA is null Rich Error Trapping & Branching w/o coding Easy to Interpret Summary Information QUERY: select 'Market: ' + Market + ' Month: ' + Year + ' Account: ' + Measures + ' <--- Do Not Reconcile' from STAR_ESSBASE.dbo.vwCHECK_SUM_FACT_AB

  26. Case Study #8 Real-time BSOASO Task #2 Extract allocated data. Star Integration Server (SIS) Task #1 Run Allocation Star Command Center Server (SCC) Planning Page Slicers are Passed as Parameters via HTTP (S) Task #3 Load ASO Cube c Run Process Extraction based upon Planning Slicers Essbase / Planning EssbaseASO

  27. Overview • Introduction to Star Analytics • Star Integration Server • Star Command Center • Case Studies • CS #1 – General EPM Automation • CS #2 – Self-Service Automation for Business Users • CS #3 – Orchestrate Start & Stop of Services • CS #4 – Monitor Servers & Services • CS #5 – HFM & FDM Automation • CS #6 – Planning Automation • CS #7 – Automated Data Reconciliation • Review & Wrap-up

  28. Star Command Center Setup & Design

  29. Star Command Center Run & Monitor

  30. Star Command Center Web Run & Monitor

  31. Star Command Center Smartphone Interface

  32. CONTACT DETAILS • Contact Us • Read about us: www.staranalytics.com • Look at us: http://seestar.staranalytics.com/ • Try us: • Download the free trial • http://staranalytics.com/products/product-trial-request/ • Auto-generated 30-day unlimited trial key • Call us: 866-756-STAR (7827) or +1 650 539 4600 • Write us: info@staranalytics.com