[Free] 2018(Jan) EnsurePass Testinsides Oracle 1z0-533 Dumps with VCE and PDF Download 21-30

Ensurepass.com : Ensure you pass the IT Exams 2018 Jan Oracle Official New Released 1z0-533
100% Free Download! 100% Pass Guaranteed!

Oracle Hyperion Planning 11 Essentials

Question No: 21

Fragmentation in an underlying Planning Essbase database that is caused by what two actions?

  1. Delete member from a sparse dimension.

  2. Delete member from a dense dimension.

  3. Renaming a member.

  4. Renaming an alias.

  5. Submitting data / deleting data frequently.

Answer: B,E

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

Question No: 22

Identify the two statements about the Planning Import security utility.

  1. Imports Planning application access for users and groups

  2. Imports users and groups into Planning

  3. Requires the source text file to be named PLANSECFILE.txt

  4. Can be scheduled to run nightly using an encrypted password

  5. Clears existing security definitions by default before the import takes place

Answer: A,D

Explanation: The Import Security utility performs a Oracle Hyperion Planning security import.

A: The ImportSecurity utility loads access permissions for users or groups from a text file

into Planning.

(To add users or groups, see the Oracle Hyperion Enterprise Performance Management System Security Administration Guide. . not B)

Importing access permissions overwrites existing access assignments only for imported members, data forms, data form folders, task lists, Calculation Manager business rules, and Calculation Manager business rule folders. All other existing access permissions remain intact. (not E).

The SL_CLEARALL parameter clears all existing access permissions; you can use it with other parameters to replace existing access permissions. See also Exporting Access Permissions.

D: To import access permissions into Planning:

Locate the ImportSecurity utility by navigating to the bin directory.

From the Command Prompt, enter this case-sensitive command, one space, and the parameters, separating each with a comma. Enclose the parameters with double quotation marks:

ImportSecurity.cmd [-f:passwordFile] “appname,username,[delimiter],[RUN_SILENT],[SL_CLEARALL]”

This command can be scheduled.

Question No: 23

Identify the two true statements about Enterprise performance Management Architect.

  1. If you decide to implement EPMA, all Planning applications must be EPMA-deployed applications.

  2. EPMA-deployed applications may either use EAS Business Rules or Calculation Manager in

  3. You can create Planning, TM, Essbase, and FDM applications in EPMA.

  4. Data can be shared from a Planning application to an FM application within EPMA.

  5. EPMA can be used by end users to manage and update member properties such as hierarchies and aliases.

  6. 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: D,F

Explanation: D: EPMA Data Synchronization-Enables data synchronization within Hyperion applications. You can use the Data Synchronizer to:

  • Create data movement synchronizations between Hyperion applications. For example, an administrator can synchronize data between two Financial Management; two Planning applications, and between one Financial Management(FM)and a Planning application

  • Create data mappings for reuse

  • Create flat file and interface table mappings to import data into Hyperion applications

F: You can use theEnterprise performance Management Architectto create filters to select specified members of a dimension. For example, select the Balance

Sheet accounts of the Account dimension. This enables you toEnterprise performance Management Architect

Question No: 24

Based on the following design:

Plan type 1: Summary Plan type with all Accounts by Entity Plan type 2: Sales Plan type with Sales by Product by Entity

Plan type 3: Salary Plan type with Salary Expense by Employee by Entity

You need to get Sales data to the Summary plan type. Identify the two true statements about sharing revenue data between the sales plan type and the summary plan type.

  1. Planning will build in @XREF calculations in a calc script by default to share data between plan types.

  2. A replicated partition could be created to replicate data from the sales plan type to the summary plan type and this would be done if we wanted to store the sales data in the summary plan type.

  3. A transparent partition and @XREF calculations could have performance issues for retrievals because data is not stored; it is dynamically calculated.

  4. A calc export script on the source database with the DATAEXPORT command could be used to export data out of the revenue plan type and calc import script on the target database with the DATAIMPORT command could be used to import the data file to the

    summary plan type.

  5. To disable the building of @XREF, update the HSPProperties file for the application before you click Create during the application creation process.

Answer: B,C

Explanation: B: Replicated Partition:

A portion of a database, defined through Partition Manager, used to propagate an update to data mastered at one site to a copy of data stored at another site. Users can access the data as though it were part of their local database.


Transparent partition:

A form of shared partition that provides the ability to access and manipulate remote data transparently as though it is part of your local database. The remote data is retrieved from the data source each time you request it. Any updates made to the data are written back to the data source and become immediately accessible to both local data target users and transparent data source users

Note: @XREF

Enables a database calculation to incorporate values from another Essbase database. The following terminology is used to describe the @XREF function:

Data target: the database on which the current calculation is running (that is, the database on which the @XREF call originates).

Data source: the database that is queried by the @XREF function. This database may be remote (that is, on a different machine than the data target).

Point of view: the member combination currently being calculated on the data target (that is, the member combination that identifies the left hand side of a calculation).

The @XREF function retrieves values from a data source to be used in a calculation on a data target. @XREF does not impose member and dimension mapping restrictions, which means that the data source and data target outlines can be different.

Note #2:

Hyperion planning#39;s Plan Types treated as individual databases in underlying Essbase database comes with inherent facility to share data and dimension members across plan

types in Hyperion Planning or equivalent databases in underlying Essbase. This reduces the need for additional development/maintenance effort when compared to Planning systems based on Standalone Essbase. The Hyperion Planning user would seldom realize that the dimension members belong to multiple databases. While this might be an area of concern while using Standalone Essbase to build planning system.

Question No: 25

Identify the two true statements assuming you are working with a single application with multiple plan types.

  1. A user-defined custom dimension may exist in one plan type but not the other plan types.

  2. A user-defined custom dimension may have members in one plan type but not the remaining plan types.

  3. All members in the entity dimension must exist in all plan types.

  4. All members in the accounts dimension must exist in all plan types.

  5. All periods must exist in all plan types.

Answer: A,E Explanation:

A: Properties for User-Defined Custom Dimensions include property Valid for Plan Types which is used to select plan types for which the dimension is valid. Clearing this option makes all members of the dimension invalidfor the deselected plan type.

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.

Note: Specify one to three plan types for the application. A separate Essbase database is created for each plan type. You cannot change the name or number of plan types after creating an


As you create accounts, entities, and other elements of the application, you associate them with

plan types, so the database for each plan type contains only information relevant to the plan

type. This optimizes application design, size, and performance.

Question No: 26

Identify the true statements regarding Supporting Detail. Select all that apply.

  1. Importing Supporting Detail from Excel is supported.

  2. Supporting Detail must be entered cell by cell; entry for multiple columns at once is not possible

  3. Supporting Detail can contain a hierarchy with an aggregation of values for that hierarchy.

  4. Supporting Detail can be viewed using the Smart View Add-in Essbase Provider.

  5. Supporting Detail is stored in Essbase.

Answer: A,C,D

Explanation: A: To add supporting detail that calculates values in a data form: 1 Open a data form in Excel,

  1. In the data form, select the data cells for which you want to add detail.

  2. Select Hyperion gt; Supporting Detail. For Office 2007, click Supporting Detail in the Task section of the Hyperion ribbon.

  3. Etc.

  1. Enter data for the items for which you want to set or calculate values.

    When you enter numbers into the Supporting Detail window, use the scaling that was set up for

    the data values in the data form. 8 Click OK.

    Values are dynamically calculated and aggregated before the data is saved.

    C: Supporting detail can include text, values, and operators that define how data aggregates.

    Supporting detail also provides a way to drill down into data to better understand its basis.


    example, if the bottom-level member in your outline is pens, you can add line items in supporting

    detail for ballpoint, fountain, marker, and so on. Then you can aggregate the detail values to the

    pen member in the outline.

    D:Oracle Hyperion Smart View for Office (Excel, PowerPoint, Word, and Outlook), are

    some of the various Oracle tools that enable users to interact with an Oracle Essbase application.

    Oracle Hyperion Smart View for Office (Smart View) is a component of Hyperion Foundation Services. Smart View provides a common Microsoft Office interface designed specifically for Oracle#39;s Enterprise Performance Management (EPM) and Business Intelligence (BI). Using Smart View, you can view, import, manipulate, distribute and share data in Microsoft Excel, Word and PowerPoint interfaces. It is a comprehensive tool for accessing and integrating EPM and BI content from Microsoft Office products.


    not E: Supporting details are stored in Planning Applications RDBMS not in Essbase.

    Question No: 27

    As a Planning end user, you need toadd additional commentary to your plan, documenting assumptions and other notes. What are the six available options to add this information?

    1. Supporting detail

    2. Planning unit annotations

    3. Cell text

    4. Free form text (if defined by your Planning administrator)

    5. Smart Lists (if defined by your Planning administrator)

    6. Attach a document to a data form from Workspace (if enabled by your Planning administrator)

    7. Financial Reporting Annotations in a Financial Reporting document (against the Planning application)

Answer: A,B,C,D,F,G

Explanation: Incorrect answer:

With a smart list you can only select from pre-defined options in a list-

Question No: 28

Identify two true statements about the DATAEXPORT calc script command.

  1. Using DATAEXPORT within the FIX statement of a calc script allows you to export specific data sets from an Essbase database.

  2. DATAEXPORT only exports level zero data.

  3. DATAEXPORT only exports to flat files.

  4. DATAEXPORT only exports entire data blocks.

  5. DATAEXPORT is faster than Essbase Report.

Answer: A,E

Explanation: A: To develop a calculation script that exports a subset of data, you first specify the SET

DATAEXPORTOPTIONS command to define options for export content, format, and process Use FIX…ENDFIX or EXCLUDE…ENDEXCLUDE calculations to select a slice of the database and use a DATAEXPORTCOND command to select data based on data values.

Note: The DATAEXPORT command enables calculation scripts to export data in binary or text, or directly to a relational database. A set of data-export-related calculation commands qualify what

data to export and provide various output and formatting options.

Compared to using other methods to export data, using a calculation script has the following

advantages and disadvantages: Advantages:

Enables exporting a subset of data.

  • Supports multiple targets: flat files, relational databases, and binary files (not B, C, D)

  • Provides many flexible options for type and format or data.

  • As part of a calculation script, can be easily deployed in a batch process.

  • Can be very fast when the dynamic calculation export option is not used because DATAEXPORT directly accesses Kernel storage blocks in memory. (E)

  • Provides, through binary export-import, a faster way to back up and restore data because the

    compressed format used by binary export requires less storage for the export files.

  • Can be used as a debug tool to trace batch calculation results by using the DATAEXPORT

    command before and after other calculation commands to track data changes. Disadvantages

    Contains limited data formatting options compared to Report Writer formatting.

    Question No: 29

    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

    What is the block size in bytes?

    1. Block size = 40 * 17 * 2

    2. Block size = 40 * 17 * 2 * 8

    3. Block size = 50 * 17 * 5 * 8

    4. Block size = 50 * 17 * 5

    5. Block size = 100 * 500 * 8

    6. Block size = 100 * 500

    Answer: B

    Explanation: We need to multiple the stored (not the total) members of the dense dimensions (here Measures: 40, Time:17, and Dense:2) with 8 to calculate the block size.

    Note: Data block size is determined by the amount of data in particular combination of dense dimensions. For ex: when you change the dense or sparse configuration of one or more dimensions in the database, the data block size changes. Data block size is 8n bytes, where n is the number of cells that exist (ie. Stored, not total) for that combination of dense dimensions.Note: Optimal range is 8 to 100 kb

    Question No: 30

    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?

    1. Form Managementgt;gt;Display tab

    2. Form Managementgt;gt; Options tab

    3. Preferencesgt;gt;Database Settings tab

    4. Preferencesgt;gt; Display Options tab

    5. This change can only be made by the Planning Administrator.

    Answer: D

    Explanation: All users can set personal preferences in the current application. To set personal preferences:

    1. Select File, then Preferences.

    2. Click Planning, then perform an action:

  • Select Application Settings to set e-mail options, select an alias table, and set options for member selection and workflow.

  • Select Display Options to set options for number formatting, page selection, warnings for large data forms, and the number of dimensions to show on a page.

100% Ensurepass Free Download!
Download Free Demo:1z0-533 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-533 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Add a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.