What are the Hyperion Products are acquired by Hyperion & developed ?

1. What are the Hyperion products?

    * Essbase

    * Hyperion Intelligence and SQR Production Reporting (products acquired in 2003 takeover of Brio Technology)

    * Hyperion Enterprise

    * Hyperion Planning

    * Hyperion Strategic Finance

    * Hyperion Financial Data Management

    * Hyperion Enterprise Performance Management Architect

    * Hyperion Financial Close Management

    * Hyperion Disclosure Management

    * Hyperion Performance Scorecard

    * Hyperion Business Modelling

    * Hyperion Financial Management

    * Hyperion Master Data Management/Oracle Data Relationship Management

    * Hyperion Financial Reporting

    * Hyperion Web Analysis

    * Hyperion SmartView

    * Hyperion EPM Workspace

    * Hyperion Profitability and Cost Management

    * Hyperion System 9 BI+ (a combination of Interactive Reporting, SQR, Web Analysis, Financial Reporting, EPM Workspace and SmartView)

    * Hyperion Financial Data Quality Management (Also referred to as FDM EE)

    * Hyperion Tax Provision

    * Planning Budgeting Cloud Service

    * Enterprise Performance Reporting Cloud Service

   History of Hyperion BI Tool?

   * IMRS founded by Bob Thomson and Marco Arese, and launches financial and management consolidation software called 'Micro Control' in 1983.

   * In 1991 IMRS becomes a public company and launches a Windows-based successor to 'Micro Control' called 'Hyperion'.

   * In 1992 Arbor Software ships first version of Essbase Online Analytical processing OLAP software.

   * In 1995 Due to the success of the "Hyperion" product IMRS changes name to "Hyperion Software Corporation" and the name of the product
     is changed to "Hyperion Enterprise." Arbor becomes a publicly held company.

   * In 1998 Hyperion Software merges with Arbor and the combined company is renamed Hyperion Solutions.

   * In 1999 Hyperion acquires Sapling Corporation (Analytics applications for Enterprise Performance Management).

   * In 2003 Hyperion acquires Brio Technology and The Alcar Group.

       * Brio technology:The company is best known for their business intelligence software systems, starting with DataPivot on the Apple Macintosh (query,analysis & reporting)

       * Alcar group: It is financial modeling expertise.

   * In 2005 Hyperion acquires Razza Solutions (Master data management).

   * In 2006 Hyperion acquires UpStream (Financial Data Quality Management).

   * In the same year 2006 Hyperion acquires Beatware (Data visualization for Web and Mobile Devices).

   * 2007 - Hyperion acquired Decisioneering (Crystal Ball software- Risk analysis)
   
        Decisioneering details : award-winning software, Crystal Ball, is the industry-leading predictive analytics, simulation and modeling tool built for business users.
        Crystal Ball includes a full suite of Microsoft Excel-based predictive analytic applications that are easy to use and implement.
        This acquisition of Decisioneering will allow Hyperion to integrate risk management more deeply into its solutions that automate the business management cycle.

   * In 2007 Oracle acquired Hyperion.

      * Hyperion now operates as a division of Oracle.

      * Oracle extended support for most Hyperion products (v11.1.2.x) to 2018.

      * Hyperion BI tools were bundled into Oracle Business Intelligence Suite Enterprise Edition.
   

What is the difference between PBCS Vs EPBCS Vs FCCS?

 PBCS vs EPBCS: (Enterprise Planning and budgeting cloud services)

 -PBCS

   * PBCS was built from on-prem Hyperion Planning, so you’re already getting a proven system. 

     Everything you get with PBCS, you’ll also get with EPBCS. Both applications have the following features:

     * 3 BSO Custom Plan Types

     

     * 3 ASO Custom Plan Types

     

     * 1 Consolidated Reporting Cube

   * Like the on-prem version of Planning, PBCS allows for flexibility to make changes to business rules and templates behind the business rules.

-EPBCS

     This is where EPBCS departs from on-prem Planning. EPBCS has out-of-the-box frameworks that allow very little custom modification inside plan types. 

   * These are the four frameworks found within EPBCS:

     * Financial Statement Planning

     * Workforce Planning

     * Capital Asset Planning

     * Project Financial Planning

   1. Financial Statement Planning:

     * This framework includes four sub-processes that can be enabled one at a time: Revenue, Expense, Balance Sheet, and Cash Flow.

     * The Financial Statement Planning framework allows users to integrate balance sheets with income statements and cash flow. 

       If you make changes on an income statement, it automatically updates the balance sheet and cash flow. You can also access 

       the framework for revenue/sales and gross margin planning to add dimensions for unique business drivers.

     * This framework supports direct and indirect cash flow methods. You’re also able to leverage the framework for trend-based planning using best practice expense drivers.

   2.Workforce Planning:

     * This framework attempts to address the needs of HR and Finance, allowing the department to plan by employee, or job code, for compensation-related expenses. 

       Workforce planning can be used enterprise-wide and has the capability to support large organizations spanning the globe. 

     * With this module, you’re able to align your HR strategy with corporate priorities. It’s also a tool for business users to easily keep up with their expenses and benefits.

   

   3.Capital Asset Planning:

    * This framework allows you to track new and existing assets, as well as intangibles. Capital Asset Planning supports depreciation and amortization calculations, 

      cash flow planning and funding for investment and leased assets, as well as “buy versus lease” comparison. You can use this framework for planning asset-related 

      expenses with automated processes for retirements, transfers, and improvements.

   3. Project Financial Planning:

     * For organizations with many internal projects — such as IT, marketing, R&D, and training — this framework allows for driver-based planning for both short- and long-term projects. 

       This framework lets individual employees drive their project-related planning, while tracking asset-related expenses and project revenues. You also get out-of-the-box analysis to 

       review project performance, project revenue, expenses, and cash flows.

   4.Pricing:

     * The prebuilt frameworks are the biggest difference between PBCS and EPBCS, but there’s also a major difference in the price tag. PBCS is $120 per user per month, 

       while EPBCS is $250 per user per month. For organizations looking for out-of-the-box capabilities, EPBCS is a good fit, but you’ll have to pay a little more. 

       PBCS allows for customization around your specific organization and though your monthly investment is cheaper, you’ll have to invest time and energy in customizing your environment.

   

  -FCCS: (Financial consolidation & cloud services)

        * If you know PBCS, then you already know FCCS…technically. They share ~70% of the same platform. What’s interesting is that there are several areas of FCCS that refer to either “Planning” or “PBCS”.

         

        *  you still need the functional knowledge. A strong accounting background is key. However, already having the knowledge of how Essbase inherently calculates and stores data will give you a leg up.

        

        * out of box features:

          * DashBoards

          * Control elements

          * currency FX

          * Data management

          * New dimensions:

            * Movement

            * data source

          * two custom dimensions

          * view and manage the close process

          * supplemental data with drill back

          * centralized audit information

    

How to Install Hyperion Planning?

Pre-requisites to Implement Hyperion Planning Implementation?

  * To install planning fisrt we have to start with EPM installation

    * Hyperion EPM installing in an environment that has at least 4CPUs and 12GB of RAM.
   
    * Check to make sure that you have administrative privileges for the machine you are installing on.
      If you don’t know, or don’t know how to check, see the following link: http://www.technipages.com/how-to-check-for-administrator-rights.

    * Disable “User Access Control” by clicking “Start” and then typing “UAC”. Select “Change User Account Control settings”.

    * Set the level to “Never Notify” and click “OK.”

    * Download the relevant assemblies from the Oracle E-Delivery site. This includes the installation documentation.

    * Log in with your Oracle ID by clicking “Sign In / Register”.

    * Read the “Terms & Restrictions.

    * Select “Oracle Enterprise Performance Management System” from the first drop down. Select the appropriate platform
      for the second drop down. For this installation, I have selected “Microsoft Windows x64 (64-bit)”. Click “Go.”

    * Select the “11x Download” option and click “Continue.”

    * From here, you need to select the appropriate files for download. I have listed them below. When you download these files, put them in the following directory: C:\oracle_install_files.

    * Log in as a user with SYS rights to your Oracle instance.

    * Execute the create user statements to create all of the users you need for the install.

    * Once all of the assemblies are downloaded, you should have a folder.

    * Now it is time to unzip all of these files into the same directory, to create the Installation folder. Create a folder on your local drive called
      C:\oracle_installer. Once this is done, unzip the first file into this directory.

    * After prepping your local machine, downloading assemblies, and creating the installation folder, you can begin the installation process.

    * Find the file called “installTool.cmd” located in the C:\oracle_installer directory. Right click, and run as administrator.

    * Choose a language and click OK.

    * The installer will review several prerequisites, and note any issues at the bottom. As demonstrated below, the system passes validation. Resolve any errors before continuing. Click “Next.”

       Pre requisites:  1.Epm installer succesfully resolved the hostname.
                      2.The operating system operated - windows server 2008 R2
                      3.All environment variables pre requisites have been met.
                      4.Inventory is writable.

    * Select a location for the installation.

    * Elect to perform a new installation.

    * From here you can see a list of all the available products for installation.
      1.Foundation services
      2.Essbase
      3.Reporting
      4.Planning
      5.financial close management
      6.Disclosure management
      7.Financial management
      8.Strategic finance
      9.FDM
      10.FDM Entriprise edition
      11.Profitability&cost management

    * Click Uncheck All. This clears all of the available products, providing an empty list to choose from.

    * Check the following products:

      * Under Foundation Services:All Foundation Components Calculation Manager.

      * Under Essbase:Essbase Administration Services Web Application.
        * Provider Services Java Web Application
        * Essbase Server
        * Essbase Server Samples

      * Under Reporting and Analysis:Framework
        * Java Web Application
        * Framework Services and Common Libraries

      * Under Planning: Planning Java Web Application

     
      * At this point, you have an opportunity to review the EPM install. Each product is listed for installation.

      * Click “Next” to move on to the installation.

      * As each product is installed, a check mark will appear next to the product.
 
      * Once the installation is complete, you can either choose the “Configure the EPM System” option or the “Finish” option.
 
      * Finish
 
    

What is the Difference between Planning Vs HFM Vs Essbase ?

 Planning :

 
     * Oracle Hyperion Planning is a centralized planning, budgeting, and forecasting solution that
       integrates financial and operational planning processes and improves business predictability.

 Key features :

     * Complex planning processes
     
       1. Planning by employee
   
       2. planning capital requests

       3. planning projects



    * complex driver based

    * Managing the planning and workflow

    * Combining budgets, rolling forecast, LRP(long range planning,weekly snapshots, etc. into a single application.

 

 HFM: Hyperion financial management

    * Oracle Hyperion financial management is a comprehensive, Web-based application that delivers global financial consolidation,
reporting and analysis in a single,highly scalable software solution.

 Key Features:

    * Complex organizational consolidation

    * Multiple transactional currencies

    * Inter company transactions

    * Minority interest (minority interest is a fractional share of a company amounting to less than 50% of the voting shares)

    * Maintaining historical representation of data

    * Ability to handle journals(Journals are really just another way to get data into the system, with a couple of exceptions. Unlike WDEFs or grids,
      journals provide system reports to view that give you a trail of the changes made)

    * Full audit trails-Data and end user actions

    * External reporting to stakeholders

 Essbase:

 
    * Essbase  is a multidimensional database management system (MDBMS) that provides a multidimensional database platform upon which to build analytic applications.
      Essbase, whose name derives from "Extended Spread Sheet data Base".

    Key Features:

    * Highly advanced calculation engine

    * Rich user experience - (Brings powerful online analytics processing (OLAP) directly to the business user)

    * What-if” analysis- (Quickly and easily develop and manage analytic applications that can forecast likely business performance levels)

    * Open, scalable, and secure- (Enables detailed analysis of terabytes of data for thousands of simultaneous users, providing up-to-the-minute, dependable information)

 

                                 Hyperion planning vs Essbase :

 

          Hyperion planning                                                   Essbase 

   1. centralized web based solution providing            1.Powerful analytic engine to do"whatifanalysis"
      Excel interface for budgeting and forec-
      asting activities

   2.Essbase as the backend for application

   3.Provides powerful workflow including                 3.No such workflow is available
     Email notifications alerts,and task lists
     To better control and manage the budget
     process

   4. provides task lists which can be assigned            4. No task lists are available
      to the team to manage the budget process
 
   5.account annotations and supporting details           5.No such functionality
     functionality available to provide justification
     on the budget numbers
 
   6.out of box functionality is available for                  6. No such prebuilt solutions available
     workflow and capital asset is available

   7. system 9 workspace provide single web based           7. Essbase application is managed by a separate interface to manage planning and forecasting        console which is also available on web but is  and associated financial and web analysis                               not integrated with Hyperion reports    reporting
 
   8. Data load can be done through web forms              8. No web based forms/templates available, need to develop excel based templates

   9. Security is role based                                               9. security is role based

   10. 20 maximum dimensions                                       10. No limit

   11.'8' mandatory dimensions                                        11. No limit
       account,entity,period,year,scenario
       version,currency(multi currency),
       Hsprates (Multi currency)

   12. Maximum 5 types of plan type                                12. plan type corresponds to db in essbase application
       3 generic plan types
       workspace planning
       capital planning

   13.calc script available                                             13. calc scripts are available for writing complex logic

   14. User prompts are available in                            14. no user prompts are available in calc scripts
       business rules

    Hyperion financial management  vs Hyperion planning

            Hyperion planning                                            Hyperion financial management 

1. It's a planning, budgeting and forecasting                   1.It's a financial consolidation application
   web based application

2. planning cycles can be annual, quarterly, monthly            2. It's a monthly close
   or ad-hoc

3. the planning team is focused on future performance           3. the accountants are compiling historical results


      

How to Troubleshoot Hyperion logs and its path [Essbase/Planning logs location]

Welcme to LIT,

In this post we are going to see how to troubleshoot the issues using the logs and you can see the logs location for Essbase and Hyperion Planning.

·         Start a problem log:

  

1.    The most useful habit to develop during issue resolution is to start a detailed log about the issue.

2.    Problems can take days or weeks to resolve and require trying hundreds of different prospective resolution attempts.

3.    It is easy for a “small” problem to become a long winded issue.

4.    If the problem log is created initially, all the important details can be captured.

5.    Additionally, it is much easier to bring others up to speed (management) and create support tickets when all of the information is documented.

6.    This log should include the error as the end user sees it, the error from any logs you are able to capture, screenshots, timestamps, and things that you have tried along with the results.

  

·         Reproduce the issue:

   

1.    The first thing to find out is whether the issue is reproducible.

2.    It is very difficult to solve an issue that is not reproducible. Many errors are simply ‘glitches’ and may have been caused by a very improbable event, such as a database hiccup.

3.    Such a problem may never produce itself again. Consequently, an initial step toward resolution is to restart the Oracle EPM services to bring them back into a ‘known state’.

4.    If the problem is not immediately reproducible after the restart, go back to the problem log and record everything you can.

5.    This type of issue will need to be profiled over a period of time to try and discover patterns if it occurs again.

  

·         Numerous logs:

1.    Once it is discovered that the issue is not a simple glitch, it is time to start digging.

2.    The first place to track down the cause of an issue is in the logs.

3.    The logs come in various forms. Here is a general breakdown of the log types:

  Logs and its location:

·         Essbase Server:

Ø  Location: EPM_ORACLE_INSTANCE/diagnostics/logs/essbase/essbase_0, where 0 is an instance number

·         Application location:

Ø  EPM_ORACLE_INSTANCE/diagnostics/logs/essbase/essbase_0/application name

ØAdministration Services: 

MIDDLE WARE_HOME/user_projects/domains/EPMSystem/servers/EssbaseAdminServices0/logs

Ø  Provider Services: MIDDLEWARE_HOME/user_projects/domains/EPMSystem/servers/AnalyticProviderServices0/logs

Ø  Essbase Studio:EPM_ORACLE_INSTANCE/diagnostics/logs/EssbaseStudio

Ø  Essbase StudioConsole: EPM_ORACLE_HOME/products/Essbase/EssbaseStudio/Console/workspace/.metadata

Ø  Essbase SecurityClient: EPM_ORACLE_INSTANCE/diagnostics/logs/essbase/essbase

Ø  OPMN: EPM_ORACLE_INSTANCE/diagnostics/logs/OPMN/opmn( opmn.log—Information about when Essbase starts, stops, and how many stop and start retry attempts are made)

Ø  Essbase Plugin:

EPM_ORACLE_INSTANCE/diagnostics/logs/essbase/lcm( Information about artifacts listing, migration (import/export) of Essbase )

 

·         Planning:

ØDefault Location: C:/MIDDLEWARE_HOME/user_projects/domains/EPMSystem/servers/Planning0/logs

  

Ø  EPM_ORACLE_INSTANCE/diagnostics/logs/planning

  

 ·         Log file name and contents:

    

Ø  UserProvisionSync.log—Security refresh information, such as provisioning or “user not found” issues

Ø  Planning utility logs—A log for each Planning utility

PlanningAppUpgradeLog_application_name.txt—An upgrade log for each upgraded Planning application

Regards,

Lead Innovative Technologies

Contact:+91-7207118899,+91-9966661460.

Email:Leadinnovativetechnologies@gmail.com

HFM,ESSBASE& Planning Interview Questions & Answers

Q1.What is Hyperion?

                Hyperion is a database that allows you to access the data very quickly. The company was bought by Oracle in 2007 and Oracle has continued to improve the product.

                The Fancy name of Hyperion is Business Intelligence and it aims to support better business decision-making. Thus a BI system can be called a decision support system (DSS). Though the term 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.

Q2.What is Hyperion Planning?

                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.

                The Software allows you 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.

Q3.What is Oracle Hyperion Financial Management (HFM)?

                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.

                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.

Q4.Mention the main Features in Hyperion Planning v11.1.2.3?

                The latest release of Oracle Hyperion Planning, v11.1.2.3, offers new key features for users and administrators, including ASO support within Planning, more flexibility to import and export metadata, and task list report visualizations. MijaDeering, Principal Solutions Manager at Edgewater Ranzal, provides an overview of these and other features of the newest Planning release. Her presentation also includes a live demo of key features and an opportunity for viewers to ask questions and better understand the product’s enhancements.

Oracle Hyperion Planning is a centralized, Microsoft Office and Web-based planning, budgeting and forecasting solution that integrates financial and operational planning processes and improves business predictability.  It allows organizations to reduce planning, budgeting, and forecasting cycles by weeks or months and improve accuracy of plans and forecasts.  Microsoft Office products are used as an interface into Oracle Hyperion Planning, so the learning curve for users is minimized, and Planning speeds up the time it takes to update plans and refresh reports.  The cost of ownership is reduced through superior application deployment, management tools, and packaged data integration.

Q5. What are the different types of LOG Files?

Ans: So many log files are there in essbase, but the important log files are

1. Application log

2. Essbase.log

3. Configtool.log

4. eas_install.log

5. essbaseserver-install.log

Q6. Suppose we have assigned Generation 2 and Generation 4 as of now and think of adding generation 3 later some time. Can we build the dimension?

Ans: No. If gen 2 and gen 4 exists, we must assign gen 3.

Q7. What are attributes?

Ans: A classification of a member in a dimension. You can select and group 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 “coke with 8 Oz with bottles”, this is useful for generating reports.

Q8. 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 Aministrative services console or Excel spreadsheet add-in, it gets locked.

Q9. What is the 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.

Q10. How does Attribute dimensions and UDA’s impact batch calculation performance?

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

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

Q11. What are different types of attributes?

Ans: Essbase supports two different types of attributes.

1. User-Defined attributes

2. Simple attributes

User-Defined attributes: The attributes that are defined by the user.

Simple attributes: Essbase supports some attributes, they are: Boolean, date, number, and string.

Q12. What are filters?

Ans: A method of controlling access to database cells in 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.

Q13. What is 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.

Q14. How can we display UDA’s in reports? How do they impact report performance?

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

Q15. How does Attribute dim impact report performance?

Ans: They highly impact the report performance as the attributes are calculated dynamically when referenced in the report. For very large number of att dim displayed in the report, the performance could drastically reduce.

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

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

Q18.What do you mean by a custom defined function?

Answer : Essbase calculation functions that you develop in the Java programming language and then add to the standard Essbase calculation scripting language by means of MaxL.

Q19.Can we have multiple databases in one single application?

Answer : Yes. But only one database per application is recommended.

Q20.Can we have one ASO database and one BSO database in one single application. If yes, how and If No, why?

Answer : No. Because we define ASO or BSO option while creating the appication and not database. Hence if the application is ASO, the databases it contains will be that type only.

Q21.What is an alternative to create metaoutline, rule file and load data.?

Answer : Integration services and in version 11, we have Essbase studio.

Q22.What do you mean by a data file cache?

Answer : A buffer in memory that holds compressed data (.PAG) files.

Q23.What are the file extensions for an outline, rule file and a calc script.

Answer : OTL, .RUL and .CSC

Q24.What is the role of provider services?

Answer : To communicate between Essbase and Microsoft office tools.

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

Answer : No.

Q26.Can we start and stop an application individually. How ca this be used to increase performance?

Answer : Yes. We can manage our server resources by starting only the applications which receive heavy user traffic. When an application is started, all associated databases are brought to the memory.

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

Answer : Hyperion Administrative services console provides a migration utility to do this but onluy the application, database objects are migrated and no data is transferred. the answers to other two questions are Yes.

Q28.What is custom based macro?

Answer : 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.

Q29.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. Can he do that?

Answer : Yes. We can have multiple instances of an Essbase server on a single machine and there will be different sets of windows services for all these instances.

Q30.Suppose I have a dimension A with members B and C and I do not want B and C to roll up to A. how can I do this?

Answer : Using (~) exclude from consolidation operator.

Q31.What does never consolidate operator(^) do?

Answer : It prevents members from being consolidate across any dimension.

Q32.What do you mean by dirty block?

Answer : A data block containing cells that have been changed since the last calculation. Upper level blocks are marked as dirty if their child blocks are dirty (that is, have been updated)

Q33.When do we generally use build rules files?

Answer : To automate the process of creating dimensions with more members, where it will take a lot of time in creating manually.

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

Ans: Yes

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

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

Ans:

Q37.Types of Partitions available in Essbase?

Ans: Three types of partitions are there.

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

2. Replicated Partition:

3. Linked Partition:

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

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

Ans: In the process it calculates more blocks than is necessary. Sometimes it is necessary to perform top-down calculation to get the correct calculation results.

Q40.On what basis you will decide to invoke a serial or parellel 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.

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

Q42.What are the specified roles other than Aministrator 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.

Q43.What is block locking system?

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

Q44.What are the three options specified in Username and Password management under security tab in Essbase server proprties.

Ans: 1. Login attempts allowed before username is disabled.

2. Number of inactive days before username is diabled.

3. Number of days before user must change password.

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

Q46.Dynamic calc decreases the retreival time and increases batch database calculation time. How true is the statement?

Ans: The statement should be just opposite. As dynamic calc members are calculated when requested, the retreival time should increase.

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

Ans: In the process it calculates more blocks than is necessary. Sometimes it is necessary to perform top-down calculation to get the correct calculation results.

List of top 50 hyperion interview questions.
1.  What are the two storage options available in Essbase and what are the differences?
2.  Can we build dimensions directly from data sources without using rule files.
3.  When do we generally use build rules files?
4.  What are the three primary build methods for building dimensions?
5.  In what case we can define generation 1 to a field in generation build method.
6.  Suppose we have assigned Generation 2 and Generation 4 as of now and think of adding generation 3 later some time. Can we build the dimension.
7.  Can we create more than 2 dimensions using only one build rule file.
8.  Can we query a member for its UDA in a calculation script.
9.  How does UDA's impact database size?
10. What is the difference between UDA's and Attribute dimensions?
11. How does Attribute dimensions and UDA's impact batch calculation performance?
12. How can we display UDA's in reports? How do they impact report report performance.
13. How does Attribute dim impact report performance?
14. 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.
15. How is data stored in the Essbase database?
16. Can we have multiple databases in one single application?
17. Can we have one ASO database and one BSO database in one single application. If yes, how and If No, why.
18. What are the file extensions for an outline, rule file and a calc script.
19. What is the role of provider services.
20. What is an alternative to create meta outline, rule file and load data.
21. Can we start and stop an application individually. How can this be used to increase performance.
22. We have created an application as unicode mode. Can we change it later to non-unicode mode.
23. 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.
24. 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. Can he do that?
25. suppose I have a dimension A with members B and C and I do not want B and C to roll up to A. how can I do this.
26. What does never consolidate operator (^) do?
27. Can we have multiple meta outlines based on one OLAP model in Integration services?
28. Can we have an meta outline based on two different OLAP models.
29. What is hybrid analysis?
30. Why top-down calculation less efficient than a bottom-up calculation? Being less efficient, why do we use them.
31. What is block locking system?
32. What are the types of partitioning options available in Essbase?
33. Dynamic calc decreases the retrieval time and increases batch database calculation time. How true is the statement?
34. A customer has a cube with 13 dimensions and the performance was fine. 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.
35. Can we have multiple meta outlines based on one OLAP model in Integration services?
36. What are LRO's( Linked Reporting Objects)?
37. What are the three primary build methods for building dimensions?
38. How does UDA's impact database size?
39. Can we have an meta outline based on two different OLAP models.
40. Can we create UDA’s and apply it to Dense as well as Sparse dimensions?
41. Types of Partitions available in Essbase?
44. What is hybrid analysis?
45. Why top-down calculation less efficient than a bottom-up calculation? Being less efficient, why do we use them.
46. On what basis you will decide to invoke a serial or parallel calculation method.
47. How can you display UDA’s in reports?
48. 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?
49. What are the specified roles other than Administrator to view sessions, disconnect sessions or kill users requests for a particular application?
50. What is block locking system?

   Contact-91-7207118899,040-62558899

                    E:leadinnovativetchnologies@gmail.com

Hyperion Financial Management,5 to 9 years -Hyderabad