An Introduction
An Introduction
to
to
Hyperion Financial Data Quality
Objectives
Objectives
Problem and ChallengesProblem and Challenges
Why Financial Data Quality ManagementWhy Financial Data Quality Management
What is FDQMWhat is FDQM
Steps for FDQMSteps for FDQM
Problems & Challenges
Problems & Challenges
Da
CaCan bn be de depeploloyeyed & md & maiaintntaiainened by d by fifinanancnce ue usesers rs ±± It It is is aa ³Packaged Solution´ with pre-defined workflow
³Packaged Solution´ with pre-defined workflow
SpSpeedeeds fs finainancincial ral repeportortining ang and d plaplanninning cng cycyclesles ±
± LoadLoad, revi, reviewew, and co, and correctrrection cion cycleycless ±
± DeplDeploymoyments and ments and migraigrationtions to new aps to new applicaplicationtionss
ProProvidvides ves visiisibilbility iity into nto finfinancancial dial data ata mamananagemgemenentt processes
processes ±
± AuAuddit it trtraailil ±
± MaMap p chchanangegess ±
± DatData a ququaliality cty checheckinkingg ±
± Error Error idenidentifitificatiocation, notifican, notificationtion, , and invand investigestigatioationn
Hyperion Financial Data Quality
Hyperion Financial Data Quality
Management
Management
Simplify Financial Data
Simplify Financial Data
Collection and Transformation
Collection and Transformation
Steps for FDQM
Steps for FDQM
Create GL trial
Create GL trial
balance extract file
balance extract file
from ledger and save
from ledger and save
on local hard drive or
on local hard drive or
network.
Steps for FDQM
Steps for FDQM
Open the web browser Open the web browser and type in the following and type in the following URL address to open the URL address to open the logon page: logon page: http://<webservername> http://<webservername> /UpStreamWebLinkData /UpStreamWebLinkData Mart/Login.aspx Mart/Login.aspx
Steps for FDQM
Steps for FDQM
SSeelelect ct ththe e HyHyppeeririon on FFDMDM application from the
application from the
Application dropdown list Application dropdown list
and log onto the and log onto the
application using your application using your Network User ID and Network User ID and Password. Click on Password. Click on Logon.
I
Hard Audit
Detect and Prevent Controls
Detect and Prevent Controls
R
C
Immediate Data Quality Feedback
Immediate Data Quality Feedback
E
End Users are alerted to the quality, accuracy, andnd Users are alerted to the quality, accuracy, and completeness of the data loaded to your BPM App,
completeness of the data loaded to your BPM App,
so they are accountable, and can participate in the
so they are accountable, and can participate in the
data integrity management process.
Statistical & Supplemental Data
Statistical & Supplemental Data
Users can load supplemental data such as Users can load supplemental data such as statist
statistic ic data required data required by by Corporate. Corporate. AA complete audit trail is maintained to each complete audit trail is maintained to each entry and source document.
Data Quality Checks Passed
Data Quality Checks Passed
Successful Load«Next Phase«
Drill Across
Drill Across
User Activity Monitoring
Hyperion FDM Point-of-View
Hyperion FDM Point-of-View
Hyperion FDM Point-of-View
Hyperion FDM Point-of-View
HHyperion FDM User Name:yperion FDM User Name:Current user Current user
HHyperion FDM Application:yperion FDM Application:Current applicationCurrent application
HHyperion FDM Location:yperion FDM Location: Active location. User Active location. User
only has rights to view and load locations to which
only has rights to view and load locations to which
they have been given permission by the
they have been given permission by the
admin.Each location has it¶s own mapping tables
admin.Each location has it¶s own mapping tables
HHyperion FDM Period:yperion FDM Period: Active period. The Active period. The
Hyperion FDM period corresponds to a target
Hyperion FDM period corresponds to a target
period. Only administrators have rights to change
period. Only administrators have rights to change
the Global Hyperion FDM period.
the Global Hyperion FDM period.
System Lock Status:System Lock Status: Administrators have the Administrators have the
ability to lock Hyperion FDM to prevent users from
ability to lock Hyperion FDM to prevent users from
using the program.
using the program.
HHyperion FDMyperion FDMCCategory:ategory: Active category. The Active category. The
Hyperion FDM category corresponds to a target
Hyperion FDM category corresponds to a target
category. On
category. Only administrly administrators have rights to cators have rights to changehange
the global Hyperion FDM
the global Hyperion FDM category.category.
TargetTargetCCategory:ategory:The target category that isThe target category that is
associated with the active Hyperion FDM category.
associated with the active Hyperion FDM category.
The target categor
The target category can only be changed byy can only be changed by
changing the Hyperion FDM c
changing the Hyperion FDM category.ategory.
Global/Local Mode:Global/Local Mode:Current Hyperion FDM mode.Current Hyperion FDM mode.
Usually only administrators have rights to switch to
Usually only administrators have rights to switch to
local mode. Local mode allows an administrator to
local mode. Local mode allows an administrator to
change the period and category without c
change the period and category without changinghanging
the point of view for all other users.
the point of view for all other users.
Adaptor:Adaptor:shows which adaptor is being used for theshows which adaptor is being used for the
currentlocation. All locations default to the adaptor
currentlocation. All locations default to the adaptor
set in the Application Settings option unless
set in the Application Settings option unless
specifically overridden.
Why FDQM
Why FDQM
I
I
mprove the Productivity of Finance Staff
mprove the Productivity of Finance Staff
Oracle Hyperion Financial Data Quality Management Oracle Hyperion Financial Data Quality Management streamlines the time consuming task of manual data streamlines the time consuming task of manual data
reconciliation by automating and verifying data submissions. reconciliation by automating and verifying data submissions. Complete audit trails from trial balance to report give users a Complete audit trails from trial balance to report give users a transparent, intuitive view of data and processes.
transparent, intuitive view of data and processes.
A Web-based user interface enables business users to load, A Web-based user interface enables business users to load, review, and verify data for any target system.
review, and verify data for any target system.
Guided workflow helps users create sophisticated
Guided workflow helps users create sophisticated datadata mappings and repeatable processes.
mappings and repeatable processes.
Support for multi-GAAP (IFRS) reporting and reconciliations Support for multi-GAAP (IFRS) reporting and reconciliations
Why FDQM
Why FDQM
C
Connect Source Data to the onnect Source Data to the OracleOracle EEnterprise Performancenterprise Performance
Management System
Management System
