Oracle 1Z0-533 Online Practice Questions and Exam Preparation

Oracle 1Z0-533 Online Questions & Answers

• Question 21:

  You have the following design requirement: You need to track customer status For a sales planning application. Valid options for customer status include: Active, Inactive, Out of Business.

  Customer status can change on a month-by-month basis.

  What is the best way to build Customer Status into the Planning application?

  A. Attribute dimension
  B. Varying attribute dimension
  C. Smart List
  D. Free Form Text
  E. Alternate hierarchy
  C. Smart List

  ---

  Administrators use Smart Lists to create custom drop-down lists that users access from data form cells. When clicking into cells whose members are associated with a Smart List (as a

  member property), users select items from drop-down lists instead of entering data. Users cannot type in cells that contain Smart Lists. Smart Lists display in cells as down arrows that expand when users click into the cells.

  Perform these tasks to create and administer Smart Lists:

  *

  Define Smart Lists

  *

  Associate Smart Lists with members.

  *

  Select dimensions for which Smart Lists are displayed.

• Question 22:

  You need to create an allocation Business Rule that allocates marketing expense from corporate down to each region based on FY10 actuals for the Budget scenario.

  What is the correct formula assuming this syntax is used in an enhanced calc script?

  A. FIX (Budget, @LEVMBRS (Market,0)) "Marketing expense" = "Marketing expense "->Corporate * ("Marketing expense" Actual / "Marketing expense" -> Actual --> TotalMarket); ENDFIX
  B. FIX (Budget, (@LEVMBRS (Market, 0) ) ) "Marketing expense" = "Marketing expense"->Corporate * ("Marketing expense"/"Marketing expense" --> TotalMarket) ; ENDFIX
  C. FIX (Budget, (@LEVMBRS (Market, 0) ) --- "Marketing expense" = "Marketing expense"->Corporate * ("Marketing expense" Actual ->FY10 / "Marketing expense" -> Actual ->FY10 TotalMarket); ENDFIX
  D. FIX (@LEVMBRS (Market, 0) ) "Marketing expense" = "Marketing expense"~>Corporate * ("Marketing expense" Actual ->FY10 / "Marketing expense" -> Actual ->FY10 TotalMarket); ENDFIX
  B. FIX (Budget, (@LEVMBRS (Market, 0) ) ) "Marketing expense" = "Marketing expense"->Corporate * ("Marketing expense"/"Marketing expense" --> TotalMarket) ; ENDFIX

• Question 23:

  You need to create a highly formatted, printable Income statement for each store in your company.

  Each report should be emailed to the store manager at the close of each week (each store has a different store manager). What is the best way to deliver this solution?

  A. With Financial Reporting, create a book for each store that contains a PandL for each store and use the book to distribute the reports to store managers via email.
  B. With Financial Reporting, create a store PandL and use batch bursting to distribute the report to store managers via email.
  C. With Web Analysis, create an income statement that store managers can log in and access.
  D. Within Smart View Report Designer, use the Cascade feature to generate and distribute each store income statement via email.
  E. Create a Planning PandL Data form and use email notification to send to store managers.
  D. Within Smart View Report Designer, use the Cascade feature to generate and distribute each store income statement via email.

  ---

  In addition to other capabilities, the Report Designer provides cascaded output of reports in Excel. This will enable end users to create a report in Excel and cascade it to separate sheets based on members of a dimension not included as part of the report.

• Question 24:

  What four prebuilt actions are available In EAS Business Rules?

  A. Aggregate
  B. Copy Data
  C. Clear Block
  D. Clear Data
  E. Create Block
  F. Allocate
  A. Aggregate
  B. Copy Data
  D. Clear Data
  E. Create Block

  ---

  You can choose from four possible actions to include in a graphical business rule:

  Aggregate

  Data, Copy Data, Clear Data, and Create Blocks.

  Note:

  *

  Aggregate Data --Use to calculate your database by specifying which dimensions to calculate and what calculation options you want to use during the aggregation.

  *

  Copy Data--Use to copy data from one part of your database to another. You select the source data to copy and then specify the target or destination value.

  *

  Clear Data--Use to define a subset of data that will be cleared from the database before a new value is added. You can choose either to clear cells or to clear blocks of data.

  *

  Create Blocks--Use to specify a data slice to ensure that blocks are created for all sparse member combinations in that slice.

  Reference: Hyperion Business Rules, Administrative Guide, About Adding Actions to Graphical Business Rules

• Question 25:

  Identity the true statement about Custom Menus.

  A. Custom menus can provide links to data forms, Business Rules, URLs, and Planning preferences.
  B. Custom menus require Java scripting knowledge to create.
  C. You can assign security to custom menus so that only specific users or groups can see the custom menu.
  D. Custom menus are assigned to data forms only.
  E. Custom menus are limited to a single list of tasks; you cannot group them into sub categories.
  A. Custom menus can provide links to data forms, Business Rules, URLs, and Planning preferences.

  ---

  Custom menus can be used to launch the following:

  

  Business Rules

  

  Context sensitive data forms

  

  URL

  

  Context sensitive Process Management

• Question 26:

  What are two user interfaces to Planning data forms?

  A. EPM Workspace
  B. Excel Add-in
  C. Smart View Essbase Provider
  D. Smart View Planning Provider
  E. Planning ADM Driver for FR
  A. EPM Workspace
  D. Smart View Planning Provider

  ---

  Planning data forms can be accessed from within the EPM Workspace and from Smart View Planning Provider.

  Note: Smart View provides a common Microsoft Office interface for Oracle Essbase, Oracle Hyperion Financial Management, Fusion Edition, Oracle Hyperion Planning, Fusion Edition, Oracle Enterprise Performance Management Workspace, Fusion Edition, Oracle Business Intelligence Enterprise Edition, and Oracle's Hyperion?Enterprise?data. Using Smart View, you can view, import, manipulate, distribute and share data in Microsoft Excel, Word, and PowerPoint interfaces.

• Question 27:

  What are the correct predefined types of base time periods that can be established when creating the calendar in a planning application?

  A. Weekly, Monthly, Quarterly, Custom
  B. Monthly, Quarterly, Custom
  C. Monthly, Quarterly, Weekly
  D. Weekly, Monthly, Quarterly, Yearly, Custom
  E. Only Custom periods are possible.
  B. Monthly, Quarterly, Custom

  ---

  To set up the calendar:

  1.In the Classic Application Wizard, click Calendar.

  2 Select a Base Period option to set how calendars roll up:

  *12 Months: Four quarters per year; months roll up into parent quarters and quarters into years.

  *Quarters: Quarters roll up into years.

  * Custom: A custom time period, such as weeks or days. Etc.

  Note: The calendar establishes the application's base time periods, starting fiscal year and month, and total number of years. Select the base time period and monthly distribution pattern based on the number of fiscal weeks in a month. The base time period options are the bottom-level time periods in the application. You can create a custom base time period, such as weeks or days. Use monthly distribution patterns to determine how data entered into a summary time period is distributed or spread among the base time period you select. During data entry, users can enter data into summary time periods, such as years or quarters. Planning distributes these values over the base time periods that constitute the summary time period.

  Reference: Oracle Hyperion Planning, Fusion Edition, Setting up the Calendar

• Question 28:

  A Planning Unit has a status of First Pass; what two user types can input data?

  A. Anyone with write access to the planning unit
  B. Anyone with write access to the planning application
  C. Anyone with read or write access to the planning unit
  D. The owner of the planning unit
  E. The administrator
  A. Anyone with write access to the planning unit
  E. The administrator

  ---

  A: In all Planning Units states except the Not Started state, users with read access can view data, view the process state, view the history, and read and enter annotations.

  E: The Administrator have full access.

  Reference: Reference: Oracle Hyperion Planning, Fusion Edition, Release 11.1.1.3, Overview of the Review Process

• Question 29:

  You have a new Planning administrator to manage the Capital Expenditure application. He will assign security for the application as well as maintain dimensions in EPMA, Business Rules in Calculation Manager, and load data via Essbase rules files. He will not need access to other applications. Choose the two valid roles that will address part or this entire requirement.

  A. Administrator for the CapEx application
  B. Administrator for the Planning Server
  C. Provisioning Manager for the CapEx application
  D. Planning Calculation Manager for the CapEx application
  E. Dimension Editor for the CapEx dimensions
  F. Application Manager in Essbase for the CapEx dimensions
  D. Planning Calculation Manager for the CapEx application
  E. Dimension Editor for the CapEx dimensions

  ---

  D: The planning Calculation Manager Administrator enables you to create business rules using Hyperion Calculation Manager.

  E: The global Shared Services role of Dimension Editor creates and manages dimensions.

  The global Calculation Manager administrator role enables you to create, edit and delete Planning, FinancialManagement, and Essbase objects. The Financial Management Calculation Manager administrator role enables to create, edit and delete Financial Management objects.

• Question 30:

  Identify the two true statements about shared members.

  A. You can assign a custom attribute value to a shared member.
  B. You can define a member formula for a shared member.
  C. You can assign security rights to a shared member.
  D. There is no limit to the number of shared members that you can create for the base member.
  E. Shared members may be defined for Accounts and Entity dimensions only.
  C. You can assign security rights to a shared member.
  D. There is no limit to the number of shared members that you can create for the base member.

  ---

  C: Access cannot be assigned directly to a shared member. You assign access rights to shared members in one of two ways:

  *

  From the security assigned directly to the base member

  *

  From the security assigned at the parent or ancestor of the shared member

  D: You can create multiple shared members for the base member. A base member must exist before you can create a shared member, but there is no limit to the number of shared members you can create for the base member.

  E: Shared members are available for Entity, Account, and user-defined custom dimensions. " Shared members contain read-only values and are only available in the Entity dimension. "