1z0-533 Exam Dumps - Oracle Hyperion Planning 11 Essentials

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.

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.