Looking for Hyperion technical Interview Questions, the below questions and answer
set helpful for experienced or freshers. A lot of opportunities you can find in
many IT companies. You will have opportunity to move further in your career.
these Hyperion Technical Interview Questions can be a good help as Hyperion
Developer.
Ques: 1. What do you understand
by Hyperion?
Ans: A database that allows you to access the data at a
very fast pace. The Hyperion’s company was bought by Oracle in 2007 and Oracle
continuously improving the product. Hyperion is also known as Business Intelligence
and it focuses to support better business decision-making.
Hyperion is the market leader in
Operational, Financial and Strategic Planning. It contains the applications for
reporting, Planning, dashboards, Analysis, score carding, consolidation, Workspace,
Master Data Management and Foundation.
So, a BI system can be called a
decision support system (DSS). However, Business Intelligence is sometimes used
as a synonym for competitive intelligence, because they both support decision
making, BI Uses technologies, processes, and application to analyze mostly
internal, structured data and business processes while competitive intelligence
gathers, analyzes and disseminates information with a topical focus on company
competitors.
Ques: 2. What is the significance
of Attribute dimensions in report performance?
Ans: For very large number of attribute dimensions
displayed in the report, the performance could extremely decrease. While
filling the data, you have applied both the selection and the rejection criteria
to the same record. The record will be rejected.
Attribute dimension highly impact
the report performance as the attributes are calculated vigorously when
referenced in the report.
Ques: 3. What is Hyperion
Planning?
Ans: Hyperion Planning is a budgeting and forecasting
application from Oracle formerly owned by Hyperion Solutions Corporation.
Hyperion Planning uses Essbase (s multidimensional database product sold by
Hyperion) as a database and calculation engine, a relational repository for
business logic, and includes a web-based user interface. This software allows
to add planning or forecast data to actuals. You can use Web Forms to add the
planning data or use the Excel SmartView tool. Most of the Hyperion reporting
tools work great with planning.
Ques: 4. Can you Explain the
Attributes?
Ans: Classification of a member in a dimension is known
as an attribute. We can do selection of group members based on their associated
attributes. We can also specify an attribute while performing calculations and
along with we can use calculation functions. As example, the database in Sample
Basic with product dimension has some attributes like package type, size, and
flavor. We can add attributes to the dimensions and can retrieve data.
Ques: 5. What Are Filters in
Hyperion?
Ans: A method of controlling access to database cells in
Hyperion essbase. A filter is the most detailed level of security, allowing you
to define varying access levels different users can have to individual database
values. If you want to grant access to all dimensions, then you wouldn’t use a
filter. Just grant read access for the database to the user and/or group. The
only reason you would use a filter is if you wanted to restrict access.
Ques: 6. What do you understand
by Dense and Sparse Dimensions?
Ans: Dense Dimension: A dimension which has the high probability that
data exists for every combination of dimension members.
Sparse Dimension: A dimension which has low probability that data
exists for every combination of dimension members.
Ques: 7. What do you understand
by TB First and TB Last?
Ans:
TB First: in the Sample. Basic database, the accounts
member Opening Inventory is tagged as TB First. Opening Inventory consolidates
the value of the first month in each quarter and uses that value for that
month’s parent. For example, the value for Qtr1 is the same as the value for
Jan.
TB Last: in the Sample. Basic database, the accounts
member Ending Inventory is tagged as TB Last. Ending Inventory consolidates the
value for the last month in each quarter and uses that value for that month’s
parent. For example, the value for Qtr1 is the same as the value for Mar.
Ques: 8. What is the key
difference between UDA’s and Attribute dimensions?
Ans: Attribute dimensions provides more flexibility than
UDA’s. Attribute calculations dimensions which include five members with the
default names sum, count, min, max and avg are automatically created for the
attribute dimensions and are calculate dynamically.
Ques: 9. How many primary build
methods are available in Hyperion for building dimensions?
Ans: There are three primary build methods available for
building dimensions. They are:
- Generation references
- Parent-Child references
- Level references
Ques: 10. What are the attributes
in Hyperion?
Ans: Attributes are the classifications of a member in a
dimension. You can select, and group the members based on their associated
attributes. You can also specify an attribute when you perform calculations and
use calculation functions.
Eg: The database in Sample Basic
which has product dimension has some attributes like size, package type, and
flavor. We can add these attributes to the dimensions where we can retrieve the
data like for example to retrieve “Pepsi with 10 Oz with Cans” this is useful
for generating reports.
Ques: 11. What are the three
options specified in Username and Password management under the security tab in
Essbase server properties?
Ans:
1. Login attempts allowed before
username is disabled.
2. Number of inactive days before username is disabled.
3. Number of days before user must change password.
2. Number of inactive days before username is disabled.
3. Number of days before user must change password.
Ques: 12. What are two storage
options available in Hyperion Essbase? What are the differences?
Ans:
ASO (Aggregate Storage Option):
- If we have large number of dimensions (generally more than 10).
- Most of the dimensions are sparse.
- We cannot write back in ASO. I heard recently that ASO will also have the write back capability.
BSO (Block Storage Option):
- Dimensions are less and dense (recommended values for no of dim are between 4 and 8).
- We can write back hence much suited for planning applications. Financial applications are generally dense structures and normal analytical cubes are sparse. Here we also need to understand what these dense and sparse members are. When the intersections or cells of two dimensions mostly contain a value, it is dense.
Ques: 13. What is Oracle Hyperion
Financial Management (HFM)?
Ans: Oracle Hyperion Financial Management, part of the
Oracle EPM Suite, supports the collection, consolidation and reporting of
financial results in multiple GAAPs as well as IFRS, and the reconciliation of
differences among the various standards.
Oracle Hyperion Financial
Management (HFM) is a comprehensive Web-based application that delivers global
financial consolidation, reporting and analysis in a single, highly scalable software
solution. Hyperion Financial Management can be deployed quickly to integrate
data from multiple Oracle and non-Oracle transactional systems, provide
top-side reporting that conforms to IFRS requirements, and help organizations
make the transition to IFRS.
Ques: 14. What do you understand
by LRO's( Linked Reporting Objects)?
Ans: They are specific objects like files, cell notes,
or URL's associated with specific data cells of Essbase database. You can link
multiple objects to a single data cell. These linked objects are stored in the
server. These LRO's can be exported or imported with the database for backup
and migration activities.
Ques: 15. Why do objects gets
locked and when does this happens?
Ans: Objects gets locked to prevent users to make simultaneous
and conflicting changes to Essbase database objects. By default, whenever an
object is accessed through Administrative services console or Excel spreadsheet
add-in, it gets locked.
Ques: 16. What is custom based
macro?
Ans: Hyperion Essbase macros that we write with Essbase
calculator functions and special macro functions. Custom-defined macros use an
internal Essbase macro language that enables you to combine calculation
function and operate on multiple input parameters.
Ques: 17. What Are the types of
partitioning options available in Hyperion Essbase?
Ans: Three types of partitioning options are available
in Hyperion Essbase:
- Replicated partition.
- Transparent partition
- Linked partition.
Ques: 18. What Are the different
types of Log Files in Hyperion?
Ans: There are many log files hyperion essbase, but the
important log files are:
- Application log
- Essbase.log
- Configtool.log
- Eas_install.log
- Essbase server-install.log
Ques: 19. On what basis you will
decide to invoke a serial or parallel calculation method?
Ans: If we have a single processor, we will use serial
calculation but if we have multiple processors we can break the task into
threads and make them run on different processors.
Ques: 20. What is block locking
system?
Ans:Analytic services (or Essbase Services) locks the
block and all other blocks which contain the Children of that block while
calculating this block is block locking system.
No comments:
Post a Comment