Please visit for more information @ http: //h. What is Consolidation? Ans. Consolidation is aggregating the Base level entities amounts with the Parent level entities amounts. How many Custom dimensions are there in HFM? Ans: Here you need to answer as per your HFM version. Ex: 9 version to 1. After that versions are like (1. Can you please Explain 8 standard dimensions? Ans: Those 8 Standard dimensions are like. ICP5. What is HFM ARCHITECTURE? Ans: Hyperion Financial Management is designed to operate as a multi- tier system. About Financial Management 15 Fniancai Ml anagemen Ft eautres 15 Architecture 16 Perofrmance Managemen tArchetic t 16. Oracle Hyperion Financial Management is a financial consolidation and reporting application built with advanced Web technology. It provides financial meet. Client tier: The client tier contains the user interface and the ability to communicate with the application tier. You can display data and metadata, enter data, and maintain metadata in this tier. Web tier: The Web server tier contains the Web server. You can access the Web- enabled portions of Hyperion Financial Management in this tier. The Hyperion Financial Management Web client contains all functionality available in the Windows client with the exception of security administration. Middle tier: The middle tier contains the domain intelligence and connections to the relational database. Database tier: The data tier contains the relational database and all Hyperion Financial Management data and metadata. What are HFM services you need to start? Ans: 1. Hyperion Foundation Shared Services - Web Application. Hyperion Web Service Manager. Hyperion Workspace- Agent Application. Hyperion Workspace- Web Application. Services dependency means? Ans : Hyperion is dependent on services. Means services are to be started in a specified sequence only. How many Environments do you having in your Project? Ans: We having 3 environments . Those are. 1. Development Environment. Production Environment. What is application profile; can we change application profile at any point of time? Ans. An application profile contains language, calendar, frequency, and period information for an Application. No, application profile once created cannot be changed. What are the dimensions will be covered while creating Application Profile? Ans: Year, Period, View. How many Account types in HFM? Ans: We have 1. 0 Account types in HFM. What is COA? Ans: COA is nothing but chart of accounts, whatever the members we will define under the account dimension will be called sometimes chart of accounts (COA)1. What is the difference between switch sign for and switch type for and in which dimension it exists? Ans: It exists in custom dimension. Switch sign for: It is ticked to change. Assets, liabilities and ownership equity are listed as of a specific date, such as the end of its financial year. TOP Hyperion Essbase Interview Questions and Answers pdf. List of top 5. 0 hyperion interview questions and answers,hyperion tutorials for freshers beginners and experienced pdf free download. Can we build the dimension. What is the difference between UDA's and Attribute dimensions? How does Attribute dimensions and UDA's impact batch calculation performance? How can we display UDA's in reports? How do they impact report report performance. How does Attribute dim impact report performance? While loading the data, you have applied both the selection criteria as well as rejection criteria to a same record. What will be the outcome. How is data stored in the Essbase database? Can we have multiple databases in one single application? Can we have one ASO database and one BSO database in one single application. If yes, how and If No, why. What are the file extensions for an outline, rule file and a calc script. What is the role of provider services. What is an alternative to create meta outline, rule file and load data. Can we start and stop an application individually. How can this be used to increase performance. We have created an application as unicode mode. Can we change it later to non- unicode mode. How can I migrate an application from my test environment to the production environment. Can I still do this if my test environment is a windows one and my production env is UNIX one. Also can I still do it if my test env and prod env versions are different. A customer wants to run two instances of an Essbase server on a same machine to have both test env and Development env on the same server. What does never consolidate operator (^) do? Can we have multiple meta outlines based on one OLAP model in Integration services? Can we have an meta outline based on two different OLAP models. What is hybrid analysis? Why top- down calculation less efficient than a bottom- up calculation? Being less efficient, why do we use them. What is block locking system? What are the types of partitioning options available in Essbase? Dynamic calc decreases the retrieval time and increases batch database calculation time. How true is the statement? A customer has a cube with 1. Now they have added two more dimensions in the existing cube and the performance becomes very slow. Customer said logically nothing wrong with the two new dimensions they have added. What could be the reason for slow down. Can we have multiple meta outlines based on one OLAP model in Integration services? What are LRO's( Linked Reporting Objects)? What are the three primary build methods for building dimensions? How does UDA's impact database size? Can we have an meta outline based on two different OLAP models. Can we create UDA’s and apply it to Dense as well as Sparse dimensions? Types of Partitions available in Essbase? What is hybrid analysis? Why top- down calculation less efficient than a bottom- up calculation? Being less efficient, why do we use them. On what basis you will decide to invoke a serial or parallel calculation method. How can you display UDA’s in reports? While loading the data, you have applied both the selection criteria as well as rejection criteria to a same record. What will be the outcome? What are the specified roles other than Administrator to view sessions, disconnect sessions or kill users requests for a particular application? What is block locking system?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2016
Categories |