• LOGIN
  • No products in the cart.

Oracle Hyperion Planning Interviw Questions

In a Planning application it is possible to select several currencies per entity member?

FALSE

When creating a multi-currency application, which dimensions are automatically created in Essbase?

Currencies

HSP_Rates

It is possible to select the application’s default currency as a triangulation currency?

False

Oracle HFM

Exchange rates are set up from?

The Planning Desktop

If you change an exchange rate, you must?

Refresh the application selecting the option “Currency Conversion Calc Script” and run the HspCRtb or HspCRtt script

If you add a new reporting currency, scenario or version to your application, you must?

Refresh the application selecting the option “Currency Conversion Calc Script” and run the HspCRtb or HspCRtt script

How many currencies can you select per Entity member?

1The HSP_RATES Dimension includes the following members?

HSP_InputValue

HSP_InputCurrency

HSP_Rate_XXX (where XXX is a currency, i.e USD)

What exchange rate types are available in for the Accounts Dimension?

– None

-Average

-Ending

-Historical

What are the 5 options in the Currency Calculation Script section on the Planning Desktop?

Calc Script Name

-Version Type

-Currencies

-Scenarios

-Versions

What are the 2 copy calc scripts called?

HspCRtB

HspCRtT

What must be done before loading custom dimension members using HAL?

Create the user defined custom dimension in Planning Web

What Hyperion tools can be used to load data?

HAL Essbase adapter

EAS

Essbase Application Manager (for versions prior to 4.x)

When creating a single currency application, which dimensions are automatically created?

Accounts

Currencies

Entities

Scenarios

Time Periods

Versions

Years

Which 2 statements are correct?

Target versions let you enter data for members at any level in the hierarchy

Bottom-Up versions only allow for data entry at Level0

Which statement is correct?

Bottom-Up versions only can be enabled for Process Management (Workflow)

Which statement is correct about copying versions?

You can copy account annotations as well as supporting details

Which statements are correct about user-defined custom dimensions?

You assign valid plan types at dimension level only and not at member level

You can create up to 13 user-defined custom dimensions

The name for a user-defined custom dimension can be up to 80 characters

Oracle HFM

When you convert currencies in a webform, converted values are?

Read-Only

The copy calc scripts copy exchange rates from top level dimension members to Level0 members?

True

From which dimensions can you import members using the HAL Planning Adapter?

-Accounts

-Entities

-Custom Dimensions

-Alias

January 25, 2020
GoLogica Technologies Private Limited  © 2019. All rights reserved.