Explore topic-wise InterviewSolutions in .

UDA’s values are never displayed in the reports and hence do not IMPACT REPORT PERFORMANCE.

UDA’s values are never displayed in the reports and hence do not impact report performance.

1. UDA’s- No IMPACT as they do not perform any inherent calculations.

2. ATTRIBUTE DIM- No Impact as they perform only dynamic calculations.

1. UDA’s- No Impact as they do not perform any inherent calculations.

2. Attribute dim- No Impact as they perform only dynamic calculations.

Absolutely no impact as UDA’s does not REQUIRE additional STORAGE SPACE.

Absolutely no impact as UDA’s does not require additional storage space.

Yes. You can QUERY a MEMBER for its UDA in a CALCULATION script.

Yes. You can query a member for its UDA in a calculation script.

UDA represents the CLASS of the MEMBERS. ALIASES are just another NAMES of the members. both are DIFFERENT and has different usage.

UDA represents the class of the members. Aliases are just another names of the members. both are different and has different usage.

Yes, we can do that but it is RECOMMENDED to use SEPARATE rule FILE for each DIMENSION

Yes, we can do that but it is recommended to use separate rule file for each dimension

To automate the PROCESS of creating dimensions with thousands of MEMBERS.

To automate the process of creating dimensions with thousands of members.

The Essbase SERVICES ALSO known analytic will make a lock to all the BLOCKS that CAPTURE the Childs of the initial BLOCK, this process is block locking system.

The Essbase Services also known analytic will make a lock to all the blocks that capture the Childs of the initial block, this process is block locking system.

We will USE the serial estimation EXACTLY when we have one processor and when we have more than one the OPERATION can be part into strings that will wear down the diverse AVAILABLE processors.

We will use the serial estimation exactly when we have one processor and when we have more than one the operation can be part into strings that will wear down the diverse available processors.

The CLARIFICATION behind this is FIGURING a higher MEASURE of BLOCKS than required and for the right results to show up there is a prerequisite for making a top-down calculation.

The clarification behind this is figuring a higher measure of blocks than required and for the right results to show up there is a prerequisite for making a top-down calculation.

The impact of the ATTRIBUTE DIMENSIONS on the performance of the REPORTS is very high due to the DYNAMIC CALCULATION made referencing the reports. If the number of attribute dimensions shown in the reports is high, this will have a negative impact on performance.

The impact of the Attribute dimensions on the performance of the reports is very high due to the dynamic calculation made referencing the reports. If the number of attribute dimensions shown in the reports is high, this will have a negative impact on performance.

The THREE PRIMARY BUILD methods for building dimensions are:-

1. Generation REFERENCES
2. Parent-Child references
3. LEVEL references

The three primary build methods for building dimensions are:-

Dense dimension: It is a dimension in which most data EXISTS for EVERY COMBINATION of dimension MEMBERS.

Sparse dimension: It is a dimension which has less PROBABILITY that data will exist for every combination of dimension members.

Dense dimension: It is a dimension in which most data exists for every combination of dimension members.

Sparse dimension: It is a dimension which has less probability that data will exist for every combination of dimension members.

The two FUNCTIONS are:

1. Fixed NAME LIST
2. DYNAMIC Name List.

The two functions are:

It SIGNIFIES buffer in memory which CONTAINS compressed DATA files (.PAG ).

It signifies buffer in memory which contains compressed data files (.PAG ).

CUSTOM defined MACROS makes use of an internal Ess base macro language that ENABLES to COMBINE calculation FUNCTIONS and also helpful to operate on multiple input parameters.

Custom defined macros makes use of an internal Ess base macro language that enables to combine calculation functions and also helpful to operate on multiple input parameters.

We can MANAGE our SERVER RESOURCES by starting only applications which get heavy user traffic. Right when an application is started, MEMORY is joined by all related data bases.

We can manage our server resources by starting only applications which get heavy user traffic. Right when an application is started, memory is joined by all related data bases.

Attribute dimensions OFFERS more flexibility than UDA’s.

Attribute CALCULATIONS dimensions include five members with the default names SUM, COUNT, min, max and avg are automatically created for the attribute dimensions and are computed dynamically.

Attribute dimensions offers more flexibility than UDA’s.

Attribute calculations dimensions include five members with the default names sum, count, min, max and avg are automatically created for the attribute dimensions and are computed dynamically.

We have IIS for HFM although there is no IIS for OLAP’s. If there is no IIS then it is a TIME TAKING process to recover FINANCIAL data.

We have IIS for HFM although there is no IIS for OLAp’s. If there is no IIS then it is a time taking process to recover financial data.

Attribute dim highly IMPACT the report PERFORMANCE as the ATTRIBUTES are calculated vigorously when referenced in the report. For very LARGE number of attribute dim displayed in the report, the performance could extremely decrease. While filling the data, you have applied both the selection and the REJECTION criteria to a same record. The record will be rejected.

Attribute dim highly impact the report performance as the attributes are calculated vigorously when referenced in the report. For very large number of attribute dim displayed in the report, the performance could extremely decrease. While filling the data, you have applied both the selection and the rejection criteria to a same record. The record will be rejected.

TB First: The ACCOUNTS member Opening Inventory in the Sample.Basic DATABASE is TAGGED as TB First. Opening Inventory COMBINES the value of the first month in every quarter and USES that value for that month’s parent.

E.g. the value for Qtr1 is the same as the value for Jan.

TB Last: The accounts member Ending Inventory in the Sample.Basic database is tagged as TB Last. Ending Inventory combines the value for the last month in every quarter and uses that value for that month’s parent.

E.g. the value for Qtr1 is the same as the value for Mar.

TB First: The accounts member Opening Inventory in the Sample.Basic database is tagged as TB First. Opening Inventory combines the value of the first month in every quarter and uses that value for that month’s parent.

E.g. the value for Qtr1 is the same as the value for Jan.

TB Last: The accounts member Ending Inventory in the Sample.Basic database is tagged as TB Last. Ending Inventory combines the value for the last month in every quarter and uses that value for that month’s parent.

E.g. the value for Qtr1 is the same as the value for Mar.

A grouping of a member in a dimension. You can select and GROUP members based on their related attributes. You can in like MANNER show an ATTRIBUTE when you perform calculations and use FUNCTIONS.

E.g. 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 “coke with 8 Oz with bottles”, this is useful for generating reports.

A grouping of a member in a dimension. You can select and group members based on their related attributes. You can in like manner show an attribute when you perform calculations and use functions.

E.g. 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 “coke with 8 Oz with bottles”, this is useful for generating reports.

The IMPORTANT LOG FILES are:

• Application.log
• Configtool.log
• Essbase.log
• ESS BASE server-install.log
• eas_install.log

The important LOG files are:

Oracle Hyperion Financial Management (HFM) is a complete Web-based application that provides global financial alliance, reporting and EXAMINATION in a single, highly scalable software solution. 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. 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.

Oracle Hyperion Financial Management (HFM) is a complete Web-based application that provides global financial alliance, reporting and examination in a single, highly scalable software solution. 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. 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.

Hyperion Planning is an accounting and FORECASTING application from ORACLE FORMERLY controlled by Hyperion Solutions Corporation. It uses Essbase as a database and calculation engine, a relational repository for business method of reasoning, and fuses a web-based user INTERFACE. The SOFTWARE allows you to add planning or forecast data to actuals.

Hyperion Planning is an accounting and forecasting application from Oracle formerly controlled by Hyperion Solutions Corporation. It uses Essbase as a database and calculation engine, a relational repository for business method of reasoning, and fuses a web-based user interface. The Software allows you to add planning or forecast data to actuals.

Hyperion is a file that EMPOWERS you to access the data quickly. The association was bought by Oracle in 2007 and has continued UPGRADING the product. The Fancy name of Hyperion is Business Intelligence and its motto is to support BETTER business decision-making.

Hyperion is a file that empowers you to access the data quickly. The association was bought by Oracle in 2007 and has continued upgrading the product. The Fancy name of Hyperion is Business Intelligence and its motto is to support better business decision-making.