Hema
Hema
nth
nth
Kumar
Kumar
Hyperion
Hyperion
Financial
Financial
Management
Management
Interview
Interview
Questions
Questions
&
&
Answers
Answers
1.1. What is HFM?What is HFM? An
Ans: s: OraOracle cle HyHyperperion ion FinFinancancial ial ManManageagemenment t is is a a finfinancancial ial conconsolsolidaidatiotion n and and repreportortinging application built with
application built with adanced Web technologyadanced Web technology. !t proides financial managers the . !t proides financial managers the ability toability to rapidly consolidate and report financial results" meet global regulatory re#uirements" reduce rapidly consolidate and report financial results" meet global regulatory re#uirements" reduce t
thhe e ccoosst t oof f ccoommpplliiaanncce e aannd d ddeelliieer r ccoonnffiiddeenncce e iin n tthhe e nnuummbbeerrss..
$.
$. How many standard dimensions are there in How many standard dimensions are there in HFM?HFM? Ans. %here are 1$ standard dimensions in HFM.
Ans. %here are 1$ standard dimensions in HFM.
&.
&. How do you create members in HFM?How do you create members in HFM?
Ans: 'sing manage metadata" we create child or sibling. Ans: 'sing manage metadata" we create child or sibling.
(.
(. How do you create !)* members in HFM?How do you create !)* members in HFM?
Ans: !)* members are not created by us directly. !n Account+,ntity dimension" if we Ans: !)* members are not created by us directly. !n Account+,ntity dimension" if we chec-!s!)*" then the system will consider the member as an !)* member.
!s!)*" then the system will consider the member as an !)* member.
.
. ,/plain about ,nity curr ad0 member in HFM,/plain about ,nity curr ad0 member in HFM Ans: We gie entity currency ad0ustments to *O
Ans: We gie entity currency ad0ustments to *O when we are loading when we are loading 0ournals.0ournals.
2.
2. What are rules used for? How many rules an application can hae?What are rules used for? How many rules an application can hae? An
Ans. s. 3u3uleles s arare e usused ed to to auautotomamate te ththe e cacalclcululatatioions ns of of dadata ta wiwiththin in an an apapplplicicatatioion. n. AnAn application can hae
application can hae 3ules are used to: 3ules are used to:
•
• )alculate data entry leel amounts for a )alculate data entry leel amounts for a specific entity" scspecific entity" scenario and period.enario and period.
•
• *reent data entry for a *reent data entry for a specific cell in specific cell in a specific entity" scenaa specific entity" scenario and period.rio and period.
•
• Allow input at the parent entity leel.Allow input at the parent entity leel.
•
• )alculate data that cannot be calculated through a hierarchical aggregation such as ratios)alculate data that cannot be calculated through a hierarchical aggregation such as ratios
or ariance analysis. or ariance analysis.
•
• *erform alloca*erform allocations from a parent entity to a tions from a parent entity to a list of base entities.list of base entities.
•
• *er*erform form complcomple/ e/ currcurrency ency conconersioersions" ns" calccalculatulate e e/che/change ange ratrate e diffedifferencrences es or or perfperformorm
other calculations necessary for your
other calculations necessary for your consolidation.consolidation.
•
• 4efine formulas to 4efine formulas to dynamically calculate accounts.dynamically calculate accounts.
•
6.
6. What is application profile" can we change application profile at any point of What is application profile" can we change application profile at any point of time?time?
Ans. An application profile contains language" calendar" fre#uency" and period information Ans. An application profile contains language" calendar" fre#uency" and period information
fo
for r an an ApApplplicicatatioion. n. 7o7o" " apapplplicicatatioion n prprofofilile e ononce ce crcreaeateted" d" cacannnnot ot be be chchanangeged.d.
8.
8. What are custom top members?What are custom top members?
)ustom top member is a member of Account 4imension" where we hae to mention which )ustom top member is a member of Account 4imension" where we hae to mention which top member in the hierarchy of a custom dimension is alid for the account. Only the top member in the hierarchy of a custom dimension is alid for the account. Only the specified member"
specified member" including all descendants" is including all descendants" is alid for the alid for the account.account.
9.
9. What is the 7ode What is the 7ode security?security?
Ans: 7ode security is a member in Application 5ettings. %here are $ parameters entity Ans: 7ode security is a member in Application 5ettings. %here are $ parameters entity leel+parent leel. !f we mention entity leel. 5ecurity is gien at the node leel. !f we leel+parent leel. !f we mention entity leel. 5ecurity is gien at the node leel. !f we mention parent leel" security is gien at parent leel ;including its children<.
mention parent leel" security is gien at parent leel ;including its children<.
1=.
1=. What is data audit in HFM?What is data audit in HFM?
Ans: 4ata audit feature is used to iew data changes performed by users. We can filter the Ans: 4ata audit feature is used to iew data changes performed by users. We can filter the data changes by date range" application serer"
data changes by date range" application serer" user and the dimension user and the dimension members of cells.members of cells. ;,na
;,nable4able4ataAudtaAudit it metametadata data attriattribute bute is is aaaailablilable e in in 5cen5cenario ario and and AccoAccount unt dimendimensionssions.<.<
11.
11. How to get How to get *rior year retained earnings %hrough History data?*rior year retained earnings %hrough History data? Ans: We need to write a rule for it.
Ans: We need to write a rule for it.
1$.
1$. What are different ways of running consolidation in HFM? What are different ways of running consolidation in HFM? )on
)onsolsolidaidate te wilwill l coconsonsolidlidate ate onlonly y whawhat t hahas s chchanganged ed frofrom m the the prepreioious us e/ee/ecucutiotion n of of consolidation" including the e/ecution of
consolidation" including the e/ecution of all necessary calculations and currency translationsall necessary calculations and currency translations f
foor r iinnddiiiidduuaal l eennttititiiees s ;;tthhe e oonnees s tthhaat t hhaae e tthhe e iimmppaacctteed d ssttaattuus s oof f ccoouurrssee<<
)onsolidate All will consolidate eerything whether changed or not as if it has neer run )onsolidate All will consolidate eerything whether changed or not as if it has neer run be
befoforere. . !t !t wiwill ll alalso so ininclcludude e in in e/e/ececututioion n enentittities ies fofor r whwhicich h ththerere e is is no no dadata ta at at alall.l.
)onsolidate All with data will consolidate eerything whether changed or not but it will s-ip )onsolidate All with data will consolidate eerything whether changed or not but it will s-ip entities haing no data.
entities haing no data.
1&.
1&. What is cash flow statement? What is cash flow statement? An
Ans: s: )as)ash h floflow w stastatemtement ent is is aa finafinancial ncial statstatementement ththat at shshowows s hohow w chchanangeges s inin balancebalance
sheet
sheet accounts and income affect accounts and income affect cash and cash e#uialentscash and cash e#uialents" and brea-s the analysis down" and brea-s the analysis down to
to operoperatinating" g" ininestinesting" g" and and finafinancing actiitiencing actiities. s. ,sse,ssentialntiallyly" " the the cash flow cash flow statestatement isment is concerned with the flow of cash in and out
1(. What does an income statement contain ;3ough outline<?
Ans: !t is a financial statement that measures a company>s financial performance oer a specific accounting period.
1. What does a balance sheet contain?
Ans: A balance sheet is a financial statement that summaries a company>s assets" liabilities @ shareholder>s e#uity at a specific point of time.
12. )an ! use any other rates other than agrate and ,OMrate in translation in HFM? Ans: Bes" we can use historical rate. We can use historical rate to conert some assets to historical alue.
16. What is the minimum role to be gien to a user to access HFM? Ans: 4efault or iew access.
18. Where do you gie roles to user? Ans: !n 5hared 5erices.
19. How do we -now whether consolidation has been run for a particular entity or not in a particular month?
Ans: Co to process management 5elect specific entity )onsolidation Bes or 7o. $=. What are the combinations to enter e/change rates?
Ans: From customer 1 and customer $" there is a system defined member list called currency. 5o" in customer 1" we are going to hae source currency and in customer $" we hae destination currency.
$1. ! don>t want an account to get translated" what account type should be used? Ans: %here is no relation between account type and translation.
$$. )hild entities hae data" but there is no data in parent entity? What could be the reason?
Ans: *arent account type is DCroup Eabel>
$&. 7ot able to create 0ournals for an entity" what options do you chec-? Ans: Allow ad0s is enabled or not.
Ans: A member list can be created and used for a ariety of actiities: data e/tracts" data grids and Forms" rules" and filtering when selecting members. Member lists enable you to specify a segment of information within a dimension.
$. What is Eine !%,M detail in HFM? How to enter it?
Ans: Eine !tem details are additional information to the data. !t is entered in the data file. $2. )an ! display line item details in any report?
Ans: 7o
$6. What are the differences between data grid and data form?
Ans: ;a.< *O is not restricted in data grids @ *O is restricted in data forms. ;b.< We can print the form in data form but we don>t hae it in data grid.
;c.< We can e/port the data form to the e/cel file and import file and we can bring bac-the changes to bac-the 4. %his is called offline wor-ing on data forms.
$8. How do you achiee closing process in HFM?
Ans: We are going to handle through process management. $9. Where is data stored in HFM?
Ans: 34M5.
&=. How do you ta-e bac-up of HFM applications?
Ans: 'sing copy in utilities. %his is aailable under HFM utilities. We can copy eerything e/cept data.
&1. How do you migrate HFM application from one enironment to another? Ans: 'sing copy application in utility or E)M ;Eife cycle management<.
&$. How to set dimensions in HFM?
Ans: We are not going to set dimensions till 11.1.$.1 ersion. We hae 1$ standard dimensions.
&&. How many types of account?
Ans: %here are 1= account types Asset" liability" reenue" e/pense" balance" balance recurring" flow" dynamic" group label" currency rate.
&(. What is mean alue dimension?
Ans: %he alue dimension represents the types of alues stored in your application" and can include the input currency" parent currency" ad0ustments" and consolidation detail such as proportion",limination" and contribution detail.
&. Where is the translation done?
Ans: %ranslations can be done in data grid" data forms and at process management leel. &2. What is meant by switchsignflow and swiitchsigntype?
Ans:
Switchsignforflow:
5pecifies sign change ;4ebit or )redit< for FEOW accounts that use these rules:
1. A55,% to E!A!E!%B 2. E!A!E!%B to A55,% 3. ,G*,75, to 3,,7', 4. 3,,7', to ,G*,75, 5. AEA7), to FEOW 6. FEOW to AEA7), Switchtypeforflow:
5pecifies the account type change for FEOW accounts that use these rules:
1. A55,% to ,G*,75, 2. ,G*,75, to A55,% 3. E!A!E!%B to 3,,7', 4. 3,,7', to E!A!E!%B 5. AEA7), to FEOW FEOW to AEA7), &6. What is !)*?
Ans: %he !nter company dimension represents all intercompany balances that e/ist for an account. %his is a resered dimension that is used in combination with the Account dimension and any custom dimension.
&8. How to setup !)*? B means what? 7 means what? 3 means what? Ans: !n account+entity dimension" we hae an attribute list as !s!)*. BBes
77o
3 Bes A74 the entity cannot use itself as !)*. &9. What is meant by plug account?
Ans: %he plug account specifies the account name used for identifying discrepancies in intercompany transactions. %he *lug Acct attribute is re#uired when the !s!)* attribute for the account is selected. !t must be blan- or the name of a alid account. !f blan-" intercompany eliminations for the account are not processed.
(=. How many types of rule?
Ans: %here are 8 types of rules )alculate" %ranslate" )onsolidate" Allocation" !nput" 7o !nput" 4ynamic" %ransactions.
(1. What is meant by reiew process in HFM?
Ans: *rocess management is otherwise called as reiew process. ($. How to enable process management in HFM?
Ans: Coto *rocess )ontrol 5tart *rocess management. (&. 4efine period dimension?
Ans: %he *eriod dimension represents time periods" such as #uarters and months. !t contains time periods and fre#uencies by displaying the time periods in a hierarchy.
((. How to enable data audit?
Ans: We can enable data audit by chec-ing Denable data audit> attribute in account and scenario dimension.
(. ,/plain organiation by period?
Ans: Organisation by period will allow you to maintain the hierarchies for different roll ups. (2. !f entity / currency ,uro" and entity y currency '54" means to see in dataform" which dimension is set in *O?
Ans: alue @ entity dimension.
(6. What alue dimension set for 0ournal entry? Ans: ,ntity currency ad0ustment
(8. Write a rule to enter alue for particular account? Ans: We need to write input rule.
(9. !f we create user for 0ournals" then user can post 0ournal" suppose user can do unpost for 0ournal?
Ans: Bes" only if the user has admin access.
= . How can we see the icp without using data form and grid Ans: 'sing !)* 3eport.
1. What is HFM serices you go to start? Ans: HFM 4M, Eistener
Hyperion Foundation Open E4A*
Hyperion Wor-space Agent Application Hyperion Wor-space Web Application
$. What is meant by alidation rule and how to set?
alidation rules define the alidation rule group. %he rule table comprises of 4isplay alue" 4escription" 3ule 7ame" 3ule %e/t" %ype" )ategory" 5e# and 3ule Eogic.
alidation 3ule Croup!t contains a set of administrator defined rules that perform chec-s and balances against the target system.
&. How to connect the source with smartiew?
Ans: We can connect to any data source listed in )onnection Manager. )onnecting to a data source enables you to retriee data into ,/cel.
➤ %o connect to a data source:
1. 5elect Hyperion I )onnection Manager. For Office $==6" clic- )onnect in the )onnections section of the Hyperion ribbon.
$. )onnecting to a 4ata 5ource &6$ !n )onnection Manager" select the data source to which you want to connect and clic- )onnect.
&. !n the )onnect to 4ata 5ource dialog bo/" enter the user name and password for the data source.
(. )lic- )onnect.
. )lic- )lose to close )onnection Manager. (. HFM architecture?
Financial Management is designed to operate as a multi tier system.
1. %he client tier contains the user interface and the ability to communicate with the application tier. Bou can display data and metadata" enter data" and maintain metadata in this tier.
$. On the Web serer tier" you access the Webenabled portions of Financial Management. &. %he middle tier contains the domain intelligence and connections to the relational database. (. %he data tier contains the relational database and all Financial Management data and
metadata.
Hyperion Financial Management Interview Questions & Answers Part-2
Questions to Ask at the Informational Interview
You have arrived and are greeted by the individual at the front desk. When the interviewee comes out to meet you, introduce yourself. Thank your contact for his or her willingness to meet with you, and re-emphasize that you are there to learn and gather information about his or her career field. Use an informal dialogue during the interview.
Below are some typical informational-interview questions. Remember that you won't have time to ask anywhere nearly all of these questions, so taret the ones you feel will be most useful to you personally. !ick a "o#en or so that et at what you most want to know.
1. Wat is a !ecurring "ournal#
$ome "ournals we use repeate%ly. $o 'or tat purpose we will create recurring templates. (y using te recurring templates we will create recurring "ournals.
2. Wat is an Auto !eversing "ournal#
I' we create a )ournal as Auto !eversing "ournal te )ournal will post in te ne*t perio% +y reversing te ,e+it an% re%it.
. How will you per'orm urrency /ranslations#
First we ave to create0%e'ine all te currencies in te Meta ,ata Item calle% currencies. /en we ave to per'orm currency translations in *plore %ata mo%ule +y using custom %imensions an% value %imension.
. How will you per'orm !eview Process#
/o per'orm !eview process we soul% ave te 3!eview $upervisor4 $ecurity autority. In *plore ,ata Mo%ule we will per'orm Process Management.
5. $ometimes we cannot post a "ournal. Wat will +e te !eason#
In ntity ,imension we soul% cec6 te 3allow a%)ustment 3property. An% te perio% in wic we create% te )ournal soul% +e 6ept open. An% we soul% ave te security autority to create )ournals.
7. Wat is onsoli%ation#
onsoli%ation is aggregating te (ase level entities amounts wit te Parent level entities amounts.
8. How %o we Migrate application 'rom server to server#
We migrate application wit copy application utility. Anoter way o' migrating application is tra%itional way tat is e*tract all re9uire% 'iles 'rom %evelopment an% loa% same 'iles in pro%uction
:. How %o you ena+le !ules to customi;e consoli%ation# Application $ettings -< consoli%ation !ules -< =
>. Wat is /ranslation#
It is urrency translation appens wen a parent entity?s %e'ault currency is %i''erent 'rom a cil% entity?s %e'ault currency. !uns wen you coose /ranslate or onsoli%ate.
1@. Wat is A%)ustment#
A%)ustment is to correct te %ata. It is %one +y "ournals at value %imension mem+er ntity currency A%)s an% Parent curr A%)s.
11. Wat is te %i''erence +etween consoli%ate consoli%ate all an% consoli%ate all wit te %ata#
Consolidate: only entities tat re9uire logic or consoli%ation are up%ate% +y te system. Consolidate All with Data: option is availa+le 'or any parent entity regar%less o' its status. B,A/A are s6ippe%.
Consolidate all: any Parent entity regar%less o' its status. B,A/A are also consoli%ate%. 12. How can you cancel consoli%ation#
HFM We+ client -< A%ministration -< running /as6s -< clic6 on te !e% +utton 1. Wat is IP#
/e Intercompany Partnersip ,imension provi%es an e''icient way to i%enti'y report an% reconcile intercompany account %i''erences. Wit te a+ility to view %etail transaction at any time you can reconcile intercompany account %i''erences 're9uently an% tus minimi;e teir impact on te closing cycle.
1. =ou are not a+le to loa% IP transactions. Wat is te !eason# Cause: I Perio% is not opene%.
*pan% /as6s an% select I /ransaction /as6s. $elect Manage I Perio%s. From te $cenario %rop-%own list select a scenario 'or te perio%. From te =ear %rop-%own list select a year 'or te perio%. $elect te cec6 +o * ne*t to eac perio% tat you want to open. 15. Wat is CM utility#
CM means Ci'e cycle management wic is in sare% services. It is use% to migrate con'iguration an% arti'acts.
DoteE we cannot migrate %ata wit CM 17. Wat is /olerance amount#
/olerance amount is small %iscrepancies in te amounts in Intercompany /ransactions. 18. Wat are te types o' consoli%ation an% meto%s o' consoli%ation#
1. Cegal onsoli%ation 2. Geograpical onsoli%ation . onsoli%ation +y entity Methods: 1. onsoli%ate 2. onsoli%ate all
. onsoli%ate all wit %ata
1:. Wat is te %i''erence +etween switc sign 'or an% switc type 'or an% in wic %imension it e*ists#
It e*ists in custom %imension
Switch sign for: It is tic6e% to cange A$$/ to CIA(ICI/=
CIA(ICI/= to A$$/ P$ to !JK !JK to P$
Switch type for: It is tic6e% to cange A$$/ to P$ P$ to A$$/ CIA(ICI/= to !JK !JK to CIA(ICI/= (ACA to FCBW FCBW to (ACA
1>. Wat is %ynamic mem+er list#
As %imension mem+ers are a%%e% an% %elete% te %ynamic mem+er list automatically re'lects te canges +y reapplying te user-%e'ine% criteria.
2@. Wat are te +alance types o' "ournals# (alance%
Kn (alance%
(alance% +y entity
21 ,i''erence +etween tem#
Balanced: All te ,e+its an% re%its will +e +alance% Unbalanced: ,e+its an% re%its will not +e +alance%
22. Wat is %ata loc6#
A user-controlle% mecanism tat prevents canges to %ata accor%ing to speci'ie% criteria suc as perio% or scenario
2. How %o you loc6 te %ata#
$elect Coc60Knloc6 I ntities an% $elect $cenario perio% year an% clic6 loc6 2. How %o you eliminate intercompany transactions#
Intercompany transactions are eliminate% troug plug account. $tepsE
reate plug account in account %imension
/ic6 te cec6 +o* calle% I$ IP in account %imension /ic6 te cec6 +o* calle% I$ IP in ntity %imension Coa% te IP rule 'ile.
/en automatically te %i''erence +etween te Intercompany transactions will +e trans'erre% to plug account
25. Wat is triangulation#
A means o' converting +alances 'rom one currency to anoter via a tir% common currency. In urope tis is te euro 'or mem+er countries. For e*ample to convert 'rom Frenc 'ranc to Italian lira te common currency is %e'ine% as uropean euro. /ere'ore in or%er to convert +alances 'rom Frenc 'ranc to Italian lira +alances are converte% 'rom Frenc 'ranc to uropean euro
/riangulation means %oing translation 'rom source currency to any currency oter tan %estination currency.
*ampleE
I' u ave K$, K!B & = our source currency is K$, & %estination currency is = i' u want to translate 'rom K$, to K!B system will translate 'irst 'rom K$, to = & ten = to K!B in reverse manner.
27. $ervices %epen%ency means#
Hyperion is %epen%ent on services. Means services are to +e starte% in a speci'ie% se9uence only
28. How %o you loa% te %ata into HFM#
HFM %irectly cannot ta6e te %ata 'rom !P pac6ages. $o te %ata soul% +e %ownloa%e% 'rom !P an% loa%e% into Kpstream tool li6e F,M an% B,I etc. /en it soul% +e mappe% wit HFM. An% ten loa% tat into HFM.
2:. Wat is HFM A!HI//K!#
Hyperion Financial Management is %esigne% to operate as a multi tier system. Client tier:
/e client tier contains te user inter'ace an% te a+ility to communicate wit te application tier. =ou can %isplay %ata an% meta%ata enter %ata an% maintain meta%ata in tis tier.
Web tier:
/e We+ server tier contains te We+ server. =ou can access te We+-ena+le% portions o' Hyperion Financial Management in tis tier. /e Hyperion Financial Management We+ client contains all 'unctionality availa+le in te Win%ows client wit te e*ception o' security a%ministration.
Middle tier:
/e mi%%le tier contains te %omain intelligence an% connections to te relational %ata+ase.
Database tier:
/e %ata tier contains te relational %ata+ase an% all Hyperion Financial Management %ata an% meta%ata.
2>. How many Account types in HFM#
We ave 1@ Account types in HFM DPlease re'er Account %imension in Meta%ata @. How %o ,i''erent ell olors in%icate in HFM# DAs6 any speci'ic color#
Blue- Hea%er cell
Off White -An input cell. =ou can manually enter or e%it %ata. ight !ellow -Coc6e% or %erive% cell
ight "ray Te#t -o write or !ea% access or may +e %erive% %ata Dar$ !ellow-In%icates one o' tese con%itionsE
L ell %ata as +een mo%i'ie% +ut as not +een save%
L /e input status is B +ut te status o' te a%)ustment is not B DH or /!
ight "reen -Allows allocations an% %erive% %ata Dar$ "reen -!ea%-only
Orange -Invali% PBJ DPoint o' Jiew intersection
2. Wat are te %imensions in HFM#
/otal we ave 12 %imensions in HFM : stan%ar% %imensions an% custom %imensions up 11.1.121 Jersion
: $tan%ar% %imensions
ustom %imensions names are not stan%ar%. . A+out te Jalue ,imension.#
In value %imension tere are two type o' mem+ers one is system %e'ine% wic you 'in% in +rac6ets an% anoter one is user %e'ine% wenever we %e'ine a currency te system will automatically creates value %imensions +ase% on one particular currency enter +y te user.
I' you o+serve ere K$, +ase% on K$, system will create K$, K$, a%) K$, total. tis is e9ual-ant to entity currency entity currency a%) entity currency total. entity currency a%) 'or a%)ustments li6e )ournals an% entity currency total N entity currency - entity currency a%).
. How many types o' a%)ustments we can post.# In HFM we aveE
ntity urrency A%)s Parent urrency A%)s Parent A%)s
ontri+ution A%)s
5. "ournal review ProcessE 1. reate )ournal
2. $u+mit te )ournal
. Post )ournal
7. Wat is no%e security#
(y giving no%e security we can restrict user 'or seeing te value %imension mem+ers
IF you set no%e security as parent only te mem+ers o' te value %imension 'rom Ontity urrency<up to an% inclu%ing OParent urr /otal< are visi+le.
I' you set no%e security as ntity all mem+ers o' te value %imension woul% +e visi+le 8. How many level o' security in HFM#
1 Kser autentication 2 /as6 securities
,ocument securities D,ata gri%s an% 'orms )ournals reports ,ata security
:. How many plug accounts we can create#
In HFM we can create num+er o' plug accounts +ut +ase% on re9uirement we will create te plug accounts 'or elimination process.
>. How many %imensions are system %e'ine% an% ow many %imensions are user %e'ine% an% wat are tey#
At te time o' application pro'ile creation +ase% te %ata enter +y us...
I' you o+serve in a+ove screen i' we cec6 inclu%e Hal' years Inclu%e Quarters Inclu%e monts te system will generate te perio% %imension mem+ers as well as view %imension mem+ers li6e =/,H=/,Q/,M/, an% also 12 perio%s will +e create% automatically. An% in te +ottom +ase% on te staring year an% num+er o' years te system will create te =ear %imension mem+ers.
$o %imension mem+ers Jiew Perio% =ear will +e create% +y te system an% remaining %imension mem+ers will +e create% +y te consultants.
+ecause o' tis reason you can not a+le to see tese %imensions un%er manage meta-%ata.
@. How many Access Cevels 'or $ecurity lasses in HFM 1 All
2 Meta%ata !ea% Promote 5 one
Goo%will in 'inancial statements arises wen a company is purcase% 'or more tan te 'air value o' te i%enti'i a+le net assets o' te company. /e %i''erence +etween te purcase price an% te sum o' te 'air value o' te net assets is +y %e'inition te value o' te goo%will o' te purcase% company. /e ac9uiring company must recogni;e goo%will as an asset in its 'inancial statements an% present it as a separate line item on te +alance seet
2. wat is BA#
BA is noting +ut cart o' accounts wat ever te mem+ers we will %e'ine un%er te account %imension will +e calle% some times cart o' accounts DBA
. Wat are te types o' te reports use% in your pro)ect. wat %oes eac report contain in +rie'#
!eports are not speci'ic it will +e create% as per client re9uirements
*ampleE Forecast +oo6 Au%it +oo6 in eac +oo6 a lmost +alance seet income statement cas 'low statements will +e tere.
. How many instances ave you use% in your pro)ect# nvironment li6e ,evelopment testing pro% uction
5. We soul% not give te security 'or te +elow ,imensions DWe can give remaining > %imensions
1. =ear 2. Perio%
. Jiew
7. wat is Hyperion Ci'e ycle managementDCM#
Ci'ecycle management is a component o' $are% $ervices tat provi%es a mecanism o' moving arti'acts 'or e*ample copying o' we+ %ata entry 'orms 'rom one application to anoter.
In prior versions Dprior to 11 versions items re9uire% e*tracting an% loa%ing. /e a+ility to use Ci'ecycle Management is controlle% via a uni9ue role 'or wic te user must +e provisione%
Please see te +elow screen 'or you re'erence.
8. *plain a+out mem+er attri+utes#
Mem+er attri+utes are %i''ere% 'rom %imension to %imensionR every %imension mem+er will +e aving importance to teir respective areas
:. Wat is alternative ierarcy#
For %i''erent reporting purposes we will create alternative ierarcies in alternate ierarcy one mem+er can +e sare% +y more tan one parent +ut te %e'ault parent will +e only one.
>. na+le Meta%ata $ecurity Filtering
/is setting speci'ies weter users o' an application see all %imension mem+ers or only tose to wic tey ave access. DMeans we can see te meta%ata particular entity only wic we ave rigt
,ata is store% at te cells 'orme% +y te intersection o' te mem+ers o' te %i''erent %imension mem+ers in te su+ cu+e. All aggregations an% calculations are per'orme% on %ata in su+ cu+es retrieve% into !AM on te application server
An% I ope te %ata also +e availa+le in te %ata+ase server. 51. How %o you retrieve %ata 'or your pro)ect0applications#
Financial Management retrieves %ata 'rom te Financial Management %ata+ase in +loc6s calle% su+ cu+es.
$ee te +elow 'or your re'erence.
/e mo%e o' retrieving will +e troug %ata 'orms %ata gri%s or smart view. In smart view we will use H$.Get 'unction to retrieve te %ata.
52 HBW %o you create mem+ers list in HFM#
Mem+er list we can write wit te 'unction calle% list an% we will save wit e*tension .lst once you uploa%e% te mem+er list you can select te mem+er in a particular PBJ wor6ing wit %i''erent areas li6e )ournals IP etc. we can also create our own custom mem+er list 'or %i''erent purposes.
5 How %o you create IP mem+er in HFM#
Following are system %e'ine% mem+ers 'or IP %imension. SIP /opT $peci'ies te top intercompany mem+er
SIP oneT $peci'ies tat no intercompany mem+er is use%
SIP ntitiesT $peci'ies te entities tat are %esignate% 'or intercompany transactions
/e $ystem will automatically creates a IP mem+er wen you select te IsIP attri+ute see te +elow 'or your re'erence.
Wen you create an application Intercompany Partner mem+ers are automatically create% 'or te application. An IP mem+er is create% 'or eac ntity mem+er 'or wic te IsIP attri+ute is selecte%.
oteE
=ou can mo%i'y only te %escription an% security class 'or IP mem+ers. All oter attri+utes are pre%e'ine% an% cannot +e mo%i'ie%
5 PCAI a+out ntity urr a%) mem+er in HFM#
(asically value %imension mem+ers are inter-relate% wit so many areas in HFM +ut in +rie' tal6ing a+out ntity urr A%) you can ma6e any a%)ustments using )ournals into tis particular value %imension ere you can per'orm caluclate an% posting )ournals.
55 Wat are te rules use% 'or# How many rules an application can ave#
!ules is one o' te area wic ma6es HFM application more 'le*i+le wit te custom proce%ures or consoli%ation etc.
we ave : su+routines in rules an% un%er eac su+routine tere will num+er o' 'unctions wic ma6es rules simpli'y
alculation /ranslation onsoli%ation Allocation Input Icp o Input ,ynamic
57 Wat is application pro'ile can we cange application pro'ile at Any point o' time#
An application pro'ile contains language calen%ar 're9uency an% perio% in'ormation 'or an application. =ou can use a pro'ile 'or more tan one application. For eac application tat you create you must speci'y an application pro'ile.
=ou can not mo%i'y te application pro'ile once it was create%.
58 wat are custom top mem+ers# /e ustom top mem+er 'or te account
/e speci'ie% mem+er inclu%ing all %escen%ants is vali% 'or te account
5: WHA/ is te no%e security i' we put te yes or no in te no%e security wat will appen# DIn entity scenario
We can coose a parent or an entity 'or no%e security i' you select eiter o' one.
/en you will +e a+le to see te value %imension mem+ers wic upper to parent urr a%) normally up to parent curr a%) we can a+le to see witout no%e security.
5> Wat is %ata au%it in HFM#
=ou can use te ,ata Au%it 'eature to view %ata canges per'orme% +y users. =ou can 'ilter te %ata canges +y %ate range application server user an% te %imension mem+ers o' cells.
=ou can au%it $cenario an% Account mem+ers +y setting te na+le ,ata Au%it meta%ata attri+ute to = 'or te scenarios an% accounts to au%it. /o turn o'' au%iting o' $cenario an% Account mem+ers cange te na+le ,ata Au%it attri+ute to .
7@ wat is minority interest in HFM#
!elates to ownersip management it will arrive% + y te 'ormula PMI N PB-PBW
Percent o' minority interest is e9ual to Percent o' consoli%ation minus percent ownersip. 71 How to get prior year retaine% earnings#
(y using rules we can acieve it
72 e*plain some rules you ave use% in your pro)ect# an say consoli%ation calculation IP etc.
7 wat are %i''erent ways o' running consoli%ation in HFM# Manual consoli%ation +y using gri%s.
onsoli%ation using tas6 automation ustom consoli%ation +y using rules.
75 Wat %oes a +alance seet contain#
In 'inancial accounting a +alance seet is a summary o' te 'inancial +alances o' a company. Assets lia+ilities an% ownersip e9uity are liste% as o' a speci'ic %ate suc as te en% o' its 'inancial year.
77 Wat %oes an income statement contain roug outline#
It in%icates ow te revenue Dmoney receive% 'rom te sale o' pro%ucts an% services +e'ore e*penses are ta6en out is trans'orme% into te net income Dte result a'ter all revenues an% e*penses ave +een accounte% 'or. It %isplays te revenues recogni;e% 'or a speci'ic perio% an% te cost an% e*penses carge% against tese revenues inclu%ing write-o''s De.g. %epreciation an% amorti;ation o' various assets an% ta*es. /e purpose o' te income statement is to sow managers an% investors weter te company ma%e or lost money %uring te perio% +eing reporte%.
78 Give me some report names tat you ave create% in pro)ect# =ou can say Actual +oo6 +u%get +oo6 'orecast +oo6 etc.
7: an in use any oter rates oter tan avg- rate an% BM Dn%ing B' Mont- rate in translation in HFM#
onsultant is not te one wo %eci%es to ta6e eiter avg-rate o' BM rate client will %eci%e it time to time.
7>. Icp ntity aggregation weigtE consoli%ate% purpose Dput 1 means 1@@U 8@ Wat is te minimum to role to +e given to a user to access HFM#
,e'ault
81 Were %o you give roles to users# In sare% services un%er te provisions.
82 How %o you 6now weter te consoli%ation as +een %one 'or a particular entity or not in a particular mont#
I' you select a %ata gri% 'or tat particular entity cange te %isplay options to calculation status tere i' you 'oun% or , it means tat tat entity nee%s consoli%ation
8 an we loa% %ata in multiple currencies per entity#
=ou cannot loa% multiple currencies to one entity +ecause in attri+utes you can give only one currency in ,e' urrency
$tep1E we ave to %e'ine te currencies in meta%ata un%er te 3urrencies4
Here wat are te currencies you will %e'ine it will +e automatically store% un%er ustom 1 an% ustom 2 un%er urrencies system generate% mem+er.
Here te currencies will ave a relationsip wit value %imension
A'ter you loa% meta%ata Financial Management automatically creates tree Jalue %imension mem+ers 'or eac currency in your applicationE urrency ame urrency ame A%)s an% urrency ame /otal were urrency ame is te currency la+el. For e*ample 'or a currency o' K$, Financial Management creates te 'ollowing Jalue %imension mem+ersE K$, K$, A%)s an% K$, /otal.
$tep 2E In entity %imension attri+utes we ave to give te %e'ault currency 'or tat particular entity.
(y giving tis wenever you select te 3entity currency4 in value %imension watever te currency we ave given te %e'ault currency it will e*ecute tat.
For e*ample i' you are loo6ing 'or a 'orm or report o' te country K$ as we all 6now te currency 'or K$ is K$, ere we can see te report in two ways in value %imension eiter you ave to select te currency 3K$,4 or you ave to select te 3entity currency4 wen you select te 3entity currency4 it will ta6e te %e'ault currency 'rom te entity Din tis case we will give te %e'ault currency 'rom entity as K$,4 in +ot cases te result will +e same. $o ere wenever you %onVt 6now te entity currency te value %imension mem+er 3entity currency4 will elp us to see te report in te local currency.
$tep E Application setting wit regar%s to currency
,e'ault urrencyE tis means te ultimate parent currency in wic we will generate te 'inal reports.
,e'ault !ate 'or (alance AccountsE For (alance seet accounts we ave to mention te %e'ault rate weter itVs closing rate or average rate Dwe nee% to create an account 'or average an% closing rates
,e'ault !ate 'or Flow AccountsE For 'low accounts Di.e. Income statement we ave to mention te %e'ault rate weter itVs closing rate or average rate Dwe nee% to create an account 'or average an% closing rates
Kse PJA 'or (alance AccountsE ormally we will not select tis 'or +alance seet accounts +ecause we will use closing rate 'or +alance seet accounts
Kse PJA 'or Flow AccountsE Wen you are using Average rate 'or Flow accounts in normal practice we will select tis option 'or Flow accounts Di.e. Income statement
$tep E Bnce we 'inis tese steps we will enter te currency e*cange rates +y using 'lat 'ile or we+ 'orm.
ormally People 'rom client si%e will %o tis activity +y entering in we+ 'orm or %ata 'ile. 85 wat are te com+ination to enter e*cange rates#
=ou can ta6e te +ase currency in custom 1 an% translate% currency in custom 2 an% you can give te e*cange rates. see +elow 'or your re'erence.
87. ustom aggregation weigtE
In o%e attri+ute Dput 1 Means 1@@U consoli%ate%
88 il% entities ave %ata +ut tere is no %ata in parent entity wat coul% +e te reason#
Pro+a+ly consoli%ation may not appen at tat particular point o' time. 8: ot a+le to create )ournals 'or an entity wat option %o u cec6# Allow A%) in entity %imension
8>. $cenarioE ero view a%)ustments an% ero view on a%)ustments :@ Wat is line item %etail in HFM ow to enter it#
I' you select Kse line items attri+ute in account %imension 'or a particular account you can %o tis.
'or e*ample in a%min e*penses you ave %i''erent %epartments li6e sales purcases H!. you can enter line items in account a%min e*pense in gri%.
:1. Wat is te Functions o' $mart view# 1. Get value 2. $et value . Get te*t . $et te*t 5. Hs currency 7. Hs la+el 8. Hs %escription :. Hs group
:2 Wat is te %i''erence +etween %ata gri%s an% %ata 'orms# /ere are so many tings please re'er your note +oo6.
: Have you use% %ata 'orms give me some e*ample#
For %ata entry in to te HFM every client soul% use %ata 'orms in some way. *ample 'or tis (alance seet Income statement.
: How %o you acieve closing process in HFM#
Coa% ,ata alculate ,ata A%)ust ,ata /ranslate ,ata Approve ,ata Coc6 %ata
!un an% Pu+lis
,ata is store% at te cells 'orme% +y te intersection o' te mem+ers o' te %i''erent ,imension mem+ers in te su+-cu+e
:7 How %o you ta6e +ac6 up o' a HFM application#
ormal practice is copy application +ac6 up o' security meta-%ata %ata etc.
:8. /e %ata is e*porte% to smart view in e*cel +ut te cells are sowing ;eros wat coul% +e te reason#
/is is +ecause o' te ero view a%)ustments an% ero view non-a%)ustments in scenario %imension meta-%ata attri+utes.
::.Wat are te system messages### /ell me some error messages#
=ou can retrieve view print an% %elete system messages 'or Financial Management. =ou can retrieve system messages +y %ate server name an% application name. $ystem messages remain in te log until you %elete tem. /e system messages mo%ule is availa+le only in te We+ user inter'ace
I' a user %oesn?t ave a proper access 'or a particular entity i' e is repeating te same action ten an error will come in system messages you %ont ave a proper rigts to per'orm tis action.
:>. Wat are te rror co%e 5@2# Br @@ some ting#
A 5@2 error is Internal $erver error. =our we+ server will return tat H//P !esponse wen te program running terminates a+normally0returns an unan%le% e*ception.
A @ error Dpro+a+ly it may +e @@ error is a 'ile not 'oun% error tat occurs wen te We+ $erver receives a H//P G/ re9uest 'or a 'ile tat %oes not e*ist on te server in te pat speci'ie%. Ksually occurs wen a we+.
>@. WHA/ is $tatutory Hierarcy#
$tatutory ierarcy means wic 'its 'or Cegal re9uirement to su+mit te accounts o' a company.
>1. WHA/ is Managerial Hierarcy#
Managerial ierarcy is 'or iger management it will gives you in-%ept analysis 'or %i''erent areas.
>2. !$PB$I(ICI/I$ o' Migration#
/e main ting you nee% to %o a'ter per'orming te migration is we ave to cec6 all te 'unctionality in te application li6e loa%ing e*tracting %ata )ournals etc. li6e tis we nee% to prepare a cec6list an% ave to con'irm every 'unction is wor6ing per'ectly.
>. Wat is te Account %imension attri+utes Mem+er ,escription Dnglis Account type Is alculate% Is onsoli%ate% Is Icp Plug Account
ustom 1 /op Mem+er ustom 2 /op Mem+er ustom /op Mem+er ustom /op Mem+er um ,ecimal places Kse line items
na+le ustom 1 aggregation weigt na+le ustom 2 aggregation weigt na+le ustom aggregation weigt na+le ustom aggregation weigt Kser %e'ine% 1
Kser %e'ine% 2 Kser %e'ine% $ecurity class Icp /op mem+er na+le %ata au%iting ,e'ault parent
>. Wat is te ntity %imension attri+utes# Mem+er
,escription Dnglis ,e'ault currency Allow a%)ustments
Is Icp
Allow a%)ustments 'or cil%ren $ecurity class Kser %e'ine% 1 Kser %e'ine% 2 Kser %e'ine% Hol%ing ompany $ecurity as partner
,e'ault parent
>5. Wat is te $cenario %imension attri+utes# Mem+er
,escription Dnglis ,e'ault Fre9
,e'ault Jiew Perio%ic
ero view 'or on a%)ustments ero view 'or a%)ustments onsoli%ate% =/, Kser %e'ine% 1
Kser %e'ine% 2 Kser %e'ine% $ecurity class
na+le %ata au%iting
$upport process management Ma*imum review level 1@ Kse line items
,e'ault Fre9 'or icp transactions ,e'ault parent
>7. Wat is te ustom %imension attri+utes Mem+er
,escription Dnglis $witc sign 'or 'low $witc /ype 'or 'low Kser %e'ine% 1 Kser %e'ine% 2 Kser %e'ine% $ecurity class $u+mission groups ,e'ault parent
>8. Wat is te urrency %imension attri+utes# urrency
,escription $cale
,isplay in I/
>:. Wic /ic6eting tool is use% in your support pro)ect# !eme%y Cotus $ervice now DPlease tell any one
>>. How %o ,i''erent ell olors in%icate in HFM# DAs6 any speci'ic color# Blue- Hea%er cell
Off White -An input cell. =ou can manually enter or e%it %ata. ight !ellow -Coc6e% or %erive% cell
ight "ray Te#t -o write or !ea% access or may +e %erive% %ata Dar$ !ellow-In%icates one o' tese con%itionsE
L ell %ata as +een mo%i'ie% +ut as not +een save%
L /e input status is B +ut te status o' te a%)ustment is not B DH or /!
ight "reen -Allows allocations an% %erive% %ata Dar$ "reen -!ea%-only
Orange -Invali% PBJ DPoint o' Jiew intersection
1@@. ,i''erences +etween ,ata Form an% ,ata Gri%
Data Form Data Grid
1. It is end user purpose/client
1.It is a Group user purpose
2.we can Import and Export
2. We can't Import and Export
3.We can restrict the POV
3.We can't restrict the POV
.We can select the Excel !"mart View#
. $o selection %or &ata Grid.
. We can lin( one %orm to another %orm.
.)in(in* option is not a+aila,le
-.ransalation is not possi,le -.ransalation is possi,le .0alculations not possi,le
.0alculations are possi,le
.We can done "criptin* here
. $ot "criptin* option here.
