Mikael Sundman:

”Kaupunki on alituisessa muutoksessa. Rakennukset elävät omassa ajassaan

eikä vanhaan ympäristöön ole paluuta. Parhaimmillaan uusi ympäristö voi olla

vuoropuhelussa vanhan kanssa ja synnyttää siten enemmän. Vanhan ja

uuden välinen suhde synnyttää kolmannen asian joka on suurempi kuin

vanha ja uusi yhdessä."

IBM Planning Analytics14.6.2016

IBM Planning Analytics Esittely ja Demo

Mikko Dragon ja Arto Ryynänen

Mikko DragonPrincipal Consultant, CFO Services team lead

Over 16 years experience in IT projects, controlling and business analyzing.

15+ planning projects as developer and architect

Arto RyynänenSenior Consultant, Planning

9 years experience in Planning, Reporting and ETL. Before Affecto Arto worked for SOK.

SpecializationIBM Cognos Planning and TM1IBM Cognos BICertification in IBM Cognos 10 BI Author

IBM Planning AnalyticsPlanning Analytics demoSummary & Questions

Agenda

IBM Planning AnalyticsIBM Planning Analytics is all-in-one Cloud Solution. Solution consists of latest generation Analytic Software Solutions & Platform Components, which include

Budget and Forecast platform with custom made templates and models (TM1 OLAP)

Cognos reporting (BI) capabilities

Powerfull tool for data integrations (TurboIntegrator)

Cognos Command Center for monitoring, runnig and automization your integration tasks and processes (Cognos Command Center)

Watson Analytics

Easy to integrate with SPSS and Cognos Controller

Planning Analytics – Budgeting and Forecasting custom made entry templates

Planning Analytics – Reporting (Cognos BI)Report Studio Workspace

Planning Analytics – Data integrationPlanning Analytics has all TM1’s functions including ETL tool TurboIntegrator. Data integration processes can be run and monitored either in Planning Analytic’s Cognos Command Center or own web page views.

TM1 (TurboIntegrator)

Data source layer

Data loadings can be maintained and run from Planning Analytics’ custom made web interface or Cognos Command Center.

Planning Analytics – web page for running integration processesSource data integration by TM1 TurboIntegrator

Organization

Update Sales Dimensions

Planning Analytics – WatsonWatson

Finnair_TM1

Planning Analytics – Consolidation and eliminationsConsolidation and eliminationsOnce you have created your consolidation and elimination logic in Cognos Controller it is easy way to use that also for planning (budget and forecast) eliminations. Budget & forecast figures are then directly in Management reports without any extra integration. Eliminations and consolidation can also be built in Planning Analytics.

Finnair_TM1

Finnair_TM1

Planning Analytics models and data in TM1 cubes

Easy integration with TM1 processes

Cognos Controller dimensions and data in TM1 cubes

Contacts

Mikko DragonPrincipal Consultant, CFO Services team lead

Tel: 0400-773 422Email: mikko.dragon@affecto.com

Jani HautalaCFO Services Sales

Tel: 040-841 0011Email: jani.hautala@affecto.com