Oracle 1Z0-533 Online Practice Questions and Exam Preparation

Oracle 1Z0-533 Online Questions & Answers

• Question 61:

  You've created an EAS business rule and assigned it to the data form but an end user can't see it. What are two valid reasons?

  A. The user doesn't have the Launch Business Rules role in Shared Services.
  B. The user hasn't been assigned Validate or Launch Privileges in EAS.
  C. The location for the Business Rule hasn't been defined.
  D. The user hasn't been assigned access to the Business Rule in the Planning Web client.
  A. The user doesn't have the Launch Business Rules role in Shared Services.
  B. The user hasn't been assigned Validate or Launch Privileges in EAS.

  ---

  A: If the user does not have the launch the Business Rules role, it could prevent the user from seeing the rule.

  B: The Validate or launch Privilege enables a users or users you specify to validate and launch the business rule sequence Incorrect answer:

  C: The business rule has already been assigned to the Data Form.

• Question 62:

  A Business Rule is launched from a data form.

  What will Planning utilize to provide a valid list of members for a run-time prompt?

  A. Members defined on the data form
  B. Planning Metadata security
  C. Business Rules security access privileges
  D. Essbase security filters
  E. Business Rules Basic User Role
  A. Members defined on the data form

  ---

  When launched, a business rule can prompt you to enter variable information, called a runtime business rule designer sets up runtime prompts.

  If a business rule has a runtime prompt and Use Members on Forms is selected, the default member on the runtime prompt window matches the current member in the page or POV axes of the open data form. Reference: Oracle Hyperion Planning, Fusion Edition, Release 11.1.1.3, Entering Runtime Prompts

• Question 63:

  Given the following:

  Measures (Dense): 40 stored members, 50 total members

  Time (Dense): 17 stored members, 17 total members

  Scenario (Dense): 2 stored members, 5 total members

  Market (Sparse): 100 stored members, 100 total members

  Product (Sparse): 500 stored members, 550 total members

  How many potential blocks could be created?

  A. Potential Blocks = 40 * 17*2
  B. Potential Blocks = 40* 17*2*8
  C. Potential Blocks = 100 * 500
  D. Potential Blocks = 100 * 500 * 8
  E. Potential Blocks = 100 * 550
  F. Potential Blocks = 100 * 550 * 8
  C. Potential Blocks = 100 * 500

  ---

  The number of stored members in sparse Dimensions will help us in finding potential number of blocks Potential Number of Blocks = Stored Members in Market * Stored Products in Scenario.

• Question 64:

  A planner is supposed to be able to submit data within a data form.

  What are all the possible causes for an end user not being able to enter data on a data form? Select all that apply.

  A. The planning unit is set to first pass.
  B. Another user owns the planning unit.
  C. The user has read access to the members on the data form.
  D. The form contains summary-level members in a bottom up version.
  E. The form is set to Read Only.
  C. The user has read access to the members on the data form.
  D. The form contains summary-level members in a bottom up version.
  E. The form is set to Read Only.

  ---

  C, E: By assigning access to a data form, you control which users can change its design (for example, its layout and instructions) and input data. Users can select only members to which they have read or write access. Users can edit data forms only if they have access to at least one member of each secured dimension. For example, if users have read-only access to the Europe entity, the rows and columns on data forms that include the Europe entity are displayed as read-only. Users can change data only for members to which they have write access.

  D: For bottom-up versions, rows and columns with level 0 members allow data entry. Rows or columns set to a parent member are read-only. The point of view must also be set to the level 0 member to allow data entry on a bottom-up

  version. Target versions allow data entry in parent and children members.

  If you assign children to bottom-up versions, these versions display as read-only parents on data forms.

• Question 65:

  Identify two times when a security refresh needs to be performed.

  A. Member access has been assigned to a group.
  B. Member access has been assigned to a user.
  C. New group is created.
  D. A new Member "East" has OnDESCENDANTSCREAD.access assigned.
  E. New business rule is created.
  A. Member access has been assigned to a group.
  B. Member access has been assigned to a user.

  ---

  After you establish or update user and group security, the Planning application needs to be refreshed to complete the update to Analytic Services security filters.

  Incorrect:

  D: This options badly worded. We here assume that the security of the member has not changed. C, E: no security has changed.

  Reference: HYPERION SYSTEM 9 PLANNING, RELEASE 9 . 2 . 0 . 3 About Security in Planning

• Question 66:

  You are designing a form for fast retrieval speed. Assuming a plan type with two dense dimensions and four sparse dimensions, what is the optimal layout?

  A. Sparse dimensions in Page and POV, Dense dimensions in Rows and Columns
  B. Sparse dimensions in Rows and Columns, Dense dimensions in Page and POV
  C. Sparse dimensions in Page and Columns, Dense dimensions in Rows and POV
  D. Sparse dimensions in Page and Rows, Dense dimensions in POV and Columns
  E. The layout of sparse and dense dimensions has no impact on form performance; only the number cells on a data form impacts form performance.
  A. Sparse dimensions in Page and POV, Dense dimensions in Rows and Columns

  ---

  The Hyperion Planning gurus gave us the following advice: *Row and Column contain dense dimensions only *Page and Point of View (POV) contain sparse dimensions only Suppress Missing Data option enabled so as to not display Rows or Columns without data Split data forms into multiple data forms that contain fewer Rows and Columns To put it more simply ?KEEP DATA FORMS SMALL!

  Note: Dense dimension: In block storage databases, a dimension likely to contain data for every combination of dimension members. For example, time dimensions are often dense because they can contain all combinations of all members. Sparse dimension: In block storage databases, a dimension unlikely to contain data for all member combinations when compared to other dimensions. For example, not all customers have data for all products

  Point of View (POV): Shows information about other members that are valid for the defined row and column members. POVs identify the database members that populate a data form, and define data intersections. Members on the rows, columns, and POV axes are constant (except when they have dynamic user variables).

  Page lists: Display different views (pages) of selected member combinations that can span dimensions, enabling you to work with various member combinations.

• Question 67:

  Identify the two true statements with regard to Versions and Scenarios.

  A. Versions control data entry based on time periods set by the administrator.
  B. There is only one Version to one Scenario.
  C. Versions allow several "what-if" Scenarios.
  D. Users must have the same security settings in the Version dimension as they have in the Scenario dimension.
  E. Versions can be top down or bottom up.
  C. Versions allow several "what-if" Scenarios.
  D. Users must have the same security settings in the Version dimension as they have in the Scenario dimension.

  ---

  C: You use the Scenario and Version dimensions to create individual plans to be reviewed and approved. Each scenario/version combination contains its own set of data for the accounts and other dimensions of each entity. After users complete data entry for an entity for a specific scenario and version, they can submit or promote the data for the entity to another user for review and approval. The intersection of entity, scenario, and version is referred to as a planning unit. Planning tracks the status of each planning unit as it moves through the review process.

  D: Seems likely.

• Question 68:

  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.
  A. Copy data values from one dimensional intersection to another dimensional intersection.
  C. Copy supporting detail.
  D. Copy cell text.
  E. Copy account annotations.

  ---

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

  Product status is a data element you need to include in your Planning application. Each product will have a product status that can vary over time. You will use product status in calculations and will need to report sales by product status and across products in a cross tab format.

  What is the best way to meet all of these requirements?

  A. Define Product Status as a Smart List.
  B. Define Product Status as a Separate Dimension.
  C. Define Product Status as an Attribute.
  D. Define Product Status as a Varying Attribute.
  E. Define Product Status as an alternate hierarchy in the Product dimension.
  C. Define Product Status as an Attribute.

  ---

  Attribute: Characteristic of a dimension member. For example, Employee dimension members may have attributes of Name, Age, or Address. Product dimension members can have several attributes, such as a size, Status, and flavor.

  Reference: Oracle Hyperion Planning, Fusion Edition, Release 11.1.1.3