1⟩ Tell me can we have one ASO database and one BSO database in one single application?
No, because we define the ASO/BSO classification at Application level, not at the database.
Hyperion
Home Data Warehouse Hyperion
“Hyperion frequently Asked Questions by expert members with experience in Hyperion. These interview questions and answers on Hyperion will help you strengthen your technical skills, prepare for the interviews and quickly revise the concepts. So get preparation for the Hyperion job interview”
8 Hyperion Questions And Answers
2⟩ Who is Hyperion Developer?
Hyperion is a Business Intelligence (BI) and Business Performance Management (BPM ) Tool.So Hyperion Developer is a person who works on Hyperion
3⟩ Tell me what are the infrastructure requirement for Hyperion implementation?
In order for your Oracle Hyperion software to operate efficiently, your organisation must have the correct infrastructure in place. This will ensure that your software is operating efficiently throughout the lifecycle of your product and enables you to update your products in a hassle free manner.
4⟩ Tell me what are the two storage options available in Essbase and what are the differences?
1. Aggregate Storage Option ASO
* Used for more than 10 dimensions
* The majority of the dimensions will be distributed.
* It is impossible to write back in ASO. In the next versions we should be able to write it back.
2. Block Storage Option BSO
* Less Dimension and more dense dimensions
* Write back quality is present, good for application planning. The commercial programs are usually dense, the analytical cubes-sparse.
5⟩ What is VMS system?
VMS (Virtual Memory System) is an operating system from the Digital Equipment Corporation (DEC) that runs in its older mid-range computers.VMS originated in 1979 as a new operating system for DEC's new VAX computer, the successor to DEC's PDP-11.VMS is a 32-bit system VMS was renamed OpenVMS when it was redeveloped for the Alpha processor.
6⟩ Tell me why we are using Hyperion? We are having many OLAP tools in the market. What feature makes Hyperion unique with other tools?
Hyperion is a BI tool used to convert OLTP data to OLAP one.The beauty of Hyperion as compared to other tools is security used in the shared services.
7⟩ How to calculate minority interest in Hyperion Financial Management?
We need to write in rules as PCon=POwn-PMin, to calculate percentageof minority intrest.
8⟩ Explain what is olap and whether it is related to HYPERION FINANCIAL MANAGEMENT?
OLAP is an Online Analytical Processing means "it is a set of specification which allows the client application in retrieving the data from data warehouse.
It is not related to the HFM, because HFM is an functional to the hyperion tool.
