4H0-435 Hyperion Financial Management V3.51 Practice Exam Set 3

What are three methods for creating new users in Hyperion Analyzer? (Choose three.)
A. XML file import
B. import users from HFM

C. import users from Hyperion Reports
D. clone an existing user and rename the profile
E. create each user in the Administrator module


Options are :

  • A,D,E
  • A,D,B
  • A,D,C
  • C,D,E

Answer : A,D,E

In a disaster recovery situation, what should you do to successfully restore an HFM application?


Options are :

  • install MDAC, restore database
  • restore database, reboot HFM application server, reload metadata
  • restore database, reboot HFM application server
  • restore database, reboot HFM application server, reapply security

Answer : restore database, reboot HFM application server

What can be extracted using Extended Analytics? (Choose two.)
A. data
B. metadata
C. incremental data
D. metadata changes


Options are :

  • A,D
  • A,C
  • A,B

Answer : A,B

4H0-712 Hyperion Ess Base 7x Certification Practice Exam Set 2

The Manage Ownership module can be used to enter which three fields of information? (Choose
three.)
A. percent control

B. assign security class
C. consolidation method
D. assign an entity to a holding company
E. active/inactive consolidation status of a dependent into a parent


Options are :

  • A,C,B
  • A,C,E
  • A,C,D
  • D,C,E

Answer : A,C,E

Registering the Report server with Hub allows you to set up links to related content with which
three products? (Choose three.)
A. Hyperion Central
B. Hyperion Analyzer
C. Hyperion Strategic Finance
D. Hyperion Application Builder


Options are :

  • C,B,D
  • A,B,C
  • A,B,D

Answer : A,B,D

A client has a dynamic process of adding new accounts and products every month. They require
the ability to audit changes by time and by user to their application. Which practice provides the
most control and auditability for user changes to metadata over time?


Options are :

  • Publish the model to Hyperion Hub and allow the versioning to control model management.
  • Extract metadata on a regular basis with a naming convention to indicate their version of the metadata.
  • Use the native backup and restore properties of the database to version the application.
  • Use Extended Analytics to create fully populated and consolidated star schemas in a separate database.

Answer : Publish the model to Hyperion Hub and allow the versioning to control model management.

Hyperion Essbase 5 Certification (4H0-002) Practice Test Set 3

How are Autoreversing Journals reversed?


Options are :

  • automatically, when you select Unpost
  • automatically, when you open the next period
  • when a user manually posts the system generated Journal
  • when the next period is opened by loading data

Answer : when a user manually posts the system generated Journal

A user working in a Web Data Entry Form wants to export the form to Excel. Which statement is
true?


Options are :

  • Data can not be exported from a web form to Excel.
  • Data calulations from a web data form will not recalculate when exported to Excel.
  • Data can not be viewed in Excel from an exported form unless the user is connected to the application via the HFM Excel add-in.
  • Data can not be imported from Excel after it has been changed from a exported web form.

Answer : Data calulations from a web data form will not recalculate when exported to Excel.

The administrator has correctly installed Hyperion Hub, yet the option to register the application
does not appear in the HFM Web interface. What will cause this problem?


Options are :

  • The Hub web server is not running.
  • The admin does not have rights to the Hub server.
  • The application models have not been published for sharing.
  • The Hub URL was not entered into the HFM configuration utility.

Answer : The Hub URL was not entered into the HFM configuration utility.

Hyperion Essbase 5 Certification (4H0-002) Practice Test Set 1

User A is created in Hyperion Reports and is assigned the role of Viewer. User A is then assigned
to Group B which has the roles of Security Administrator and System Administrator. Which role(s)
does User A have in Hyperion Reports?


Options are :

  • Designer and Viewer only
  • System Administrator, Security Administrator, Designer, and Viewer
  • System Administrator and Security Administrator only
  • Viewer only

Answer : System Administrator, Security Administrator, Designer, and Viewer

A balance sheet account is translated using the TransPeriodic function. What will be the February
result of a translation?
January Feburary
Exchange rate 0.1 0.2
Local Currency account balance 1000 2000
Translated account balance 100 _____


Options are :

  • 100
  • 400
  • 200
  • 300

Answer : 300

Which statement about the HoldingCompany field in the Entity dimension is true?


Options are :

  • The Calculate Ownership Routine uses it to identify an Intercompany Elimination Entity.
  • The Calculate Ownership Routine uses it to identify where Minority Interest Expense is calculated.
  • The Calculate Ownership Routine uses it to identify the Percentage Ownership of the Parent Company.
  • The Calculate Ownership Routine uses it to identify which Consolidation Method to assign.

Answer : The Calculate Ownership Routine uses it to identify which Consolidation Method to assign.

4H0-712 Hyperion Ess Base 7x Certification Practice Exam Set 2

Which formula retrieves the data for January sales?


Options are :

  • =HFMVal("Acc#Sales.PD#January.")
  • =HFMLnk("A#Sales.P#January.")
  • =HFMLnk("Acc#Sales.PD#January.")
  • =HFMVal("A#Sales.PD#January.")

Answer : =HFMVal("A#Sales.PD#January.")

Which two are securable roles? (Choose two.)
A. Load System
B. Read Journals
C. Create Account
D. Consolidate All with Data


Options are :

  • A,D
  • A,B
  • A,C
  • D,B

Answer : A,B

In a Web Data Entry Form script, what is the proper syntax for calling an Account list named
IncomeStatement?


Options are :

  • A#.IncomeStatement
  • A#{IncomeStatement}
  • A#IncomeStatement
  • A{IncomeStatement}
  • A[IncomeStatement]

Answer : A{IncomeStatement}

4H0-533 Hyperion PlanningV.3.3.1 Certification Practice Test Set 5

When using the HFM HAL adapter, which are Export Data Criteria options?


Options are :

  • Scenario, Year, View, Entity, Accounts
  • Scenario, Year, Entity, Accounts, Custom1, Custom2, Custom3, Custom4
  • Scenario, Year, Custom1, Custom2, Custom3, Custom4
  • Scenario, Year, Entity, Accounts, Value, ICP

Answer : Scenario, Year, View, Entity, Accounts

Which steps are needed to change a Hyperion Analyzer Spreadsheet to a Chart?


Options are :

  • Tool Bar > Tools > Charts
  • Tool Bar > Display > Pinboard
  • Tool Bar > Charts
  • Tool Bar > Display > Charts

Answer : Tool Bar > Display > Charts

A client wants to optimize the performance of user authentication in their environment. Most users
are stored in the iPlanet LDAP server named earth. Within the css.properties file, which search
order best meets their needs?


Options are :

  • com.hyperion.css.searchorder = ?(ntlm?earth(msad?ldap://10.0.0.4:389/dc=users:dc=com(ldap://earth:389/dc=users,dc=com
  • com.hyperion.css.searchorder = ?(ntlm?earth(ldap://earth:389/dc=users,dc=com(msad?ldap://10.0.0.4:389/dc=users:dc=com
  • com.hyperion.css.searchorder = ?(ldap://earth:389/dc=users,dc=com(ntlm?earth(msad?(ldap://10.0.0.4:389/dc=users:dc=com
  • com.hyperion.css.searchorder = ?(ntlm?earth(msad?(ldap://earth:389/dc=users,dc=com(ldap://10.0.0.4:389/dc=users:dc=com

Answer : com.hyperion.css.searchorder = ?(ldap://earth:389/dc=users,dc=com(ntlm?earth(msad?(ldap://10.0.0.4:389/dc=users:dc=com

4H0-712 Hyperion Ess Base 7x Certification Practice Exam Set 3

Which dimension's member must have SupportsProcessManagement selected to enable Process
Management functionality?


Options are :

  • Value
  • . Entity
  • Account
  • Scenario

Answer : Scenario

When installing Hyperion Financial Management, where is the URL for Hub access specified?


Options are :

  • in the installation initialization screens
  • in the Manage Applications section in Administrative Tasks
  • in the HFM configuration utility
  • in the Common Security Services XML configuration

Answer : in the HFM configuration utility

What is required for HFM Administrators to have access to Hyperion Hub?


Options are :

  • Add a DCOM user with launching permissions on the Hub server.
  • Configure HFM for external Authentication.
  • Add the HFM user as an Administrator on the Hub Server.
  • Configure Hub to allow NTLM Authentication.

Answer : Configure HFM for external Authentication.

4H0-712 Hyperion Ess Base 7x Certification Practice Exam Set 2

In the Account metadata attributes, checking the IsCalculated box allows _____.


Options are :

  • the automatic clearing of accounts when a consolidation is run
  • rules to be written to the account
  • calculations to be performed on a parent level account
  • the entry of data to parent level accounts

Answer : the automatic clearing of accounts when a consolidation is run

Where can you find information on how a Hub model is shared with other projects?


Options are :

  • The properties of the model viewed in the Hub.
  • The define integration panel of the Hub integration creation screen.
  • The properties panel of the model in Manage Models.
  • The properties panel of the integration in Manage Models.

Answer : The properties panel of the model in Manage Models.

How would you create a Web Data Explorer Grid on which you cannot drill down by default when
placing a single dimension in the rows?


Options are :

  • when saving your grid, check the box to disallow drill down
  • nest another dimension in the rows
  • select a member list from the Grid Settings dialog box
  • select the Prevent Drill Down option from the Row Settings dialog box

Answer : select a member list from the Grid Settings dialog box

4H0-533 Hyperion PlanningV.3.3.1 Certification Practice Test Set 4

Using Hyperion Reports, the Relative Member function can be used with which dimension?


Options are :

  • Period
  • Entity
  • Scenario
  • Accounts

Answer : Period

When creating an Intercompany Matching Report, which two dimensions appear when Add is
selected for Account Entities or Account Partners? (Choose two.)

A. ICP
B. Entity
C. Value
D. Account
E. Custom (1..4)


Options are :

  • D,B
  • D,A
  • D,E
  • D,C

Answer : D,E

What are two types of member lists? (Choose two.)
A. system
B. optional
C. dynamic
D. end-user


Options are :

  • B,C
  • A,D
  • A,B
  • A,C

Answer : A,C

4H0-533 Hyperion PlanningV.3.3.1 Certification Practice Test Set 7

Which dimension can be specified on the left side of the equal sign of an HS.EXP function?


Options are :

  • Year
  • ICP
  • Scenario
  • Entity
  • Period

Answer : ICP

Given the following Organization by Period situation:
ACTIVE ENTITIES BY PERIOD
Jan Feb
Parent1 |__Child ACTIVE INACTIVE
Parent2 |__Child INACTIVE ACTIVE
PERIODIC DATA FOR CHILD: Jan = 100Feb = 100
Turning the ConsolidateYTD flag off creates which two Year to Date data values? (Choose two.)
A. Entity: Parent1.Child
Period: Feb
Data: 0

B. Entity: Parent2.Child
Period: Feb
Data: 100
C. Entity: Parent1.Child
Period: Feb
Data: 100
D. Entity: Parent2.Child
Period: Feb
Data: 200


Options are :

  • B,C
  • B,A
  • D,C
  • B,D

Answer : B,C

You are adding an Entity member to a metadata file. Which attribute, in addition to the Member
attribute, must the user add in order to load the metadata file?


Options are :

  • Description
  • DefCurrency
  • Security Class
  • SecurityAsPartner

Answer : DefCurrency

Hyperion Essbase 5 Certification (4H0-002) Practice Test Set 2

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions