Oracle Hyperion Planning 11 Essentials - 1Z0-533 Exam Questions

A. 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. B. To disable the building of @XREF, update the HSPProperties file for the application before you click Create during the application creation process. C. A transparent partition and @XREF calculations could have performance issues for retrievals because data is not stored; it is dynamically calculated. D. 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. E. Planning will build in @XREF calculations in a calc script by default to share data between plan types.

A. You must delete members one by one. B. You should back up all data for the deleted entity members; after a member is deleted, the data is not retained. C. You must delete a reference to a member from all data forms before deleting it from the dimension. D. A database refresh is required after deleting members from the Entity dimension. E. In a data form definition, you selected @IDescendants(IT) for the entity dimension in the page section. The IT member will remain but 2 of its 10 cost centers are being removed. You must remove the reference to "IT" in this data form.

A. DATAEXPORT is faster than Essbase Report. B. DATAEXPORT only exports to flat files. C. DATAEXPORT only exports level zero data. D. Using DATAEXPORT within the FIX statement of a calc script allows you to export specific data sets from an Essbase database. E. DATAEXPORT only exports entire data blocks.

A. Data may not exist for the combination of dense members so you have to create the block before calculating the data value for the block. B. Data may not exist for the combination of dense members so you have to create the block before block loading data to the block. C. Data may not exist for the combination of sparse members so you have to create the block before loading data value to the block. D. Data may not exist for the combination of sparse members so you have to create the block before calculating the data value for the block.

A. If you select the 4-5-4 Weekly distribution option, Planning treats the first month in the quarter as if it has 4 weeks, the second month as If it has 5 weeks, and the third month as if it has 4 weeks. B. Weekly distribution determines how data entered into summary periods should spread to its base periods. C. For Weekly Distribution options 445, 454, 544, the quarterly values are treated as if they are divided into 13 weeks and the weeks are distributed via a pattern you specify. D. If you choose weekly distribution for Custom-based time periods. Planning will not distribute the data values across base periods. E. The only valid weekly distribution options are 445, 454, and 544.

A. Select or reject records based on certain criteria. B. Find and replace manipulations on source records. C. Flip the sign for records with a certain member tagged with a comment. D. Map data based on an external table. E. Split or join columns in a source.

A. The valid locations have not been defined for the business rule. B. The Validate and Launch privileges have not been granted for the data form. C. The business rule was created for another plan type. D. The Validate and Launch privileges have not been granted for the business rule. E. The valid locations have not been defined for the data form. F. The business rule has not been assigned to the data form.

A. Names of plan types B. Year Dimension Name C. Weekly distribution spread D. Number of years E. Default Currency F. Number of plan types G. Initialization of WFP or CapEx Planning modules