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

In a multi-currency application, a Web form has been set up to allow a user to enter data in
currencies other than the Entities' base currency. The end user has entered data in Jan, Feb and
Mar in the "Local" member. Which statement is true if the user has changed the base currency in
the data entry cell for Mar?


Options are :

  • The Q1 member will show the monthly values aggregated to the currency other the base currency.
  • The Q1 member will show the monthly values aggregated as a combination of the base currency and the other currency. (Correct)
  • The Q1 member will show the monthly values aggregated to the base currency.
  • The Q1 member will show the monthly values aggregated for the dominant currency that was entered in the data entry cell.

Answer : The Q1 member will show the monthly values aggregated as a combination of the base currency and the other currency.

Which step is necessary prior to loading attribute values using Hyperion Dimension Editor?


Options are :

  • Add the attribute dimension in Hyperion Essbase Application Manager
  • Assign the attribute to a dimension in the Hyperion Planning Dimension Editor (Correct)
  • Load the base dimension members for the associated attribute dimension
  • Refresh the database

Answer : Assign the attribute to a dimension in the Hyperion Planning Dimension Editor

Which three tasks can a user who is designated as an administrator perform during the financial
process? (Choose three.)
A. Manage security
B. Maintain metadata
C. Enter and view data
D. Delete an application
E. Claim ownership of an application


Options are :

  • d,a,b
  • b,c,a
  • a,b,c (Correct)
  • b,d,a

Answer : a,b,c

When using a multiple plan type application for developing Web forms, which statement is true?


Options are :

  • Web form columns can refrence multiple plan types.
  • Data can only be entered when a form is associated with the account's Source Plan type. (Correct)
  • The plan type for a web form can be changed after it has been assigned.
  • Web Forms can reference multiple plan types.

Answer : Data can only be entered when a form is associated with the account's Source Plan type.

Refreshing Security from the Hyperion Desktop initially updates user information where?


Options are :

  • =Relational database security
  • Essbase security (Correct)
  • Microsoft Windows security
  • Web application security

Answer : Essbase security

The administrator wants to assign the following security to User1: View Access to Proforma. Read
Access to EastRegion. Write Access to all accounts under Net Income. What is the proper syntax
for the Secfile.txt?


Options are :

  • User1,EastRegion,Read,MEMBER User1,Net Income,Write,IDESCENDENTS User1,Proforma,Read,MEMBER
  • User1,EastRegion,Read,MEMBER User1,"Net Income",Write,@IDESCENDENTS User1,Proforma,Read,MEMBER (Correct)
  • User1,EastRegion,Read,MEMBER User1,Net Income,Write,@IDESCENDENTS User1,Proforma,Read,MEMBER
  • User1,EastRegion,Read,MEMBER User1,"Net Income",Write,IDESCENDENTS User1,Proforma,None,MEMBER

Answer : User1,EastRegion,Read,MEMBER User1,"Net Income",Write,@IDESCENDENTS User1,Proforma,Read,MEMBER

In your application outline, Product is a custom dimension, Accounts is dense, and the summary
time periods (Quarters and Year Total) on the Time Periods dimension are set to Dynamic Calc.
How can you accurately build a calculation for Gross Margin % by product for all Time Periods?


Options are :

  • Use a Hyperion Business Rule (HBR)
  • Use a member formula with dynamic calc storage (Correct)
  • Use Hyperion Essbase Maxl
  • Use a Hyperion Essbase calc script

Answer : Use a member formula with dynamic calc storage

Which two possible effects on the database occur when the data storage option of a parent
member in a sparse dimension is set to Dynamic Calc? (Choose two.)
A. Disk usage is lower.
B. Data block size is decreased.
C. The parent member is set to read-only in target versions.
D. It calculates the data values of the member, and then stores these values.


Options are :

  • b,d
  • c,d
  • b,a
  • a,c (Correct)

Answer : a,c

Which is an Actions Component within Hyperion Business Rules (HBR)?


Options are :

  • Increase-Decrease
  • Variable
  • Evenly-Split
  • Copy Data (Correct)

Answer : Copy Data

What are three text functions available for header type reporting within Hyperion Reports?
(Choose three.)
A. Date
B. POV Name
C. POV Member
D. POV Alias 


Options are :

  • a,c,d (Correct)
  • d,b,c
  • d,b,a
  • a,b,d

Answer : a,c,d

A Hyperion Business Rule (HBR) is being created to calculate benefit expense by Entity based on
total salaries, which have been calculated for individual employees. Total Entity benefits need to
be displayed when the calculation is complete. What is the correct sequence order of the
components within HBR?


Options are :

  • custom calculation, aggregate benefits, aggregate salaries
  • aggregate salaries, custom calculation, aggregate benefits (Correct)
  • aggregate benefits, aggregate salaries, custom calculations
  • custom calculations, aggregate salaries, aggregate benefits

Answer : aggregate salaries, custom calculation, aggregate benefits

When using the Hyperion Planning ADM driver within Hyperion Reports, which function is used to
select Attribute members?


Options are :

  • Member
  • Range
  • Property (Correct)
  • Relative Member

Answer : Property

Which two statements about account level annotations are true? (Choose two.)
A. Account level annotations can have 1500 characters.
B. Only parent level members can have account level annotations.
C. To enable the account level annotations, the Web form design does not matter.
D. A specific option must be selected in the display options page to enable the account level
annotations.


Options are :

  • a,b
  • b,d
  • a,d (Correct)
  • d,c

Answer : a,d

Which three options are supported authentication providers for CSS? (Choose three.)
A. NTLM
B. Microsoft Active Directory
C. Sun Open Net Environment (Sun ONE)
D. Novell NDS
E. BEA's LDAP Provider


Options are :

  • a,b,c (Correct)
  • d,c,e
  • b,a,d
  • e,c,d

Answer : a,b,c

Which two are valid Account member names that can be used in Hyperion Planning? (Choose
two.)
A. 4200
B. Net-Profit
C. _Gross Sales
D. 'Cost of Sales'
E. (Total Expenses)


Options are :

  • c,a
  • a,b (Correct)
  • b,c
  • d,b

Answer : a,b

Which list of data storage settings represents all of the available settings for the Entities dimension
in the Hyperion Planning Dimension Editor? 


Options are :

  • Dynamic Calc, Never Share, Shared, Store
  • Dynamic Calc, Dynamic Calc and Store, Label Only, Never Share, Shared, Store (Correct)
  • Dynamic Calc, Label Only, Never Share, Store
  • Dynamic Calc, Dynamic Calc and Store, Never Share, Shared, Store

Answer : Dynamic Calc, Dynamic Calc and Store, Label Only, Never Share, Shared, Store

After creating a new Hyperion Planning application, what are two steps that must be taken for it to
appear as a valid Web application at the Web LogOn page? (Choose two.)
A. Restart the Essbase server
B. Run the HspSetupSupport utility
C. Restart the Web application server
D. Within Hyperion Planning, select Enable Web LogOn


Options are :

  • d,b
  • d,a
  • b,c (Correct)
  • a,c

Answer : b,c

A user receives "You do not have access to view this form" when trying to open a Web form. What
causes this message?


Options are :

  • The user does not have access to every member in the form.
  • The user does not have Read access to the form.
  • The user does not have Write access to the form.
  • The user does not have access to at least one member in every dimension in the form. (Correct)

Answer : The user does not have access to at least one member in every dimension in the form.

Which three statements are true about the Cut function in the Hyperion Planning Dimension
Editor? (Choose three)
A. It is not available for root dimension members.
B. It remembers a cut member if the administrator expands, collapses, sorts, searches, or
changes pages in a dimension hierarchy.
C. It remembers a cut member if the administrator adds a child or sibling member, edits or deletes
a member, assigns access to a member or clicks the View link.
D. It remembers a cut member if the administrator adds or edits a dimension, navigates to a page
other than the Dimensions tab, deletes a member, or logs off Hyperion Planning.
E. It allows for mulitple cut selections at the same level.


Options are :

  • b,d,a
  • e,c,d
  • d,c,e
  • a,b,c (Correct)

Answer : a,b,c

In a multi-currency application, a calc script was created using Hyperion Planning Desktop. The
following selections were made: "USD", "CAD", Budget, "1st Draft" and "Bottom-Up." What will be
converted after the Currency Conversion Calc Script is run?


Options are :

  • Saved Assumption account with Percentage Data Type
  • Level zero members (Correct)
  • Parent members
  • Saved Assumption account with Non-Currency Data Type
  • Forecast Scenario for the USD Currency

Answer : Level zero members

Which three are valid properties of Scenarios with the Hyperion Planning Web Dimension Editor?
(Choose 3)
A. Access Rights
B. Time Periods
C. Data Storage
D. Exchange Rate Table 


Options are :

  • a,d,c
  • c,d,a
  • a,b,d (Correct)
  • d,b,c

Answer : a,b,d

In a multi-currency application using a Target Version, what calculation options should be used
with the Aggregate Data component?


Options are :

  • Aggregate Data up to Local Currency, Aggregate Missing Values, and Use Calculator Cache
  • Aggregate Missing Values, Optimize the Calculation of Formulas on Sparse Dimensions, and Use Calculator Cache
  • Aggregate Missing Values, Aggregate Data up to Local Currency, and Optimize the Calculation of Formulas on Sparse Dimensions
  • Aggregate Data up to Local Currency, Optimize the Calculation of Formulas on Sparse Dimensions, and Use Calculator Cache (Correct)

Answer : Aggregate Data up to Local Currency, Optimize the Calculation of Formulas on Sparse Dimensions, and Use Calculator Cache

User A is a member of the Hyperion Planning User Group "Northeast" and has Write access to the
"East" Entity. "Northeast" Group has Read Access to "East" Entity. What report would be
generated to verify User A's access to East? 


Options are :

  • Effective Access (Correct)
  • Users and Groups
  • Entities Access
  • Assigned Access

Answer : Effective Access

Which two dimensions allow access rights? (Choose two.)
A. Versions
B. Calendar
C. Scenarios
D. Currencies
E. Time Periods


Options are :

  • c,d
  • a,c (Correct)
  • b,d
  • d,b

Answer : a,c

What three properties can be defined for User-defined custom dimensions? (Choose three.)
A. Name
B. Security
C. Data type
D. Source plan type
E. Custom attributes


Options are :

  • a,b,e (Correct)
  • b,a,d
  • e,c,a
  • c,d,b

Answer : a,b,e

What are three valid variables to consider about Hyperion Planning application Web performance?
(Choose three.)
A. Network bandwidth
B. Design of existing web forms
C. Server hardware specifications
D. Number of users that exist within the application


Options are :

  • c,b,d
  • a,b,c (Correct)
  • c,b,d
  • d,a,b

Answer : a,b,c

When you assign form Write access to an interactive user, they have the ability to view _____.
(Choose two.)
A. The Web form design and modify it
B. A Web form, but not enter data into it
C. The Web form design, but not modify it
D. A Web form, and enter data into accessible members


Options are :

  • b,c
  • a,d (Correct)
  • c,a
  • d,c

Answer : a,d

Which two actions can be performed using multiple alias tables? (Choose two.)
A. You can have up to ten alias tables in an application.
B. Alias tables can be created only within Hyperion Planning.
C. You can assign multiple aliases directly to a shared member.
D. Aliases can be assigned to planning units and User-defined custom dimensions.


Options are :

  • c,d
  • b,c
  • a,d
  • a,b (Correct)

Answer : a,b

Plan Type 1 is specified as the source plan type for a member. This member is selected on a form
associated with Plan Type 2. Which statement is true?


Options are :

  • Assuming the planning unit is promoted to the user, the user can enter data to the member on the form.
  • Assuming write access to the member, the user can enter data to the member on the form.
  • The user will see the member displayed as read-only on the form. (Correct)
  • The member is not displayed on the form.

Answer : The user will see the member displayed as read-only on the form.

When would account annotations be available?


Options are :

  • When the Web form is designed to using the proper layout (Correct)
  • Only when the Web form is designed by an administrator
  • when the option is turned on in the application setup
  • When the user has write access to all dimension selections on the Web form

Answer : When the Web form is designed to using the proper layout

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions