Oracle Oracle Certifications 1Z0-533 Questions & Answers

• Question 51:

  What four functions can Administrators use the Copy Data feature In Planning to do?

  A. Copy data values from one dimensional intersection to another dimensional intersection.

  B. Copy planning unit annotations.

  C. Copy supporting detail.

  D. Copy cell text.

  E. Copy account annotations.

  Correct Answer: ACDE

  Administrators can use Copy Data to copy plans from one dimensional intersection to another (A), including relational data and supporting detail (C).

  You can copy account annotations (E), supporting detail, and cell text (D). You cannot copy planning unit annotations.

  Reference: Oracle Hyperion Planning, Fusion Edition, Copying Data

• Question 52:

  Identify the three true statements about attribute dimensions in Planning.

  A. Aliases are supported for attribute members.

  B. Consolidation properties are supported for attribute members.

  C. Hierarchies are supported for attribute dimensions.

  D. Only Text attributes are supported.

  E. Text, Boolean, Numeric, and Date attributes are supported.

  Correct Answer: ACE

  A: Open the Dimension Library and select File >

  New > Dimension. Enter a name and description, then select the Alias type.

  C: From planning 9 3 1 you can also create attribute hierarchy in planning.

  E: Attribute dimensions have a type setting--text, numeric, Boolean, or date. Text is the default setting.

• Question 53:

  What four read or write security assignments allow end users to be able to view at least some data?

  A. At least one member in the Scenario dimension

  B. At least one member In the Version dimension

  C. At least one member in the Period dimension

  D. At least one member in the Account dimension

  E. At least one member in the Entity- dimension

  F. If security has been assigned for a Custom dimension, at least one member in the user-defined custom dimension

  Correct Answer: ABEF

  Scenario,Version and Entity make up a planning unit so security needs to be applied here and then also to the custom dimension if it has security.

• Question 54:

  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.

  Correct Answer: D

  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 55:

  Which three components can be changed after the creation of the Planning application?

  A. Number of years

  B. Names of plan types

  C. Number of plan types

  D. Initialization of WFP or CapEx Planning modules

  E. Weekly distribution spread

  F. Year Dimension Name

  G. Default Currency

  Correct Answer: ADF

  Note: WFP ?Workforce planning. Oracle Hyperion Capital Expense Planning (CAPEX) software is a specialized planning module that automates the planning of capital assets and capital asset related expenses, such as depreciation, maintenance and insurance.

• Question 56:

  Identify the three characteristics of the Scenarios dimension.

  A. Security can be assigned to members of the Scenario dimension.

  B. It allows the administrator to assign valid periods for data entry

  C. It allows bottoms up or target planning

  D. Exchange rate tables are tied to the Scenario dimension.

  E. One member in the scenario dimension may be valid for Plan Type.

  Correct Answer: ABD

  A: Specify access rights to members of the Scenario dimension for groups or users.

  Access rights determine users or groups can view or modify data. A user or group can have only one of these access rights: Read, Write, or None. Access rights for a user can be combined based on groups to which the user belongs.

  B: When creating a scenario For Start Yr., Start Period, End Yr., and End Period are used to select the time period to associate with the scenario.

  D: The Scenario dimension has an Exchange Table property with value of the name of an exchange rate table defined in the application.

  Reference: Oracle Hyperion Planning, Fusion Edition

• Question 57:

  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.

  Correct Answer: B

  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 58:

  Identify the two true statements assuming you are working with a single application with multiple plan types.

  A. A user-defined custom dimension may exist in one plan type but not the other plan types.

  B. A user-defined custom dimension may have members in one plan type but not the remaining plan types.

  C. All members in the entity dimension must exist in all plan types.

  D. All members in the accounts dimension must exist in all plan types.

  E. All periods must exist in all plan types.

  Correct Answer: AE

  A: Properties for User-Defined Custom Dimensions include property Valid for Plan Types which is used to select plan types for which the dimension is valid. Clearing this option makes all members of the dimension invalidfor the deselected plan type.

  User-defined custom dimensions differ from the Entity and Account dimensions in that you assign valid plan types at the dimension level, not at the member level. All members of a user-defined custom dimension are valid for plan types assigned at the dimension level.

  Note: Specify one to three plan types for the application. A separate Essbase database is created for each plan type. You cannot change the name or number of plan types after creating an application.

  As you create accounts, entities, and other elements of the application, you associate them with plan types, so the database for each plan type contains only information relevant to the plan type. This optimizes application design, size, and performance.

• Question 59:

  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

  Correct Answer: ABDE

  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 60:

  Identify two ways that Essbase data load rules cannot manipulate source data files.

  A. Select or reject records based on certain criteria.

  B. Flip the sign for records with a certain member tagged with a comment.

  C. Split or join columns in a source.

  D. Find and replace manipulations on source records.

  E. Map data based on an external table.

  Correct Answer: CE

  C: Columns cannot be split or joined at runtime in the source.

  E: An external table cannot be used to map data.

  Note: Data Load Rules file is the second type of rules files which is involved in the data load process.

  A data source for data load must contain :

  not only the values that you want to load but also identification of the location to which Essbase should load the values:

  a data address that includes one member from every standard dimension in your outline.