Hyperion Interview Questions and Answers (Business Opportunities - Advertising Service)

USNetAds > Business Opportunities > Advertising Service

Item ID 130406634 in Category: Business Opportunities - Advertising Service

Hyperion Interview Questions and Answers


Free Online Advertising
Free Internet Web Site Advertising.


UK Free Classifieds
United Kingdom Free Ads Website.
100% Free Ad Posting.


Canada Free Ads
Popular Online Classifieds in Canada.
No Sign up, No Email Required to Post.

Hyperion Interview Questions and Answers

Hyperion Essbase Interview Questions and Answers

Q.How do you optimize outline?
Ans: Usually the outline is optimized using the hourglass design for dimension ordering i.e,
· Dimension with Accounts tag
· Dimension with Time tag
· Largest Dense dimension
· Smallest dense dimension
· Smallest Sparse dimension
· Largest Sparse dimension

Q.What are the ways to improve performance during data loads?

Ans: There are several ways to optimize load

Grouping of Sparse member combinations
Making the data source as small as possible
Making source fields as small as possible
Positioning the data in the same order as the outline
Loading from Essbase Server
Managing parallel data load processing
Q.What are the design considerations for calculation optimization?

Ans: You can configure a database to optimize calculation performance. The best configuration for the site depends on the nature and size of the database.

Block Size(8Kb to 100Kb) and Block Density
Order of Sparse Dimensions
Incremental Data Loading
Database Outlines with Two or More Flat Dimensions
Formulas and Calculation Scripts
Q.When does Fragmentation occur?

Ans: Fragmentation is likely to occur with the following:

Read/write databases that users are constantly updating with data
Databases that execute calculations around the clock
Databases that frequently update and recalculate dense members
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
Q.How can you measure fragmentation?

Ans: You can measure fragmentation using the average clustering ratio or average fragmentation Quotient.

Using the average fragmentation quotient

Any quotient above the high end of the range indicates that reducing fragmentation may help performance

Small (up to 200 MB) 60% or higher

Medium (up to 2 GB) 40% or higher

Large (greater than 2 GB) 30% or higher

Using the average clustering ratio:

The average clustering ratio database statistic indicates the fragmentation level of the data (.pag) files. The maximum value, 1, indicates no fragmentation.

Q.How do you can prevent and remove fragmentation?

Ans: You can prevent and remove fragmentation:

To prevent fragmentation, optimize data loads by sorting load records based upon sparse dimension members. For a comprehensive discussion of optimizing data load by grouping sparse members.
To remove fragmentation, perform an export of the database, delete all data in the database with CLEARDATA, and reload the export file.
To remove fragmentation, force a dense restructure of the database.
Q.Why is database restructuring?

Ans: As your business changes, you change the Essbase database outline to capture new product lines, provide information on new scenarios, reflect new time periods, etc. Some changes to a database outline affect the data storage arrangement, forcing Essbase to restructure the database.

Related Link: Click here to visit item owner's website (0 hit)

Target State: Iowa
Target City : All Cities
Last Update : Aug 03, 2019
Number of Views: 42
Item  Owner  : best interview question
Contact Email:
Contact Phone: (None)

Friendly reminder: Click here to read some tips.
USNetAds > Business Opportunities > Advertising Service
 © 2019 USNetAds.com
2019-11-18 (0.071 sec)