Transcript Slide 1

IBM Cognos FSR
Automatisera skapandet av externa och
interna rapporter med IBM Cognos FSR
Andreas Bernlind, CPM Consultant
Thomas Ekbom, CPM Consultant
Corporate Performance Management, Affecto
Important Disclaimer
•
•
•
•
•
2
THE INFORMATION CONTAINED IN THIS PRESENTATION IS PROVIDED FOR INFORMATIONAL
PURPOSES ONLY.
WHILE EFFORTS WERE MADE TO VERIFY THE COMPLETENESS AND ACCURACY OF THE
INFORMATION CONTAINED IN THIS PRESENTATION, IT IS PROVIDED “AS IS”, WITHOUT
WARRANTY OF ANY KIND, EXPRESS OR IMPLIED.
IN ADDITION, THIS INFORMATION IS BASED ON IBM’S CURRENT
PRODUCT PLANS AND STRATEGY, WHICH ARE SUBJECT TO CHANGE BY
IBM WITHOUT NOTICE.
IBM SHALL NOT BE RESPONSIBLE FOR ANY DAMAGES ARISING OUT OF
THE USE OF, OR OTHERWISE RELATED TO, THIS PRESENTATION OR ANY OTHER
DOCUMENTATION.
NOTHING CONTAINED IN THIS PRESENTATION IS INTENDED TO, OR SHALL HAVE THE
EFFECT OF:
– CREATING ANY WARRANTY OR REPRESENTATION FROM IBM (OR ITS AFFILIATES
OR ITS OR THEIR SUPPLIERS AND/OR LICENSORS); OR
– ALTERING THE TERMS AND CONDITIONS OF THE APPLICABLE LICENSE AGREEMENT
GOVERNING THE USE OF IBM SOFTWARE.
Agenda
•
•
•
•
•
3
Introduktion ”The last mile”
Introduktion till Cognos FSR
Demo av FSR
Sammanfattning
Frågor och diskussion
2015-07-06
“The last mile” i den finansiella rapporteringen
“The last mile”
Planering
Budgetering
Forecast
Konsolidering
Rapportering
Årsredovisning,
Kvartalsrapport,
Styrelserapport
Manuella processer dominerar “The last mile”
• Omfattande användning av Word och Excel som skickas via e-post
• Problem med tillförlitligheten av datan
• Bristfälliga interna kontroller
• Ingen Audit Trail
• Många moment som upprepas för varje rapporteringsperiod och
som måste göras om från början
Informationsdelning inom organisationen
• Press Releases
• Årsredovisning
“En
• Prospekt
version av sanningen”
• Styrelsematerial
inom hela organisationen
• Management Reporting
• Myndighetsrapportering
Cognos
Internal Reporting
Kvartalsrapporter
FSR
• Deklarationer
• Årsredovisningar
Investor Relations
•
• Fullmakter mm
External Reporting
Regulatory Reporting
Legal
Cognos FSR – Så funkar det
Cognos FSR Application
Output
Options
Report
Bygger på verktyg som redan ofta används
Främjar
samarbete
DataOlika
ifrån
en central
databas
format
utdata
- Microsoft
Word
and för
Excel
Cognos FSR – Så funkar det
Datakällor
Cognos FSR Application
ERP
##V
Konsoliderad data
M$8.242
2010-M$8.201
M$8.201
2010-M$8.242
Report
2010
M$8.242
M$8.201
M$8.242 M$8.201
Relational
M$8.242
M$8.201
OLAP
##V
Variabler (##V) gör det möjligt att skapa dynamiska uppdateringar av
Direktåtkomst
till källdatan
siffror och text
när informationen
ändras i datakällen
Reinsurance and other amounts recoverable reflect amounts due from
reinsurers and policyholders to cover incurred but not reported and
pending claims for minimum premium products and certain
administrative services only business where the right of offset does
not exist. See Note ##rnote
for additional
information
on reinsurance.
10 for additional
information
on reinsurance.
For
For
the ##D<cqmel>
##D<cqe>,
actual
experience
differed from
the
the three
months ended
March 31,
2009,
actual experience
differed
Company’s
key assumptions
resulting resulting
in ##D<cqqheamcpfavor>
from the Company’s
key assumptions
in favorable incurred
incurred
claimstorelated
to prior
years’ claims
medicalpayable
claims of
payable
of
claims related
prior years’
medical
$40 million,
or
$##D<cqqheamcppyin*-1>
million,claims
or ##D<cqqheamcppyd%in>
0.5% of the current year incurred
as reported for the year of the
current
year incurred
as reported
for thefactors
year ended
##D<cyeended December
31, claims
2008. Actual
completion
resulted
in a
1>.
Actualincompletion
factors
resulted
##D<cqqheamcpcfactordir>
reduction
medical claims
payable
ofin
$17
million, or 0.2% of the
in
medical
claims
payable
of as
$##D<cqqheamcpcfactor>
million,
or
current
year
incurred
claims
reported for the year ended
December
##D<cqqheamcpcfactor%>
of of
thebusiness.
current year
incurred
claims
31, 2008 for the insured book
Actual
medical
cost as
trend
reported
forathe
year ended
##D<cye-1>
for the insured
of or
resulted in
reduction
in medical
claims payable
of $23 book
million,
business.
Actual
medical
cost trend
resulted
in
0.3% of the
current
year incurred
claims
as reported
for the year
##D<cqqheamcptrenddir>
claims
payable
of
ended December 31, 2008informedical
the insured
book
of business.
$##D<cqqheamcptrend> million, or ##D<cqqheamcptrend%> of the
current year incurred claims as reported for the year ended ##D<cye1> for the insured book of business.
Cognos FSR – Hur fungerar det?
ERP Systems
Consolidations
Relational
OLAP
Strukturerad
information
Format
Cognos FSR
Applikationen
•
•
•
•
Front Page
Table of Contents
Chairman’s Statement
Business Overview
•
•
•
•
•
•
•
•
Income Statement
Balance Sheet
Cash Flow
Reconciliations
Notes – Policies
Notes – Assets
Notes – Liabilities
Notes – Equity
Icke finansiell data
(Operational / Statistical / CSR)
Samarbete
Finansiell data
Variabler/
“En
version
av
Workflow
Checklistor
Audit
Trail
Versionshantering
referenser i
sanningen”
Business Rules
text
Cognos FSR sammanfattning
Främjar samarbete
“En version av sanningen”
Kontrollerad process
Ökad effektivitet
Frågor och diskussion
11
2015-07-06