If you are looking for free 1z0-533 dumps than here we have some sample question answers available. You can prepare from our Oracle 1z0-533 exam questions notes and prepare exam with this practice test. Check below our updated 1z0-533 exam dumps.
DumpsGroup are top class study material providers and our inclusive range of 1z0-533 Real exam questions would be your key to success in Oracle Oracle Hyperion Certification Exam in just first attempt. We have an excellent material covering almost all the topics of Oracle 1z0-533 exam. You can get this material in Oracle 1z0-533 PDF and 1z0-533 practice test engine formats designed similar to the Real Exam Questions. Free 1z0-533 questions answers and free Oracle 1z0-533 study material is available here to get an idea about the quality and accuracy of our study material.
Sample Question 4
What differentiates a user-defined custom dimension from the Entity and Accountdimensions?
A. You can only add custom attributes to user-defined custom dimensions. B. You assign valid plan types for the user-defined custom dimension at the dimensionlevel. C. You assign data types for the user-defined custom dimension at the dimension level. D. You cannot: assign security for user-defined custom dimensions. E. You can easily delete a user-defined custom dimension in Planning but you cannotdelete an Entity dimension.
Answer: B
Explanation: 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.
Sample Question 5
You have the following design requirement: You need to track customer status for a salesplanning application. Valid options for customer status include: Active, Inactive, Out ofBusiness. 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
Answer: C
Explanation: 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.
Sample Question 6
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
Answer: A,D
Explanation: 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
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.
Reference: O r a c l e h y p e r i o n s m a r t v i e w f o r o f f i c e ,
F u s i o n e d i t i o n
Sample Question 7
The budget office analyst needs to enter and plan data, use the Planning spreading featurethat allow users to spread budget data based on last year's actuals, and modify data forms.What two roles should be provisioned for this user?
A. Grid Spread B. Planner C. Interactive User D. Mass Allocate E. Offline User
Answer: B,C
Explanation:
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
Sample Question 8
Why is the Create Blocks function in calc scripts and Business Rules important inPlanning?
A. Data may not exist for the combination of dense members so you have to create theblock before calculating the data value for the block. B. Data may not exist for the combination of sparse members so you have to create theblock before calculating the data value for the block. C. Data may not exist for the combination of dense members so you have to create theblock before block loading data to the block. D. Data may not exist for the combination of sparse members so you have to create theblock before loading data value to the block.
Answer: B
Explanation: Where needed in the calculation script, you can use multiple SET
CREATEBLOCKONEQ commands to define the Create Blocks on Equation setting value
You are designing a new Planning application. Which two requirements dictate multipleplan types in a single Planning application?
A. Multiple currencies are required. B. Currency rates must be kept in a separate database. C. Sales are planned by product and channel, and salary expenses are planned byposition. D. Security is applied to the Entity dimension but can differ for users for accounts "sales"and "expenses". E. You have decided to implement the Capital Expense planning module in addition to PSLbudgeting. F. Data cannot be shared across the Organization dimension.
Answer: C,E
Explanation: C: When you define an entity member, you assign a plan type for which it is
valid. If you do not
assign a plan type to a member, that member’s children do not have access to that plan
type. If
you move a member, and the new parent of that member is valid for different plan types,
then
the member remains valid only for the plan types it has in common with the new parent.
Your organization may require that different entity members prepare different plans. For
example, in your organization all entity members may submit expense plans, but entity
members that are cost centers do not submit revenue plans. When you define entity
members
you specify the plan types for which they are valid. Because data forms are associated with
plan
types, this allows you to control which entity members can enter data for each plan type.
E: You would need two plan type. To add a Capital Expense plan type to an existing
application see Note below.
Note: To add the Capital Asset Planning plan type to a Planning application:
1 In Performance Management Architect, select Navigate, then Administer, then
Application Library.
2 In the Application Library, right-click the application to which you want to add the Capital
Asset Planning
plan type, select Initialize, then select Capital Asset or Workforce and Capital Asset if the
application will use both plan types.
3 To confirm the initialization, click Yes.
Sample Question 10
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.
Answer: A,C,D,E
Explanation: 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
Sample Question 11
You need to build the Entity into your Classic Planning application. You can dynamicallybuild the Entity dimension in the Planning application via: (Select all that apply)
A. Essbase load rules B. Oracle Data Integrator (ODI) C. Data Integration Management (DIM) D. Data Relationship Management (DPM) E. Outline Load Utility F. EPMA
Answer: B,C,E,F
Explanation: You candynamically build the Entity dimension in the Planning
applicationwith the help ofODI, DIM and EPMA.
With Version 11(and later)you can also use the outline loader.
Incorrect:
not A:you can't use essbase load rules, metadata has to be loaded to planning and then
pushed to essbase.
Sample Question 12
What are valid data types for the Accounts dimension? Select all that apply.
A. Currency B. Non-currency C. Percentage D. Saved Assumption E. Text F. Smart List G. Date
Answer: A,B,C,E,F,G
Explanation: Data types:
How values are stored and displayed:
*Currency (A)
*Non-Currency (B)
*Percentage (C)
*Smart List (F)
*Date (G)
*Text (E)
*Unspecified
F
or accounts, if Data Type is set to any value except Currency, you must set Exchange Rate
Type
to None.
Note:
The accounts dimension is a dimension type that makes accounting intelligence available.
Only one dimension can be defined as Accounts.All members in the accounts dimension
inherit the accounts property. You can create an outline that does not have an accounts
dimension.
Sample Question 13
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
Answer: A,B,D,E
Explanation: 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
