1Z0-533 Online Practice Questions and Answers

Correct Answer: BC

Planner:

The majority of Hyperion Planning users are planners who are responsible for department or project budgets. They conveniently work over the Web or the Spreadsheet Add-in to:

Enter, submit, and view data

Use pre-defined policies, procedures, routines, reports, and worksheets to enter, analyze, and report on application data

Interactive User:

Examples of an interactive user include a department head, sales director, or unit manager who submits budget information and data for approval. Interactive users can enter and view data. They can also create, maintain, and initiate:

Data entry forms on the Web

Spreadsheet Add-in worksheets

Reports using Hyperion Reports

Integrations using Hyperion Application Link

Business rules using Hyperion Business Rules

Correct Answer: AB

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

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.

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

Correct Answer: CDE

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.

Correct Answer: B

Asymmetric rows and columns are ones in which different sets of members are selected across the same dimension.

Correct Answer: BE

Fragmentation is unused disk space.

EssBase Database fragmentation is likely to occur with the following:

Read/write databases that users are constantly updating with data (E).

Databases that execute calculations around the clock

Databases that frequently update and recalculate dense members (B)

Data loads that are poorly designed

Databases that contain a significant number of Dynamic Calc and Store members

Databases that use an isolation level of uncommitted access with commit block set to zero

Correct Answer: ACE

A: Business Rules can be assigned to data forms.

C: You can manage database locations, and the access privileges of repository objects that are assigned to them, using the Location Editor. You can use the Location Editor to create, edit, and copy database locations, assign new access privileges to locations, copy access privileges from one location to another, and copy business rules from one location to another.

E: When you validate a business rule, Business Rules determines whether the member or members you select exist in the database and whether the syntax of the business rule is correct. You need to have access privileges to all rules in the sequence before you can launch it.

Reference: Hyperion Business Rules, Administrative Guide, Release 9.3.1

Correct Answer: AB

You can change the status of the Employee through options from a Drop down/Smart List on a data form by running a Business Rule.

Incorrect answer:

Deleting the employee is a bad praxis. It would remove old salary entries.

You do not access the attributes directly on the Employee dimension.

Note: The Workforce Planning Module for Hyperion Planning provides a robust set of calculations and pre-defined web-forms that allows organizations to track and budget down to the benefit-level for each employee.

Correct Answer: AB

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.