cxo-cockpit€¦ · cxo-designer access the design environment any time, ... database connection...

19
CXO-COCKPIT RELEASE 5.4 WOUTER BORN NOVEMBER 2ND 2015

Upload: trandang

Post on 20-Jul-2018

216 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

CXO-COCKPIT

RELEASE 5.4WOUTER BORN

NOVEMBER 2ND 2015

Page 2: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

LOOKING BACK AND FORWARD 6.0 - New Design Studio5.2 & 5.3 - Multi-source 5.4 - New connectors/adapters

SAP Hana Connector for BPC

Direct connection to SAP Hana

CXO-Designer

Access the design environment any time,

any place.

Administrative flow greatly improved with

more intuitive user experience.

HFM 11.1.2.4

New Adapter

Data Warehouse Adapter

Load any data into CXO-CockpitMulti-source

Seamless integration of multiple sources

Android App

Available on Google Play

Security Topics

More tools for a secure setup

Integrate Enrich Enable

Text in reports

Comments & Attributes

Page 3: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

5.4 ENRICHING CXO-COCKPIT6.0 - New Design Studio5.2 & 5.3 - Multi-source 5.4 - New connectors/adapters

SAP Hana Connector for BPC

Direct connection to SAP Hana

CXO-Designer

Access the design environment any time,

any place.

Administrative flow greatly improved with

more intuitive user experience.

HFM 11.1.2.4

New Adapter

Data Warehouse Adapter

Load any data into CXO-CockpitMulti-source

Seamless integration of multiple sources

Android App

Available on Google Play

Security Topics

More tools for a secure setup

Integrate Enrich Enable

Text in reports

Comments & Attributes

Page 4: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

DATA WAREHOUSE ADAPTERINTRODUCTION

Page 5: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

o Need for a central management dashboard

o Load data from Excel files

o Explain the loaded data with narratives

o Loaded data enriches your EPM system with multi-source reports

o Remote locations can enter/load data

DATA WAREHOUSE ADAPTERTYPICAL USE CASE

Page 6: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

DATA WAREHOUSE ADAPTERARCHITECTURE

MultiSource Reports

Data Loader Reports

CXO-COCKPIT WEB APPLICATION LAYER

CXO-COCKPIT MULTISOURCE REPORTS

CXO-COCKPIT DATA LOADER REPORTS

EPM SOURCES(Hyperion, SAP BPC etc. )

DATA LOADER ADAPTER(SQL Server DB + MS SSAS)

Page 7: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

DATA WAREHOUSE ADAPTERDEMO

Page 8: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

o Better integration performance

o Less configuration

o Less error prone

o Simpler technical architecture

o Support up to 10 custom dimensions

HFM EXPRESS ADAPTERSUPPORTING HFM 11.1.2.4 AND OLDER VERSIONS

Page 9: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

New HFM Adapter based on direct

database connection

HFM Adapter using Extended Analytics

Page 10: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

o Focuses on what you want to exclude

o No custom-dimension mapping anymore

o No required scenario-dimension mapping anymore

HFM = CXO

HFM EXPRESS ADAPTEREASIER MAINTENANCE

Page 11: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

o Single page for maintaining Load Setsand executing them

HFM EXPRESS ADAPTEREASIER MAINTENANCE II

Page 12: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

o Meta-data extraction of large HFM-application: 3 minutes

o Reduction in data-extraction times with ~75% (at one customer we went from 7 hours to 1 hour)

o No load on HFM application server (0% CPU, 0 RAM)

o No additional configuration required to access HFM (‘plug and play’)

o Easy switch to HFM applications on other environments (Test vs. Prod.)

o Ability to extract Exchange Rates

HFM EXPRESS ADAPTERPERFORMANCE GAINS

Page 13: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

HFM EXPRESS ADAPTER DEMO

Page 14: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

CUSTOMER DEMOCRACY!IDEA PORTALNOVEMBER 2ND 2015

Page 15: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

CXO-COCKPIT

SERVICESJOOST VOGELEZANG

NOVEMBER 2ND 2015

Page 16: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

o The HFM Express Adapter is available for all contracts which include the current HFM adapter

o Both HFM adapters are available, no new license code is needed

o 0.5 day of remote consulting/training is needed to implement this new adapter

Contact [email protected] if you want to implement this adapter

HFM EXPRESS ADAPTERIMPLEMENTATION

Page 17: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

o The Data Warehouse Adapter is an additional connector

o Standard price is EUR1000 / USD1200 per month (multi year discount of your contract applies)

o In 2015 a 25% discount applies (for the remaining term of your contract)

o Some remote consulting is needed in order to implement this adapter

o After an intake meeting we can define the exact number of consulting hours (based on complexity of additional data source, etc.)

Contact [email protected] if you want to implement this adapter

DATA WAREHOUSE ADAPTERIMPLEMENTATION

Page 18: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

o This presentation is available at our “CXO-Cockpit Customer Advisory Board (CAB)” LinkedIn group

o If you don’t have a login yet, please send an e-mail to: [email protected]

o The 5.4 documentation is available at our Resources page: http://www.cxo-cockpit.com/resources

DOCUMENTATIONLINKEDIN / DOCUMENTATION PORTAL

Page 19: CXO-COCKPIT€¦ · CXO-Designer Access the design environment any time, ... database connection HFM Adapter using Extended Analytics. o Focuses on what you want to exclude

THANK YOU!