Hyperion Essbase Interview

Hyperion Essbase Interview Questions

1.Can we have multiple meta outlines based on one OLAP model in Integration services?

 Ans: Yes

2.What are 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.

3.What are the three primary build methods for building dimensions?

Ans:

Generation references

Level references

                  Parent-Child references

4.How does UDA’s impact database size?                                   

Ans: There will be no impact on the database as the UDA’s doesn’t store data in the database.

5.Can we have an meta outline based on two different OLAp models.

Ans: No.

6.Can we create UDA’s and apply it to Dense as well as Sparse dimensions?

Ans: Yes

7.Types of Partitions available in Essbase?

Ans: Three types of partitions are there.

                        Transparent partition: A form of shared partition that provides the ability to access and manipulate

        remote data  transparently as though it is part of your local database. The remote data is retrieved from

        the data source each time you request it. Any updates made to the data are written back to the data source

 and become immediately accessible to both local data target users and transparent data source users

Replicated Partition:

Linked Partition:

8.What is hybrid analysis?

Ans: Lower level members and associated data remains in relational database where as upper level members

 and associated data resides in Essbase database.

9.Why top-down calculation less efficient than a bottom-up calculation? Being less efficient, why do we

10.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.

11.How can you display UDA’s in reports?

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

12.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?

Ans: The record will be rejected.

13.What are the specified roles other than Administrator to view sessions, disconnect sessions or kill users requests for a particular application?

Ans: You should have the role of Application manager for the specified application.

14.What is block locking system?

Ans: Analytic services(or Essbase Services) locks the block and all other blocks which contain the child’s of that block while calculating this block is block locking system.

15.What are the three options specified in Username and Password management under 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.

16.Can we have multiple databases in one single application? Ans: Yes. But only one database per application is recommended.

Depend on which database that you are going to create. For Example: If you are creating ASO then we can’t create more that 1 db per application. If you are creating BSO then you can create more than 1 db per application

17.How is data stored in the Essbase database?

Ans: Essbase is an file based database where the data is stored in PAG files of 2 GB each and grows sequentially.

18.We have created an application as unicode mode. Can we change it later to non-unicode mode.

Ans: No

Hyperion Financial Reporting (HFR) - Interview

                         Hyperion Financial Reporting (HFR) - Interview

1.            What are the data sources supported by Hyperion Financial Reporting?

                    3 data sources like HFM, Essbase, planning. These are the data sources which are supported   by Hyperion financial reporting.

2.            Which is used to store the created reports in Hyperion Financial Reporting?

                             It stores the reports in central repository.

3.            What is the difference between Hyperion Financial Reporting studio and web client?

                       Reporting studio enables you to create, edit and delete the report objects, report and snap

                 Shot reports. Web client enables you to book of reports, schedule batches, view batches and 

                 Schedule for future Processing.

4.            What is Report object?

                Report objects are basic components for designing reports in Financial Reporting Studio.

                   Report objects include text boxes, grids, images, and charts.

      

5.            What is the need of studio work space?

                 It is to open a new or existing report in the report designer and access the repository.

6.            What is the need of property sheet?

        The property sheet enables you to set various options for the currently selected reports.

7.            What we need to do display and hide the property sheet?

                      Click View property sheet.

8.            To provide the ability to report which are used to categorize the data in general ledger?

                            Chart of accounts.

9.            How many data bases are used to connect Hyperion financial reporting studio?

                   Single data base is used to connect reporting studio.

10.          What are the steps to create a new report?

                 Click on file, New, Click on new report button.

11.          What are the required components to create grid?

Ans: Rows,

         Columns,

         Pages,

         Point of view,

        Data area.

12.          Relationship functions allow reports to be more flexible by relying on hierarchies within the

 Application?

                          AND/OR logic functions can achieve complex reports.

    

13.          When adding a member, select the member and then click the Add Relationship button?

14.          Why are dimensions listed on the user POV when changing them has no effect on the grid?

             Multiple grids can be included in a report, where one or more of the grids are affected by 

                 Changes to those dimensions on the user POV.

15.          Why is the grid POVs not displayed in the Report Designer Workspace?

                  If the administrator chooses to disable the grid POV, Workspace viewers cannot see it.

16.          How will a user running Workspace know that the dimension is set on the grid POV?

                 The Report designer should design the grid with a text row footnote that the grid POV for a

               Dimension is set to a particular member in the grid. Another option for the Report designer is

               to put the dimension value into the row or column headers. If the designer turned off the grid 

               POV, the column description (using a custom heading) would correctly denote that the grid is 

               Displaying  Actual for the Scenario dimension.

17.          How can a report are designed so that any changes to a user's user POV changes the members selected from a row, column, or page axis on a grid?

                Use the CurrentPOV member for the selected axis or choose a member selection function with

                CurrentPOV as the member parameter. When the report runs, the axis value is taken from the

               user POV. You can design a grid so that all axis values are taken from the user POV, making the

               report completely dynamic on a per user basis.

18.          Why do you need a book POV?

                  It allows anyone running the book to use the same default values for all grids in all reports in

                the book simultaneously each time the book is run. It is specific to a database connection for a

              book, but not specific to any report or grid object in a report in that book. As the book POV

              values are saved with the book itself, changes to the book POV do not affect the book designer's

        user POV.

19.          What are Report Member Selections?

     The Report Member Selections define the values for any dimensions not on a grid's row, column,

or page axis or set in the grid POV for all Grids in a specific report in the book.

20.          Why not just call Report Member Selections the report POV?

      All POVs allow a single member to be set for a dimension. Report Member Selections allow

                Multiple members to be set for a dimension. If multiple members or member selection functions  resulting in multiple members are set for a dimension, the report in the book is run for each

     member. If multiple members or member selection functions resulting in multiple members are

         set for multiple dimensions, the report in the book is run for all combinations of those members.

21.          Why do you need a batch POV?

     It allows anyone scheduling the batch to use the same default values for all grids in all reports

         in the batch simultaneously when the batch is run. It is specific to a database connection for a

         batch, but not specific to any report or grid object in a report in that batch. Since the batch POV

         values are only saved when the batch is scheduled, you can set different values for the same batch.

          Changes to the batch POV do not affect the batch designer's user POV. Also, the changes to the

   batch designer's user POV do not affect the batch POV.              

Hyperion Job Support

We help for Hyperion Job Support in USA, India, for more details , Please contact, contact@ITSoftwareGuru.com

* EPM Guru: www.EPMGuru.net

Hyperion Financial Management Interview

                        Hyperion Financial Management Interview Questions and Answers

1.What is HFM?

    Oracle Hyperion Financial Management is a financial consolidation tool.

2.What is Consolidation?
    Consolidation is aggregating the Base level entities amounts with the Parent level entities amounts.

3.How many Custom dimensions are there in HFM?

       Here you need to answer as per your HFM version.

Ex: 9 version to 11.1.2.1 version only we having 4 custom dimension. After that versions are like (11.1.2.2 and 11.1.2.3) having 100 custom dimensions.

4.Can you please Explain 8 standard dimensions?

        Those 8 Standard dimensions are like

1. Entity
2.Account
3.Value
4.Scenario
5.Year
6.Period
7.View
8. ICP

5.What is HFM ARCHITECTURE?

    Hyperion Financial Management is designed to operate as a multi-tier system.

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.

6.What are HFM services you need to start?

1. Hyperion Foundation Shared Services - Web Application
2. HFM- DME Listener
3.Hyperion Web Service Manager
4.Hyperion Workspace- Agent Application
5. Hyperion Workspace- Web Application
7.Services dependency means?
Ans : Hyperion is dependent on services. Means services are to be started in a specified sequence only.

8. How many Environments do you having in your Project?

        We having 3 environments .Those are
1. Development Environment
2.QA Environment
3. Production Environment

9. What is application profile; can we change application profile at any point of time?

     An application profile contains language, calendar, frequency, and period information for an Application. No, application profile once created cannot be changed.

10. What are the dimensions will be covered while creating Application Profile?

           Year, Period, View.
11. How many Account types in HFM?

        We have 10 Account types in HFM.
12.  Explain those Account types in account dimension?

     There are 10 account types -
1.      Asset
2.      Liability
3.      Revenue
4.      Expense
5.      Balance
6.      Balance recurring
7.      Flow
8.      Dynamic
9.      Group label

10.  Currency Rate

Hyperion Planning Interview

                                   Hyperion Planning Interview  Questions and Answers

1. What are the required dimensions in planning?
                *Period
                *Year
                * Scenario
               * Version
               * Entity
               * Account
2. What are the steps you need to take before creating planning application?
         Classic application administration.
• click on create application
• fill the details in selected tab
• select calendar tab and select base period, fiscal period, year
• select currency tab and select default application currency tab
• select plan types tab and enter the name of plan at both plan types
• Select finish tab.
             Application creation is successfully completed.
3. Which process state signifies that a planning unit is being reviewed by someone in the organization?
4. What file acts as bridge between Planning and relational data source?
     Planning communicates to the relational data source through a number of Java classes using JDBC. Business rules also use the Hyperion RMI service to communicate to planning.
5. When you tag a currency as a reporting currency, which dimensions will it be part of?
6. What is the maximum number of plan types you can have in planning?
     When creating a Project Financial Planning application then it creates 6 plan types
7. What are the different user roles in planning security?
         Power roles, interactive roles, planner roles, view roles.
8. Fiscal start of year and fiscal start month defines the starting fiscal year and start month for application. You cannot change this after you have created the application (True/False)?

Job opportunities for Hyperion

Hyperion is great competitor for Congnos, SAP BO, Microstrategy etc in the EPM Market jobs. Over the last 20 years Hyperion has revolutionized the way that software is developed across the IT industry. Hyperion employees enjoy competitive salaries, excellent health benefits, and a network of like-minded colleagues that drive innovation across the entire IT industry.

       
   Hyperion, a leading provider of Enterprise Performance Management (EPM) software.  Hyperion makes Oracle the category leader in the high growth enterprise performance management market.

  It’s a market leader in Financial, Operational and Strategic Planning. It is having applications for Planning, consolidation, and score carding, reporting, dashboards, Analysis, Workspace, Master Data Management and Foundation.

  - Venu Udumula, Contact@ITSoftwareGuru.com, 91- 815 287 3070

Hyperion Financial Data Quality Management Interview

                  Hyperion Financial  Data Quality Management  Interview Questions and Answers

1.     In Machine profile which user id and Password will give?

      we have to give admin and password or machine name also provided in machine profile.
2. Is it possible to organize one-to-many mapping in FDM?
           yes it is possible.
3. Which data base consists in Financial data quality management?
          Relational database management system (RDBMS)
4. Where the data stores in the FDM application?
          Each FDM Application contains four directories. 1) inbox 2) outbox 3) data 4) reports.
          These are the directories which stores the data.
5. What are the types of mapping?
          Explicit, in, like, and between mapping.
6. Explicit mapping is called one – one mapping and between mapping is called one – many mapping.
7. What are the main features of FDM?
8. How to access the FDM web client?

        ANS: Open the Hyperion FDM Web Client by selecting Programs oracle EPM Financial Data Quality
          Management WebServer Components Web Logon.

9. Where you have to getting or importing the data to FDM?
          by importing GL files or from other external data sources.

10. Explain the data load process in FDM?

         Please explain about import, export, validate and check.The Hyperion FDM desktop is the control center from where a Hyperion FDM application is built and administered.

    The desktop has three main areas: Screen Indicator, Hyperion FDM Menus, and the POV bar.

11. Explain briefly about Point of view in fdm web client?

            Explain about POV.

12. When the system is locked users will not be able to log on.

13. Hyperion fdm contains two types of locations 
           Data load
           Controls review.
 Location that accepts the data from source file and loads the data by mapping rules to the target file.

14.  What are the methods to build maps?

          Build maps internally with in fdm.
           Build maps externally import to fdm.
          Copy existing location map to other location.
          Assign mapped location is parent to other location.