Want to know Examcollection 1Z0-533 Exam practice test features? Want to lear more about Oracle Oracle Hyperion Planning 11 Essentials certification experience? Study Simulation Oracle 1Z0-533 answers to Regenerate 1Z0-533 questions at Examcollection. Gat a success with an absolute guarantee to pass Oracle 1Z0-533 (Oracle Hyperion Planning 11 Essentials) test on your first attempt.
Q21. 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
Answer: A
Q22. You are designing a monthly projection Planning application. A starting point projection file is received with the current month data. Data forms, Business Rules, and Essbase data load rules, and reports should always focus on the current projection month.
What is most efficient way to design the components to reduce maintenance each month?
A. Manually update the forms each month and use a "CurMth" substitution variable for Business Rules, Essbase data load rules, and reports.
B. Manually update the forms each month; Use "CurMo" Global variable for Business Rules and use a "CurMth" substitution variable for Essbase data load rules, and reports.
C. Use the Planning data form utility to update data forms and use a "CurMth" substitution variable for Business Rules, Essbase data load rules, and reports.
D. Use a "CurMth" substitution variable for data forms, Business Rules, Essbase data load rules, and reports.
E. Use the Planning data form utility to update data forms; Use "CurMo" Global variable for Business Rules and use a "CurMth" substitution variable for Essbase data load rules, and reports.
Answer: E
Q23. 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
Answer: B
Q24. 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
Answer: C
Q25. Identify the two true statements about Enterprise performance Management Architect.
A. If you decide to implement EPMA, all Planning applications must be EPMA-deployed applications.
B. EPMA-deployed applications may either use EAS Business Rules or Calculation Manager in
11.1.1.3.
C. You can create Planning, TM, Essbase, and FDM applications in EPMA.
D. Data can be shared from a Planning application to an FM application within EPMA.
E. EPMA can be used by end users to manage and update member properties such as hierarchies and aliases.
F. In the Dimension Library, you can maintain one full dimension (for example. Account) but filter portions of the dimension for different applications (for example, Revenue accounts. Balance Sheet)
Answer: BD
Q26. 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.
Answer: A
Q27. Planning utilizes which type of database to store data (for example, "the numbers")?
A. Block Storage Option Essbase database
B. Aggregate Storage Option Essbase database
C. Relational database
D. XOLAP database
E. Proprietary database
Answer: A
Q28. You are designing the storage properties for your Planning application. What two design principles should you follow related to the dynamic calc storage property?
A. Dynamically calculated members should roll up to stored members.
B. You cannot calculate and store dynamic calculated members in calc scripts and business rules.
C. Consider dynamic calc members on sparse parents with 100 t children.
D. Tagging upper-level members of sparse dimensions can reduce block size.
E. If you use a large number of dynamic calcs, you should consider increasing the Dynamic Calculator Cache.
F. Consider Dynamic Calc and Store over Dynamic Calc.
Answer: BE
Q29. Name the valid ways to create blocks in an underlying Essbase database. Select all that apply
A. Copy data
B. Load data
C. Create block on Equation
D. Aggregate data
Answer: ABC
Q30. Identify the two statements about the Planning Import security utility.
A. Imports Planning application access for users and groups
B. Imports users and groups into Planning
C. Requires the source text file to be named PLANSECFILE.txt
D. Can be scheduled to run nightly using an encrypted password
E. Clears existing security definitions by default before the import takes place
Answer: AD
Q31. 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.
Answer: B
Q32. 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
Answer: C
Q33. You have a measure in your Accounts dimension for "Price". Price Is Input by users (along with Units). Sales is calculated as Units * Price. Identify the correct property that should be assigned to Price to meet this requirement.
A. Stored
B. Dynamic Calc
C. Dynamic Calc and Store
Answer: A
Q34. Planning administrators can access which four administration tools via the EPM Workspace?
A. Planning
B. EPMA
C. ODI
D. LCM
E. Calculation Manager
F. EAS
G. FR Studio
Answer: ABDE
Q35. Identify the one Planning component that is not accessible over the Web.
A. Dimension Editor for Planning
B. Shared Services
C. Exchange Rates Definition
D. Planning Utilities
E. Create and Manage Database Options
F. Create Data Sources
Answer: D
Q36. Identify the true statements regarding Supporting Detail. Select all that apply.
A. Importing Supporting Detail from Excel is supported.
B. Supporting Detail must be entered cell by cell; entry for multiple columns at once is not possible
C. Supporting Detail can contain a hierarchy with an aggregation of values for that hierarchy.
D. Supporting Detail can be viewed using the Smart View Add-in Essbase Provider.
E. Supporting Detail is stored in Essbase.
Answer: ACDE
Q37. Identify the correct set of required dimensions for Planning.
A. Account
B. Entity
C. Version
D. Years and Periods combined into one dimension
E. Scenario
F. Minimum one user-defined dimension
Answer: ABCDE
Q38. 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
Answer: AE
Q39. In a non-multicurrency Planning application, what three things happen if all options are checked for Refresh Database?
A. Dimension and member changes are pushed to Essbase.
B. Cell text and supporting detail changes are pushed to Essbase.
C. Security filters for dimensions and members are pushed to Essbase.
D. Security filters for shared members are pushed to Essbase.
E. Data changes are pushed to Essbase.
Answer: ACD
Q40. A planning end user opens a data form and sees a long list of entities in the drop-down list in the Page section. She would like to shorten this list and use the search functionality instead. How can she change the number of members needed on a form to initiate a page dropdown search?
A. Form Management>>Display tab
B. Form Management>> Options tab
C. Preferences>>Database Settings tab
D. Preferences>> Display Options tab
E. This change can only be made by the Planning Administrator.
Answer: D