1Z0-264 - Hyperion Essbase 9.3 Developer
Go back to Oracle
During the forecast cycle, you adjust Jan, Feb, and Mar data using Smart View for Office. After submitting the adjusted data, you refresh the worksheet. The adjusted data displays, however, the total for Qtr 1 has not changed. Why?
You have not calculated the database
You have the Smart View for Office client installed. In Microsoft Word and PowerPoint, how can Analytic Services data be displayed?
As dynamic data points
Which member property ensures a member is always calculated on retrieval?
When Aggregate Missing Values is set to ON and a consolidation of the dimensions is performed, Analytic Services _______________________.
Overwrites data loaded to upper levels when children have no data
In a database where both the Scenario and Customer dimensions are sparse, what is the effect of the following calculation script? CLEARDATA "Current Year"->"O-IBM";
Data blocks with index entries containing both "Current Year" and "O-IBM"are removed from the database.
What statistics are available in the Database Properties dialog box? (Choose all that apply.)
Existing upper-level blocks
During a CALC ALL or CALC DIM process, Analytic Services calculates sparse and dense dimensions in a specific sequence. What makes the default calculation sequence so efficient?
Analytic Services calculates interior block calculations in existing blocks before creating more data blocks
What data sources are supported in rules files? (Choose all that apply.)
Text files (.TXT)
Microsoft Excel files (.XLS)
Comma-delimited files (.CSV)
Which of the following characterizes the top member in an alternate hierarchy?
Marked excluded from consolidation (~)
A calculation script
Contains a series of calculation commands, equations, and/or formulas.
What do data load rules files enable you to do?
Load data from a SQL data source, scale data, change signs on data
What can be loaded using rules files?
Relational database records, outline members and hierarchies, and member properties
In each database, what determines the configuration of data blocks and the index system?
The configuration of dense and sparse dimensions
Which options are available to manipulate fields in Data Prep Editor?
Join, Move, andSplit
You are designing a database with the following requirements: - Calculate the complete history of product sales from product introduction to the present. - Calculate 12-month rolling averages - Present both calendar year and fiscal year hierarchies in reports. Which time design will simplify your calculations and best enable the report presentation you require?
Fiscal year crossover time design
You are limited to _____ alias table(s) per database.
Analytic Services can create data blocks during all of which set of processes?
Calculation of the DATACOPY command, data load, sparse dimension calculation
Which syntax is correct for a comment in a calculation script?
* Turn off intelligent calculation */
Which statement is true about substitution variables?
They are defined and stored on the server.
Which build method automatically adds shared members?
What is the difference between the CALC DIM and AGG commands?
AGG calculates only parent-childrelationships, CALC DIM performs all calculations in a dimension
Which statement best describes the function of the back calculation section in a calculation script?
It corrects rates that are incorrectly consolidated.
Theoretically, if all database dimensions were configured sparse, what would the data block size be?
Which member property should you use for members that meet the following conditions? - No data is loaded to the member - The member has no member formula - No data is aggregated to the member
Which statement best describes data normalization?
Copying, allocating, or otherwise adjusting input data before consolidation
What is the typical methodology for normalizing rates and drivers?
Which set of statements best describes the role of the Main Rollup section in a calculation script?
Typically uses CALC DIM or CALC ALL commands, creates the bulk of the data blocks generated by the script
During calculation script development, you follow the calculation test procedure below: 1. Clear data from the database 2. Load test input data 3. Run the calculation script 4. Audit calculation results What are the benefits of following this procedure? (Choose all that apply.)
Results are based on your input data and subsequent calculation and no other factors
Reducing the number of blocks to calculate reduces test cycle time
In Smart View for Office - which filter options can you use to select members in the Member Selection dialog box?
Level, UDA, and descendants
Attribute dimensions can have an adverse effect on:
The functions @ALLANCESTORS, @ICHILDREN, and @UDA are all examples of which type of function?
Member set functions
What type of calculations has all of the following characteristics? - Calculate all or a portion of the database - Control the order in which dimensions are calculated - Driven by business processes
A data load rules file provides which options to load data?
Add to existing values, subtract from existing values, overwrite existing values
What are the three (3) principal methods used for focusing calculations? (Choose three.)
Cross-dimensional operators (->)
In Smart View for Office - before you refresh a worksheet you activate the display option to suppress #Missing values. When you refresh your worksheet, Analytic Services returns:
Rows with data only and all columns
If a dimension is missing in your data source, what does Analytic Services do when you load the data?
Analytic Services loads data only if your rulesfiles specifies the missing dimension.