3_HFM_Training_E0E1

(1)

Hyperion Financial

Hyperion Financial Management

Management

Overview

(2)

Financial Consolidation,

Reporting, and Analysis

Local

Regional

Central

Monthly and

Quarterly

Actual Results

ERP/GL

Monthly

Forecast

Annual Budget

S SAAPP OOrraaccllee JJDDEE

Input or Load

Submit

alidate

Input or Load

Submit

alidate

Finance Dept.

Re!ie"

 Appro!e

 Ad#ust

 Consolidate

Approve

!e"ect

Approve

!e"ect

Group Finance

Re!ie"

 Appro!e

 Ad#ust

 Consolidate

 $C %atch

 &ranslate

Submit

Approve

!e"ect

Publi#$ report#

 SE%

SE%

 &a

&a'

'

 Legal

Legal

 &rea#ury

&rea#ury

 Management

Management

Input or Load

Submit

alidate

(3)

HFM Product Components

'yperion Reports

( Reporting and charting tool )or * e+ or print distri+ution o) )inancial reports

'yperion Application Lin, -ot a!aila+le and supported )ro% yste% 0.1 on"ards2

( Auto%ated data and %etadata integration +et"een e3ternal syste%s and 'yperion Financial Manage%ent

'yperion Financial Data Quality Manage%ent

( Pro!ides a single4 syste%atic process )or loading source data ) ro% disparate syste%s into target analytical applications. &he 'yperion FDM process pro!ides data !isi+ility4 integrity4 and !eri)ication. 'yperion FDM "ill +e used to load %etadata and data in to 'FM.

'yperion hared er!ices

( haring o) %etadata and data +et"een 'yperion Financial Manage%ent applications or +et"een 'yperion Financial Manage%ent and other 'yperion products

(4)

Product Arcitecture

Client

Application

Data

ource data

RDBM

ource data

Report

ser!er

'yperion Financial

*e+

ser!er

$$

Manage%ent ser!er

*indo"s client

Bro"ser client

Microso)t E3cel

Application

designer

'yperion

(5)

Na!igating

Hyperion Financial

Management

(6)

Hyperion Financial Management "usiness Process O!er!ie#

Load and

add data

Calculate data

Ad#ust

data

Consolidate

data

Appro!e

data

Loc, data

Run and pu+lish

)inancial reports

(7)

$imensions

Di%ensions descri+e your organi6ation7s data.

(eograp$ical (eograp$ical )nited State# )nited State# %ali*ornia %ali*ornia %onnecticut %onnecticut Ma##ac$u#ett# Ma##ac$u#ett#

Account

Entity

Period

Income +e*ore Income +e*ore &a'e# &a'e# (ro## Margin (ro## Margin Intere#t %$arge# Intere#t %$arge# &otal !evenue# &otal !evenue# Sale# Sale# Sale# Interco Sale# Interco &otal %o#t# &otal %o#t# Salarie# Salarie# ,uarter-January January February February Marc$ Marc$

(8)

$imension Hierarcies

Descendants o)

Gross Margin

Parents

Child o) Gross

Margin

Income +e*ore

&a'e#

(ro## Margin

&otal !evenue#

Sale#

Ot$er !evenue#

&otal %o#t#

Salarie#

899 -0992

-:992

-;992

-<992

899

(9)

$imensions and $ata

Data

aggregates

to the

parents.

Data is input to +ase=le!el

%e%+ers.

Income +e*ore

&a'e#

(ro## Margin

&otal !evenue#

Sale#

Ot$er !evenue#

&otal %o#t#

899 -0992

-:992

-;992

-<992

899

(10)

Hyperion Financial Management $imensions

Eight standard di%ensions

cenario

Period

>ear

?ie"

Entity

?alue

Account

$nterco%pany

(11)

%alue $imension

Entity Currency stores the srcinal input or loaded

!alue.

Contri+ution &otal stores the !alue that aggregates to

the parent.

&hese %e%+ers store the inter%ediary

!alues used to deri!e Contri+ution &otal.

(12)

&tarting te 'e( Client

>our *e+ ser!er na%e

?irtual directory -de)ault is 'FM2

>our *indo"s $D

and pass"ord

(13)

(14)

Na!igating Hyperion

Financial Management

Choose a co%%and )ro% the %enu or clic, a tool+ar +utton.

et user

pre)erences

Masthead

(15)

%ie# Pane

(16)

Ad!anced and "asic Mode

Basic %ode li%its users to the tas,s and docu%ents in the "or,spaces to "hich they ha!e access.

(17)

&etting te Point o) %ie#

Clic, a di%ension to select a %e%+er.

croll to !ie" %ore di%ensions.

(18)

*sing te Mem(er &elector

(19)

Managing $ocuments

(20)

&tarting te 'indo#s Client

>our *indo"s $D

and pass"ord

(21)

Hyperion Financial

Management $es+top

@pens an

application.

(22)

(23)

Creating Application Proles

>ou use application pro)iles )or these purposes

&o de)ine the languages a!aila+le )or entering descriptions

&o de)ine the application calendar

(24)

Accessing te Process Pad

(25)

$ening anguages

(26)

$ening te Calendar

'yperion Financial Manage%ent pro!ides a )le3i+le calendar

>ou can co%pletely custo%i6e the +ase periods4 su%%ary periods4 start year4 and nu%+er o) years.

>ou can use the standard4 custo%4 or %anual %ethod to de)ine the calendar.

Quarter 

Base Periods

u%%ary Period

(27)

Editing Fre.uencies

>ou can edit the )reuency la+els

and descriptions that are displayed in the ?ie" di%ension.

(28)

Editing Periods

>ou can edit period la+els and add descriptions.

Each hierarchy le!el corresponds to a )reuency.

Add %ultiple

periods.

Add

si+ling.

Add

child.

(29)

&a!ing Application Proles

(30)

Application Re.uirements

>ou should ha!e this in)or%ation on hand +e)ore you create an

application

&he na%e o) the application ser!er cluster

&he la+el and description )or the application

(31)

&etting *p Applications

(32)

(33)

Accessing Metadata Files

>ou access the Manage Metadata tas, )ro% the *indo"s client.

You

use t

he

Man

ag

e M

et

ad

at

a t

ask t

o

cr

eat

e

and

edi

t

met

adat

a

ﬁl

es.

Af

t

er

yo

u

cr

eat

e

or

edi

t

a

met

adat

a

ﬁl

e

yo

u

l

oad

i

t

i

nt

o

t

he

appl

i

c

at

i

on.

(34)

Editing Metadata

elect the

%etadata type.

earch )or a

%e%+er.

Create a ne" )ile.

@pen a )ile.

elect a %e%+er to

edit )ro% the list.

(35)

"uilding Mem(er Hierarcies

(36)

Mem(er ist /a(

(37)

Editing Mem(ers in ist %ie#

Add %e%+er.

Delete %e%+er.

Cut4 copy or paste.

?alidate %e%+ers.

(38)

Common Mem(er Properties

&hese properties are co%%on to %e%+ers in %ost di%ensions

Me%+er Description ecurity Class De)ault Parent 5serDe)ined 5serDe)ined; 5serDe)ined1

(39)

0uidelines )or Mem(er Names

Me%+er na%es cannot contain these characters

Period - . 2 Plus sign -  2 Minus sign - = 2  Asteris, -  2 lash %ar, - / 2 u%+er sign -  2 Curly +rac,ets - H 2 Co%%a - 4 2 e%i=colon - I 2  At sign - J 2 Dou+le uotes - K 2

.

_



=



 H

4

J



(40)

&etting *p Entities

Entities de)ine the consolidation path )or your data. Entity Entity ./one0 ./one0 Activity Activity %ali*ornia %ali*ornia )nitedState# )nitedState# (eograp$ical (eograp$ical Plant-1e#tSale# 1e#tSale# %onnecticut %onnecticut Ea#tSale# Ea#tSale#

Eastales and

*estales occur

in alternate rollups.

Entity Entity ./one0 ./one0 Activity Activity (eograp$ical (eograp$ical Sale#Service# Sale#Service# 1e#tSale# 1e#tSale# Manu*acturing Manu*acturing Ea#tSale# Ea#tSale# EmeaSale# EmeaSale# EmeaService# EmeaService# Development Development

>ou can create

%ultiple consolidation

paths +y placing an

entity child %e%+er

under %ore than one

parent.

(41)

Re.uirements )or Entities

Be)ore adding an entity4 you should ha!e this in)or%ation

&he parent to "hich the entity7s data rollups

&he currency in "hich data is input )or the entity

*hether ad#ust%ents through #ournal should +e allo"ed )or the entity

&he security class )or the entity

*hether the entity can +e a partner in interco%pany transactions

For statutory applications4 the holding co%pany )or the entity

(42)

Entities and 1ournals

&he Allo"Ad# property ena+les posting o) #ournal ad#ust%ents to the Ent Curr Ad#N %e%+er )or an entity

(43)

Entities and Intercompany Partners

peci)ies "hether the entity

displays as a %e%+er in the

$CP di%ension.

peci)ies a security

class )or the entity )or

interco%pany transactions.

(44)

Entities and te ICP $imension

&he $CP di%ension includes all %e%+ers o) the Entity di%ension )or "hich the $s$CP property is selected.

Cali)ornia

Plant

*est ales

999

Me%+ers o) the $CP di%ension

Me%+ers o) the Entity di%ension

$s$CP

Me%+er

Attri+ute

Plant

(45)

Adding Currencies

>ou %ust add a currency to the application )or each de)ault currency assigned to an entity in the Entity di%ension.

elect Currencies

)ro% the Metadata

$te% drop=do"n

list to add or edit

currencies.

(46)

&etting *p Accounts

and Custom $imensions

&he Account di%ension de)ines the chart o) accounts )or an application.

Custo% di%ensions pro!ide additional detail )or accounts.

&en prede)ined account types pro!ide +uilt=in )inancial intelligence.

Account &ype#



Asset



Balance



Lia+ilities



Balance Recurring



$nco%e



Currency



E3pense



Dyna%ic

(47)

Account /ypes and Hierarcies

Account types deter%ine "heth er child !alues are added to o r su+tracted )ro% their parent !alue.

GrossMargin

&otalRe!enues

&otalCosts

E3pense

Lia+ility

Asset

&otalRe!enues are added to GrossMargin

and &otalCosts are su+tracted.

$nco%e

&angi+leAssetset

&angi+leAssets

(48)

/ime "alance and Account /ypes

 Account type deter%ines h o" +alances accu%u late o!er ti%e

$nco%e4 E3pense4 and Flo" account types total across periods.

 Asset4 Lia+ility4 Balance4 Balance Recurring4 and Currency Rate accou nt types do not total across pe riods.

&otal Re!enues

_$nco%e

Cash on 'and

_Asset

Quarter 

:9

<:

:9

<:

99

:9

<:

(49)

$ynamic Account /ype

 Accounts that use the Dyna%ic a ccount type ha!e this +e ha!ior

Results are calculated on the )lyI data is not stored.

Parent totals are calculated dyna%ically4 not aggregated4 to pro!ide correct !alues )or ratios and percentages.

GrossMarginPct is calculated dyna%ically )or

Quarter4 not aggregated )ro% its children

(50)

0roup a(el Account /ype

5sed "ith parent accounts "hose children do not need to aggregate

Does not create parent data !alue

'elps reduce data+ase si6e

Group La+el

&hese accounts do

not aggregate to a

%eaning)ul !alue.

tatistical

&a3Rate

uareFootage

5nitPrice

5nitsold

(51)

Accounts and Custom $imensions

Custo% di%ensions "or, in con#unction "ith the Account di%ension4 pro!iding additional detail )or accounts.

Four custo% di%ensions are pro!ided.

&he ales account uses the

Custo% di%ension to capture

sales detail +y product.

&he Cash account uses the

Custo%8 di%ension to capture

cash )lo" detail.

(52)

Assigning Custom Mem(ers to Accounts

Custo% %e%+ers are

not !alid )or Cash.

ClosingBalance and its

descendants in Custo%8

are !alid )or Cash.

(53)

"alance &eet Accounts

and Custom $imensions

>ou can use custo% di%ension %e%+ers to trac, %o!e%ent detail )or +alance sheet accounts.

(54)

Custom $imensions and Account /ypes

Me%+ers in custo% di%ensions inherit the account type +eha!ior o) the account "ith "hich they are used.

*hen trac,ing +alance sheet %o!e%ent4 you %ay need to o!erride the account type )or so%e custo% %e%+ers.

&hese %e%+ers

use the de)ault

account +eha!ior.

&hese %e%+ers

need to sho"

%onthly !alues4

not >&D +alances.

&his %e%+er

needs to +e

su+tracted )ro%

closing +alance.

ClosingBalance

@peningBalance

$ncreases

Decreases

(55)

&etting *p Custom Mem(ers )or "alance &eet Mo!ement

5se "itch&ypeForFlo" to change the )lo" +eha!ior )or custo% %e%+ers

( $) the associated account uses +alance +eha!ior -)or e3a%ple4 asset or lia+ility accounts24 the custo% %e%+er s"itches to )lo" +eha!ior.

( $) the associated account uses )lo" +eha!ior -)or e3a%ple4 inco%e or re!enue accounts24 the custo% %e%+er s"itches to +alance +eha!ior.

5se "itchignForFlo" to re!erse the sign )or custo% %e%+ers.

&his %e%+er needs

"itchignForFlo"

to re!erse the sign.

&hese %e%+ers need

"itch&ypeForFlo".

ClosingBalance

@peningBalance

$ncreases

(56)

Auditing $ata

(57)

Account Properties )or Intercompany

&hese are the properties )or interco%pany accounts

$s$CP

PlugAcct

(58)

Oter Account Properties

Additional account properties ena+le you to speci)y the )ollo"ing con ditions

 *hether account data is calculated or input

 *hether account data is aggregated to the parent

 *hether data )or custo% di%ensions is aggregated )or the account

 &he nu%+er o) deci%al places

(59)

&etting *p &cenarios

 &he cenario di%ension represents a set o) related data4 such as +udget4 actual4 or )orecast

 Be)ore you add a cenario di%ension %e%+er4 you should ha!e this in)or%ation ready ( &he )reuency )or the scenario data

( &he )reuency )or interco%pany transaction data

( &he de)ault data !ie"4 periodic or year=to=date

( &he de)ault data !ie" )or periods "ith %issing data

( *hether consolidation should +e +ased on periodic or year=to=date !alues

( *hether the scenario "ill support process %anage%ent and4 i) so4 the nu%+er o) re!ie" le!els

( *hether accounts can use line=ite% detail in this scenario

(60)

Fre.uency and %ie#

&he )reuency o) a scenario speci)ies the ti%e period le!el at "hich data can +e input4 )or e3a%ple4 %onths or uarters.

( E3a%ple  >ou load actual data on a %onthly +asis4 so the )reuency )or the Actual scenario is set to Monthly.

( E3a%ple ;>ou )orecast earnings on a uarterly +asis4 so you set the )reuency o) the Forecast scenario to Quarterly. Data input is not per%itted in %onths.

&he de)ault data !ie" )or a scenario can +e either periodic !alues or year=to=date !alues.

Oanuary Fe+ruary March Quarter 

Periodic 9 9 : 1:

>ear to

Date 9 ;9 1: 1:

>ear to Date gi!es a

running total.

(61)

%ie# and Missing $ata

Missing data can +e interpreted as either 6ero )or the current period -Periodic2 or as 6ero )or year to date ->&D2.

>ou can speci)y separate settings )or non=ad#usted data and )or ad#usted data.

Data )or August is %issing.

Budget scenario uses

(62)

&cenarios and Process Management

Process Manage%ent is ena+led

+y scenario4 and each scenario can

support up to 9 le!els o) re!ie".

(63)

Conguring Application

&ettings

(64)

Conguring E2cange Rate

and /ranslation &ettings

5se the De)aultCurrency property to speci)y the de)ault currency )or the application.

5se the De)aultRateForFlo"Accounts and De)aultRateForBalanceAccounts to speci)y the accounts used to store e3change rates )or )lo" accounts and +alance accounts.

(65)

P%A Metod

&he Periodic ?alue Add -P?A2 %ethod

 &ranslates #ust the >&D change )ro% the pre!ious period at the current period7s e3change rate

 Adds this to the pre!ious %onth tran slated +alance

De)ault Method P?A Method Oan Fe+ Oan Fe+

E3change Rate 1 ; 1 ;

Local Currency >&D :9 <: :9 <:

&ranslated >&D :9 :9 :9 ;99

Current period

increase/decrease at

<: ( :9  ;:

 ;

:9

 :9

(66)

Consolidation &ettings

 @rg +y Period

 Aggregation )or $nterco%pany a ccounts

(67)

Org (y Period

 Ena+le @rg +y Period i) you need entity structures that !ary )ro% period to period.

 @rg +y Period lets you %ar, entities as acti!e or inacti!e )or each period.

( E3a%ple Entity A "as sold in March4 so you %ar, it as inacti!e )ro% March )or"ard

 $nacti!e entities are not consolidated to their parent.

 &he De)aultForActi!e property speci)ies "hether entities are inacti!e +y de)ault or acti!e +y de)ault -9$nacti!e4 Acti!e2.

J

(68)

Intercompany Aggregations

&he $nterco%panyAggregation*eight property lets you speci)y a consolidation percentage )or interco%pany entities to their parent $CP &op

 A !alue o)  represents 99S -)or e3a%ple4 speci)y .: )or :9S2

$CP &op

Plant

(69)

Consolidation Rules

Ena+le Consolidation Rules i) you need to "rite custo% rules to o!erride the de)ault consolidation and eli%ination process.

$) you select this option4 you can de)ine consolidation %ethods.

T T C@@L$DA&E R@5&$E  T u+ Consolidate-2

T T Do not Consolidate i) Euity Method 

T T $) Method N KEQ5$&>K then

T Call *rite&oFile-KEntityK U Entity U K P@*K U P@* U K PM$K U PM$ U KAccount  K U Account2 T================================================= T De)ault consolidation T================================================= T Call '.Con-KK4PCon4KK2 T================================================= T Eli%inations T=================================================

T elect Case Account TAccount is !aria+le )ro% a+o!e Call Data5nit co%%and

(70)

Conguring %alidation Account &ettings

&he ?alidationAccount property identi)ies the !alidation account )or your application.

&he !alidation account is used +y process %anage%ent and )or data loc,ing.

&he !alidation account +alance %ust +e 6ero

+e)ore data can +e pro%oted or appro!ed.

(71)

Conguring &ecurity &ettings

ecura+le di%ensions include ( Account

( Entity

( cenario

( $CP

( Custo% di%ensions

>ou can ena+le or disa+le security )or each o) these di%ensions.

>ou can ena+le or disa+le %etadata )iltering )or the application.

Account

Entity

cenario

$CP

Custo%

Custo%8

(72)

Metadata Filtering

Filtering the display o) %etadata +ased on user security access )acilitates na!igation in large applications.

For hierarchical displays4 the ancestors o) %e%+ers to "hich the user has access display4 +ut are not selecta+le.

$) the user has access to

the children o) Cali)ornia

only4 then the ancestors

display +ut are not

selecta+le.

Entity

Geographical

5nitedtates

Cali)ornia

999

Plant

*estales

(73)

Node &ecurity

Parent option li%its data access to these

%e%+ers.

(74)

(75)

Metadata oad Files

Metadata load )iles can +e in AC$$ or ML )or%at.

&hey can contain %etadata )or

(

Account4 Entity4 cenario4 Custo%4 and $CP di%ensions

(

Currencies

(

Application settings

(

Consolidation %ethods

&hey cannot contain %etadata )or

(

Periods

(

>ears

(76)

Format )or oad Files

Load )iles are di!ided into sections "ith a e3cla%ation point as the section deli%iter

ections can +e in any order in the )ile

Fields )or the ite%s "ithin a section are deli%ited "ith any o) these characters ( 4VJWXUYZI[\

!CURRENCIES

EUR;0;English=Euro;;French=Euro

USD;0;English=US Dollar;;French=Dollar Americaine

GBP;0;English=Briish Poun;;French="i#re Anglaise

(77)

Format )or $imensions



For each di%ension

(

>ou add a ]MEMBER section to speci)y %e%+ers and their properties

(

>ou add a ]'$ERARC'> section to speci)y the parent/child relations

(78)

Mem(ers &ections

5se a separate Me%+ers section )or each di%ension

Me%+er properties %ust +e speci)ied in the correct order

 All %e%+er properties %ust +e included

(

Lea!e a )ield e%pty +lan, rather than o%itting it i) you are not pro!iding a !alue

5se > )or true and & )or )alse

!$E$BERS=Scenario

Acual;$%D;Perioic;Perioic;Perioic;&;Re

Acual;$%D;Perioic;Perioic;Perioic;&;Re'oring;;;N ;S&S%E$;(0;&

'oring;;;N ;S&S%E$;(0;&

Buge;$%D;Perioic;Perioic;Perioic;&;Bugeing;;;&;S&S%E$;(0;&

(79)

Hierarcy &ections

]'$ERARC'> sections de)ine the parent/child relations "ithin di%ensions

5se this )or%at

parent %e%+erNIchild %e%+erN

Represent top=le!el %e%+ers as children o) an e%pty parent Itop=le!el %e%+erN

!)IERARC)IES=Eni*

;Geogra'hical

Geogra'hical;UnieSaes

Geogra'hical;Euro'e

UnieSaes;Cali+ornia

Cali+ornia;(000

Cali+ornia;Plan(

Cali+ornia;,esSales

Entity

Geographical

5nitedtates

Cali)ornia

999

Plant

*estales

Connectticut

Massachusetts

(80)

Application &ettings &ection

&he ]APPL$CA&$@YE&&$G section de)ines settings that apply to the entire application

5se this )or%at to de)ine application settings PropertyN?alueN

!APP"ICA%I-N.SE%%INGS

Currenc*=USD

_{De+aulRaeForBalanceAccouns=RA%E(}

De+aulRaeForBalanceAccouns=RA%E(

De+aulRaeForFlo/Accouns=RA%E

UseP1AForBalanceAccouns=&

UseP1AForFlo/Accouns=&

(81)

Currencies &ection

&he ]C5RREC$E section de)ines the application7s currencies.

>ou speci)y a currency la+el4 scale and descriptions )or one or %ore languages.

5se this )or%at

 currency la+elNIscaleNIoperatorNIlanguageNdescriptionN

!CURRENCIES

EUR;0;$

22 English=Euro;French=Euro

English=Euro;French=Euro

USD;0;$;English=US Dollar;French=Dollar Americaine

GBP;0;$;English=Briish Poun;French="i#re Anglaise

(82)

oading and E2tracting Metadata

(83)

oad Options

(84)

E2tracting Metadata

>ou can sa!e e3tract )iles

in ML or 'yperion

Financial Manage%ent

application )or%at.

(85)

oading Metadata #it

Hyperion Application in+

'yperion Application Lin, lets you

( $ntegrate enterprise resource planning syste%s -ERP2 and other transaction=processing applications "ith 'yperion products

( Mo!e data and %etadata +et"een 'yperion products

'yperion Application Lin, uses the integration en!iron%ent and adapter technology o) ?ignette Business $ntegration tudio -?B$2

Data integrations are created using adapters

( Adapters are product=speci)ic and let you %ap data and %etadata +et"een products

( A li+rary o) standard adapters is included

(86)

/e Hyperion Financial Management Adapter

&he 'yperion Financial Manage%ent Adapter lets you

peci)y logon in)or%ation )or a 'yperion Financial Manage%ent application

@pen an application.

Load %etadata )or an application.

(87)

(88)

$ata oad Files

 Load )iles are di!ided into sections "ith an e3cla%ation point as the section deli%iter.

 ections can +e in any order in the )ile.

 De)ault colu%n order is cenario4 >ear4 Period4 ?ie"4 Entity4 ?alue4 Account4 $CP4 Custo%4 Custo%;4 Cust o%14 Custo%8

 Fields )or the ite%s "ithin a section are deli%ited "ith any o) these characters ( 4 V J  W X U Y Z  I [ \

(89)

0roup $imension &ection

(90)

$ata &ection

(91)

ine Item $etail &ection

(92)

Canging Column Order

peci)ies the order

o) the di%ensions

in the data section

(93)

oading $ata

 5se the Bro"se +utton to identi)y %ultiple data load )iles.

 &he )iles load in seuential order.

(94)

Merge Option

Results o) Load

A Accccoouunntt aalluuee ales :9 Returns ;9 Purchases 19

Application

A Accccoouunntt aalluuee ales 99 Returns ;9

Purchases o Data

Data Load File

A

Accccoouunntt aalluuee

ales :9

(95)

Replace Option

Results o) Load A Accccoouunntt aalluuee ales :9 Returns 9 Purchases 19 Application A Accccoouunntt aalluuee ales 99 Returns ;9

Purchases o Data

Data Load File

A

ales :9

(96)

Accumulate Option

Results o) Load A Accccoouunntt aalluuee ales :9 Returns ;9 Purchases 19 Application A Accccoouunntt aalluuee ales 99 Returns ;9

Purchases o Data

Data Load File

A

ales :9

(97)

Accumulate 'itin File Option

Merge "ith Accu%ulate "ithin File

Replace "ith Accu%ulate "ithin File

Results o) Load A Accccoouunntt aalluuee ales 9 Returns ;9 Application A Accccoouunntt aalluuee ales 99 Returns ;9

Purchases o Data

Data Load File

A

ales :9

ales ^9

(98)

E2tracting $ata

u%+ers in

parentheses

indicate that

%ultiple

%e%+ers

are

selected.

(99)

Copying $ata

&he nu%+er

o) source

and

destination

periods %ust

+e the sa%e.

(100)

Remo!ing $ata

(101)

Entering $ata *sing $ata

0rids

(102)

A(out $ata 0rids

5se data grids to enter4 !ie"4 or edit data %anually in 'yperion Financial Manage%ent.

M

(103)

Accessing $ata 0rids

(104)

Canging te 0rid ayout

(105)

&electing Mem(ers )or $imensions

Clic, to select %e%+ers )or ro"s and colu%ns.

(106)

&electing Mem(ers

A ro" or colu%n

is displayed on

the grid )or each

%e%+er that

you select.

(107)

Mem(er ists

(108)

&a!ing $ata 0rid &ettings

Pri!ate data grids are displayed in

the Docu%ents list o) the users that

created the%.

(109)

Entering $ata

Re)reshes data4 discarding

unsa!ed changes

(110)

(111)

&preading $ata

>ou can spread data )ro% su%%ary periods to +ase periods.

Clic, the su+%it data +utton.

Enter a%ount

in su%%ary

ti%e period.



;

(112)

Calculating $ata

ales  5nitsold 3 Price

(113)

Adding Cell /e2t

Cell te3t can hold up to

appro3i%ately ;999 characters.

(114)

Adding ine-Item $etail

(115)

(116)

A(out Mem(er ists

A %e%+er list is a su+set o) related %e%+ers that +e long to a single di%ension.

Income

+e*ore

&a'e#

(ro## Margin

Intere#t E'pen#e

Admin E'pen#e

&otal !evenue

Sale#

Sale# Interco

&otal %o#t#

Salarie#

Account Di%ension

&otal !evenue

&otal %o#t#

Admin E'pen#e

Me%+er List

(117)

&ystem-$ened Mem(er ists

 yste%=de)ined %e%+er lists group %e%+ers according to co%%on properties4 as in the )ollo"ing e3a%ples ( All children o) a parent %e%+er

( All +ase %e%+ers o) a di%ension

Income +e*ore Income +e*ore &a'e# &a'e# (ro## Margin (ro## Margin Intere#t %$arge# Intere#t %$arge# &otal !evenue# &otal !evenue# Sale# Sale# Sale# Interco Sale# Interco &otal %o#t# &otal %o#t# Salarie# Salarie#

Base Me%+er

List

Sale#

Sale# Interco

Salarie#

Children o)

Parent

Me%+er List

Sale#

Sale# Interco

Intere#t %$g#

Admin E'pen#e

(118)

*ser-$ened Mem(er ists

>ou can create user=de)ined lists custo%i6ed to your application ( tatic %e%+er lists contain speci)ic di%ension %e%+ers.

( Dyna%ic %e%+er lists contain %e%+ers that4 at runti%e4 %eet speci)ic criteria -)or e3a%ple4 all %e%+ers "ith an E3pense account type2.

Income +e*ore Income +e*ore &a'e# &a'e# (ro## Margin (ro## Margin Intere#t %$arge# Intere#t %$arge# Admin E'pen#e Admin E'pen#e &otal !evenue# &otal !evenue# Sale# Sale# Sale# Interco Sale# Interco &otal %o#t# &otal %o#t# Salarie# Salarie#

&otal !evenue#

&otal %o#t#

Admin E'pen#e

tatic

Me%+er List

Dyna%ic

&otal %o#t#

Salarie#

Intere#t %$g#

Admin E'pen#e

(119)

Creating Mem(er ists

>ou create %e%+er lists in a te3t )ile that you load into your application.

>ou include de)initions )or all user=de)ined %e%+er lists in a single )ile.

Me%+er list )iles use ?B script synta3.

Su2 Enum$em2ersIn"is34

I+ )S5Dimension = 6Accoun7 %hen

I+ )S5$em2er"isID=( %hen

)S5A$em2er%o"is 6%oalRe#enues7

)S5A$em2er%o"is 6%oalCoss6

)S5A$em2er%o"is 6AminE8'ense7

En I+

En Su2

(120)

Sub EnumMemberLists()

Dim aEntityLists(2)

Dim aAccountLists(1)

If HS.Dimension = "Entity" Then

aEntityLists(1) = "UnitedStates"

aEntityLists(2) = "Europe"

HS.SetMemberLists aEntityLists

ElseIf HS.Dimension = "Account" Then

aAccountLists(1) = "ProfitAndLoss"

HS.SetMemberLists aAccountLists

End If

End Sub

Identi)ying Mem(er ists in a File

&he Enu%Me%+erLists su+routine speci)ies the nu%+er o) %e%+er lists )or each di%ension and the na%es o) the %e%+er lists )or each di%ension.

Di% state%ents speci)y the nu%+er o)

lists )or each di%ension.

peci)ies a na%e and a

nu%eric $D )or each list

ets the speci)ied

na%es and nu%eric $Ds

(121)

Su2 Enum$em2ersIn"is34

I+ )S5Dimension = 7Accoun7 %hen

I+ )s5$em2er"isID=( %hen

)S5A$em2er%o"is

)S5A$em2er%o"is 7Sales7

7Sales7

)S5A$em2er%o"is

)S5A$em2er%o"is 7SalesInerco7

7SalesInerco7

)S5A$em2er%o"is

)S5A$em2er%o"is 7Purchases7

7Purchases7

)S5A$em2er%o"is

)S5A$em2er%o"is 7PurchasesInerco7

7PurchasesInerco7

En I+

peci)ies

the di%ension

peci)ies the %e%+er

list +y its nu%eric $D

peci)ies the %e%+ers

to include in the list

Creating &tatic Mem(er ists

5se the Enu%Me%+ers$nList su+routine to create +oth static and dyna%ic %e%+er lists.

5se an '.AddEntity&oList state%ent to add a %e%+er to a list )or the Entity di%ension.

(122)

Creating $ynamic Mem(er ists )or te Entity $imension

Dyna%ic %e%+er lists select %e%+ers )ro% a di%ension +ased on criteria that you speci)y.

Criteria are %e%+er properties such as currency or account type.

&he list is generated dyna%ically each ti%e it is accessed +y a user.

I+ )S5Dimension = 7Eni*7 %hen

I+ )S5$em2er"isID=( %hen

E"i=)S5Eni*5"is3779774

For

For i="2oun3E"i4

i="2oun3E"i4 o

o U2oun3E"i4

U2oun3E"i4

I+ 3SrCom'3)S5Eni5De+Currenc3E"i3i449

6USD:9#2%e8Com'are4=04 %hen

)S5AEni*%o"is 779E"i3i4

En I+

Ne8

En I+

Chec,s the currency property o) each %e%+er

Creates an array o) the di%ension %e%+ers

(123)

Creating $ynamic Mem(er ists )or Oter $imensions

&he )ollo"ing synta3 creates a dyna%ic %e%+er list in the Account di%ension )or all accounts "ith asset type  Asset.

A

li=)S5Accoun5"is3779774

For i="2oun3A"i4 o U2oun3A"i4

I+

I+ 3SrCom'3)S5Ac

3SrCom'3)S5Accoun5Accoun%*'

coun5Accoun%*'e3A"i3i4497asse

e3A"i3i4497asse79#2%e8Com'are

79#2%e8Com'are4=04

4=04 %hen

%hen

)S5A$em2ero

)S5A$em2ero"is

"is A"i3i4

A"i3i4

En

En I+

I+

Ne8

Chec,s the account type property o) each %e%+er

Creates an array o) the di%ension %e%+ers

(124)

oading Mem(er ists

(125)

E2tracting Mem(er ists

(126)

(127)

A(out e!els o) &ecurity

&here are )our le!els o) security in 'yperion Financial Manage%ent.

&a#3

#ecurity

Document

#ecurity

Data

#ecurity

Data grids4 data entry

)or%s4 #ournals4

"or,spaces4 and

syste% reports

)#er

aut$entication

(128)

*ser Autentication

 5sers %ust pro!ide a !alid user $D and pass"ord to access an application.

 'yperion Financial Manage%ent le!erages *indo"s user $Ds and pass"ords.

 5ser and groups %ust e3ist in

*indo"s security +e)ore they can +e added to a 'yperion Financial Manage%ent application.

(129)

/as+ &ecurity

>ou can speci)y the tas,s that users and groups are authori6ed to per)or%.

&as,s )or "hich users are not authori6ed are re%o!ed )ro% the %enus4 presenting a custo%i6ed user inter)ace.

&as, security is assigned through user roles.

(130)

$ocument &ecurity

 Docu%ent security is assigned through security classes.

 ecurity classes are a grouping %echanis% )or assigning security aspects to sets o) related %e%+ers4 docu%ents4 or other o+#ects.

Access Le!els )or

ecurity Classes

 All

 Metadata

 Read

 Pro%ote

 one

ecurity class  alaryRelated

Access  All

ecurity class  alaryRelated

Access  All

(131)

$ata &ecurity

 Data security is also assigned through security classes.

 Assign users Read4 Pro%ote4 Metadata 4 or no access to data )or spe ci)ied di%ension %e%+ers .

ecurity Class

 East Region

 *est Region

 5nited _ingdo%

 ingapore

Assigned Access

Le!el

 All

 Read

 Metadata

 one

E3a%ple

(132)

Adding *sers and 0roups

Clic, to open

the Add

5ser/Group

dialog +o3.

Enter a *indo"s do%ain

(133)

A(out &ecurity Roles

ecurity roles deter%ine "hat tas,s a user can per)or% in the application.

(134)

&ecurity Role Categories

Forty=se!en security roles address si3 areas

Application

Le!el

Data

Access

Reports

Manage

Load

E3tract

(135)

Assigning Roles to *sers and 0roups

(136)

Application &ettings and &ecurity

Application

ettings

Entity Di%ension

Ea#t Sale#

-Me%+er Attri+ute2

ecurityClass  5

Account

cenario

$CP

Custo%

Custo%;

Custo%1

Custo%8

5seecurityForEntities  >

5seecurityForAccounts  >

5seecurityForcenario  >

`

ecurity Classes

5

Europe

Australia

`..

(137)

Assigning Access to $ata

and $ocuments

(138)

$ata Access

Access to a data cell is deter%ine d +y the user7s %ost restricti!e %e%+ er access.

Member

Member )#er Acce##)#er Acce## to Member to Member

ales All &otal Costs Read Florida All France one

All / All

All / Read

All / one

Read / one

(139)

$ocument Access

(140)

$ening &ecurity Classes

De)aultb is a syste%=generated security class.

Clic, to add a security

class.

(141)

Assigning Access to &ecurity Classes

(142)

&ecurity oad Files

!USERS.AND.GR-UPS

FINAPPSAminGrou'

FINAPPSChris,

FINAPPSPa$

!SECURI%&.C"ASSES

Cor'orae

US

Euro'e

!R-"E.ACCESS

Aminisraor;)*'erionUser(

"oa Ssem;)'erionAminGrou'

Re#ie/er(;)*'erionUser

!SECURI%&.C"ASS.ACCESS

S*sem;

F$APP\Ad%inGroup

All

22 S*sem;

S*sem;

F$APP

Chris,;Rea

Euro'e;FINAPPSChris,;All

(143)

(144)

(145)

(146)

A(out $ata Entry Forms

>ou can

 Add colu%ns or ro"s )or te3t input.

 Add +lan, ro"s or colu%ns )or spac ing.

(147)

Form "uilder

(148)

$ening te Point o) %ie#

peci)ies the initial !alue )or

the di%ension

peci)ies a %e%+er list )ro%

"hich to select

(149)

(150)

&etting Ro# and Column Options

(151)

Formatting Ro#s and Columns

&he ,ey"ords you type in the tyle and Cust 'eader tyle )ields consist o) one or %ore style properties4 separated +y a se%icolon.

By de)ault4 )or%atting assigned to ro"s o!errides )or%atting assigned to colu%ns.

$nitial se%icolon ena+les

co%+ined ro" and

colu%n )or%atting.

(152)

(153)

&etting Ro# and Column $e)aults

(154)

&etting Heading $e)aults

(155)

(156)

(157)

A(out 'or+spaces

A!aila+le "or,spaces

(158)

Creating 'or+spaces

(159)

Adding Items to 'or+spaces

elect the ite%s that

you "ant to add to the

(160)

(161)

Adding in+s

(162)

Managing 'or+spaces

elect i) you "ant the

current "or,space to

+e displayed "hen you

log on.

Reorder the

"or,space ite%s

(163)

(164)

A(out Intercompany /ransactions

A transaction +et"een t"o entities in an organi6ation is an interco %pany transaction.

East ales

Custo%er

*est Factory

ale

Goods shipped )ro% separate organi6ation

1 

;

$nterco%pany

$n!oice

-&ransaction2

(165)

Intercompany Account "alances

*est ales

Ad%inistration

East

Mar,eting

East

Cali)ornia

Connecticut

Plant

5A

$nterco%pany transactions are captured in interco%pany accounts.

$nterco%pany +alances are not rele!ant )or e3ternal )inancial reporting. According to accounting rules4 interco%pany account +alances are eli%inated prior to e3ternal )inancial state%ent generation.



;

(166)

Elimination Process

5A

RentalRe!enue 9

RentalE3pense 9

Cali)ornia

RentalRe!enue :99

RentalE3pense 9

Connecticut

RentalRe!enue 9

RentalE3pense :99

Plant

RentalRe!enue :99

RentalE3pense 9

ales *est

Eastales

RentalRe!enue 9

RentalE3pense :99

Ad%inistration

East

Mar,eting

East

(167)

Plug Accounts

$nterco%pany Accounts on=$nterco%pany Account

ales = $nterco%pany Purchases = $nterco%pany $ntercoDi))PL

(168)

Intercompany Eliminations

and te %alue $imension

(169)

&etting *p Entities )or Intercompany /ransactions

peci)ies "hether the entity is

displayed as a %e%+er in the

$CP di%ension

peci)ies a security

class )or the entity )or

interco%pany transactions

(170)

&etting *p Accounts )or Intercompany /ransactions

&hese properties need to +e set )or interco%pany accounts

$s$CP

(171)

Ne# Intercompany /ransactions Module in Hyperion Financial

Management

(172)

"usiness Process )or te Intercompany /ransaction Module

@pen $C period

Create $C

transaction

Match $C

transaction

Post $C

transaction

Re!ise $C

transaction i)

needed

$C  $nterco%pany

Generate

%atching

reports

Per)or% drill

through )ro%

account +alance

(173)

Intercompany /ransactions &etup Considerations

&he )ollo"ing needs to +e considered as part o) the setup )or the $nterco%pany &ransactions %odule

$C periods %ust +e open.

$nterco%pany transaction rules %ust +e de)ined in the rules )ile and loaded into the application -error %essage results i) rules are not de)ined2.

caling ( &he scaling )actor a))ects the display o) the transaction a%ount.

Matching tolerances need to +e deter%ined.

Reason codes need to +e de)ined.

(174)

Open Intercompany Periods

(175)

Creating Intercompany /ransactions

&ransactions can +e entered %anually or loaded )ro% a )ile.

O!

(176)

Matcing Intercompany /ransactions

Question *hy do "e %atch interco%pany transactions[

_{Ans"er Matching helps reduce the ga p that can e3ist +et"een interco%pan y account +alances .}

Entity A

Entity B

Accts. Recei!a+le $nterco%pany

:99

Accts. Paya+le $nterco%pany

:99

(177)

Intercompany /ransaction Matcing Metods

 Auto%atic %atching +y transac tion $D4 re)erence $D4 or account "ith or "ithout tolerance a%oun t

Manual %atching "ith or "ithout tolerance a%ount

Auto%atic

Manual "ith tolerance

Manual "ithout tolerance

4 -5 )SD

(178)

-Posting Intercompany /ransactions

$nterco%pany transactions %ust +e posted in order to +e included in an account +alance.

 A)ter a transaction is posted4 no c hanges can +e % ade to it.

$) changes are needed to a posted transaction4 you %ust un=post it4 %a,e the changes4 and then re=%atch and re=post the transaction.

755 )SD

$n! 99

99

$n! 99;

199 ====

899 $n! 991

:99

====

099

(179)

0enerating Matcing Reports

 Generate %atching reports +y

 Account  &ransaction $D  Re)erence $D

Recei!a+les = $nterco

:99

Paya+les = $nterco

:99

&ransaction $D

Re)erence $D

(180)

$rill-/roug Reports

(181)

oc+ing Entities

(182)

Closing Intercompany Periods

*hen a period is closed4 no interco%pany transactions can +e entered.

(183)

(184)

A(out 1ournals

*hy use Oournals !ersus data grids or data entry )or%s[

>ou can

Create recurring #ournals that repeat )or a nu%+er o) )uture periods.

Create auto=re!ersing #ournals that generate an auto%atic re!ersing entry in the )ollo"ing ti%e period.

5se the appro!al process )or #ournals to pro!ide accounta+ility.

Account

Balance

Oournal

Ad#ust%ents

Ad#usted

Account

Balance

(185)

1ournal *ses

Oournals are used to record ad#ust%ents o) %any types

Reclasses

Entry Corrections

Re!ersals

 Accruals

Minority interest accounting entries

Eli%ination ad#usting entries

&rue 5ps

(186)

$ata Ad3ustments #it Audit /rail

Account

Balance

Ad#usted

Account

Balance

Oournal

Ad#ust%ents

5ser

 Accounts

Entities

Period

(187)

1ournal Re!ie# Process

Post the #ournal

Recei!e the appro!al

u+%it the Oournal

_{)or appro!al}

Create a #ournal

Re!ie" and appro!e #ournal

enior Accountant or Financial Analyst

Accounting Manager or Controller



(188)

1ournals and te %alue $imension

Entity CurrencyN

Entity Currency Ad#sN

Entity Currency &otalN

:99

=<:

8;:

?alue entered in data entry )or%

?alue posted )ro% #ournal

Ad#usted !alue rolled up to parent

(189)

Multiple 1ournal Postings

Postings )ro% %ultiple #ournals are cu%ulati!e.

Oournal A

=99

Oournal B

;:

Entity CurrencyN

Entity Currency Ad#sN

Entity Currency &otalN

:99

=<:

8;:

(190)

Parent Ad3ustments

>ou can %a,e a parent ad#ust%ent to *estales

that a))ects only aleser!ices or only Cali)ornia.

>ou select "hich parent is a))ected +y

(191)

(192)

Accessing 1ournals

(193)

Creating 1ournal /emplates

P@?

Oournal &e%plate

Description

Reclass +alances

Accounts

$nterest E3pense

C..C8

A%ounts

De+it

Credit

et up

in ad!ance

Entity

(194)

1ournal "alance /ypes

De+it

Credit

:99

Balanced

De+it

Credit

:99

199 5n+alanced

Balanced +y Entity

De+it

Credit

:99

Entity

De+it

Credit

899

899 Entity

(195)

&etting te Point o) %ie#

et the point o) !ie" +e)ore you create a #ournal.

5se this

+utton to

create a

#ournal.

(196)

Creating 1ournals

De#cription De#cription Account# Account# Amount# Amount# !ecla## +alance !ecla## +alance Intere#t E'pen#e Intere#t E'pen#e %-99%: %-99%: D

Deebbiitt %%rreeddiitt

Blan, Oournal

Oournal &e%plate

De#cription De#cription Account# Account# Amount# Amount#

(197)

Entering 1ournal $ata

(198)

(199)

1ournal Re!ie# Process

Accountant

or

Financial

Analyst

Accounting

Manager

/uper!isor

tatus u+%itted

@R

tatus

Appro!ed

tatus

Re#ected

Oournal tatus

*or,ing

$) Appro!ed4 user

can post #ournal

1 

;

(200)