Oracle EPM Planning Certification
Exam Questions with Correct Verified
Solutions 100% Guaranteed Pass
(Latest Update)
What are the 2 primary use cases for an ASO reporting cube?
A. You want to save data for upper level members.
B. You want to create and execute complex Calculation Manager business
rules.
C. You want to report on Smart lists.
D. You want to report on new Planning data originating from any source,
such as a data warehouse. - ANS ✓C, D
Which 4 statements are true for the Optimize Dimension Feature?
A. Optimizing dimension order is available only for Financials and
Workforce, and only for the provided BSO cubes that are created when you
enable and configure.
B. The new optimized dimension order is maintained even if you enable
additional features or other modules.
C. Optimizing dimension order is available only for BSO cubes in Custom
Planning applications.
D. Optimize dimension order in your test environment before performing it
in the production environment.
Oracle EPM
, 2
Oracle
E. Before you optimize dimension order, refresh the database and then back
up the application and download the snapshot.
F. Optimizing dimension order is available only for Financials and Projects,
and only for the provided BSO cubes that are created when you enable and
configure. - ANS ✓B, D, E, F
What step does NOT need to be completed to manage configuration of Key
Performance Indicators (KPIs) in Planning Financials?
A. Reviewing KPIs in the hierarchy
B. Adding the KPIs to the hierarchy
C. Verifying enabled KPIs
D. Adding KPIs to the alternate hierarchy
E. Adding KPIs in Configure: Financials - ANS ✓B
If you are using your own chart of accounts and want to use dashboards that
graphically depict total results, you must add your accounts under the
appropriate parent. Which 4 parent members do you add your own chart of
accounts to as shared members if you want to include them in predefined
dashboards?
A. OFS_Financial Integrations
B. OFS_Total Operating Expenses
C. OFS_Cash
D. OFS_Rollup Data
E. OFS_Total Revenue
F. OFS_Total Cost of Sales - ANS ✓B,C, E, F
Which 3 methods can be used to import data from BSO cube to an ASO
cube?
Oracle EPM
, 3
Oracle
A. XWRITE business rule
B. Data Maps
C. Valid Intersections
D. Planning Import and Export
E. Data Integration - ANS ✓B, D,E
Which 3 statements are true regarding importing metadata from a flat file
into Planning?
A. You can rename or delete members of attribute dimensions during a
metadata import.
B. When selecting to clear members during the import, any member not
specified is deleted from the outline after importing the dimension unless it
is an ancestor of a member that was specified, or it is a base member of a
shared member that was specified.
C. You can import data forms, dashboards, and infolets by loading a local
import file or an import file from the Inbox server.
D. Your import file must contain a list of Metadata records; and each
metadata record contains a delimited list of property values that matches
the order designated in the header record.
E. You can use import file functionality to import more metadata or to
perform incremental updates from the source system. - ANS ✓B, D, E
When designing with the new Reports for EPM Cloud, which statement is
true about what dimensions are displayed on the Global Point of View
within a report?
A. Dimensions selected by a report viewer for the Global Point of View, are
saved for all viewers.
B. Only one dimension is in the Global Point of View.
Oracle EPM
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller DoctorKen. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.99. You're not tied to anything after your purchase.
