Overview of EPBCS

 

          Oracle EPBCS (Enterprise Planning and Budgeting Cloud Service)?

     EPBCS has world-class budgeting and forecasting, data management, and analysis capabilities in Oracle Hyperion Planning.

Oracle EPBCS Beginners

Difference between PBCS, EPBCS

 

PBCS (Planning and Budgeting Cloud Service)	EPBCS (Enterprise Planning and Budgeting Cloud Service)
1.  3 BSO - Custom Plan Types	1.  3 BSO - Custom Plan Types
2.   3 ASO - Custom Plan Types	2.  3 ASO - Custom Plan Types
3.   1 Consolidated   Reporting Cube	3. 1 Consolidated   Reporting Cube
	4.    EPBCS  MODULES- Pre-Built
	1.   Financials          2. Workforce          3. Capital          4.  Projects         5.  Strategic  modeling
	5.  FDMEE(  Integration Tool) supports
	6.   Smart View, FR (Reporting Tool)  supports

Oracle EPM Cloud

 

Enterprise Performance Management(EPM) is a technology that specializes in

  Forecasting and Financial Management. 

 It provides,

•               Analytics, 
•               Reporting, and 
•               Forecast modeling.  

so organizations can analyze, understand, and plan strategically for the business.

=========================

                                              =========  EPM Cloud Companies =============

1. Oracle EPM Hyperion
2. OneStream 
3. Anaplan 
4.  CCH Tagetik Intelligent Platform   
5.  SAP Analytics Cloud
6. IBM Planning Analytics 
7. Workday Adaptive Planning
8. Prophix One
9. Planful
10. Board
11. edox EPM Software.

===============

                                   

Essbase Basics

                              

1. Create Application, Database

2. Difference BSO, ASO

3. Build the Dimensions using the Rule File.

4. Loading Data using Rules file, Free form method, Excel lock& send methods.

5. Calculations

6. Consolidation Properties

7. Data Storage Properties

8. Dimension Types

9. Backup

10. Scripting Languages- Calc scripts (BSO), MaxL, Batch Files, MDX (ASO)

11. Upgradation, Migration

12. Glossary Essbase 

13. Essbase Interview Questions.

=========

1. What is Hyperion Software?

       Hyperion Software is an OLAP/Multi-Dimensional/BI/BPM/EPM Tool.

2. What is Hyperion Essbase?

     Essbase is a multidimensional database where the data will be stored in cells & Blocks.                          

EPBCS Interview Questions

                                 

                                                       EPBCS Interview Questions

  1.  Can we create multiple Applications in EPBCS?

         In PBCS/EPBCS, it's limited to One application per environment. If you want more you may have to buy a new POD, per App.

2.  Can I delete application in PBCS/EPBCS environment?

        Yes, you can delete application and create a new one yourself.

3. What is the amount of space allocated for my application?

       Including backups (inbox/outbox) and application size, it can grow up to 150 GB.

========

EPBCS Basics Questions 

EPBCS Basic Questions

                                         

                                                       EPBCS Basic Questions

EPBCS Interview Questions

* Oracle EPBCS (Enterprise Planning and Budgeting Cloud Service)?

     EPBCS has world-class Budgeting and Forecasting, Data management, and Analysis capabilities of Oracle Hyperion Planning.

* How many Dimensions are there in EPBCS?

         20 Dimensions in EPBCS

* How many plan types are there in EPBCS?

          3 BSO Plan Types and 3 ASO Plan Types 

           single Planning application with m

* Difference between EPBCS, PBCS?

EPBCS (Enterprise Planning and Budgeting Cloud Service)	PBCS (Planning and Budgeting Cloud Service)
1.  3 BSO - Custom Plan Types	3 BSO - Custom Plan Types
2.   3 ASO - Custom Plan Types	3 ASO - Custom Plan Types
3.   1 Consolidated   Reporting Cube	1 Consolidated   Reporting Cube
4.    EPBCS  MODULES- Pre Built
1. Financials
2. Workforce
3. Capital
4. Projects
5. Strategic  modeling
5.  FDMEE(  Integration Tool) supports
6.   Smart View, FR (Reporting Tool)  supports

 

  * How many cubes can be created in EPBCS?

           EPBCS provides 7 total cubes: 

•        3 BSO cubes and 
•        3 corresponding ASO cubes,
•        1 consolidating ASO cube. 

        Each of these cubes has a unique aggregate storage application name.

* Dimensions in EPBCS?

• Scenario
• Version
• Years
• Period
• Account
• Organization
• Employee
• Product

*  What are the advantages of EPBCS?

          EPBCS comes with custom planning, free-form planning, and customized groovy scripts offered as Enterprise cloud features. Pre-built content can be gradually customized to your planning needs, and all modules can be integrated with each other.

* What are the features of EPBCS?

•     Planning, Budgeting, and Forecasting Solution in the Cloud- Complete.
•     Forecast Accuracy with Predictive Planning and Rolling Forecasts- Improve.
•     Integrate- Planning and Management Reporting Seamlessly.
•     Integration Capabilities.

* What is Oracle EPBCS used for?

           EPBCS is a flexible application based on Oracle Hyperion Planning that supports Enterprise-wide Planning, Budgeting, and Forecasting in a cloud-based deployment model.

* Who uses EPBCS?

  EPBCS is utilized by Budget Managers to create the annual Budget and by KU departments and SSCs to manage their budget which includes Tracking/Forecasting revenue and expenses.

                                ==========DIFFERENCE================

* What is the difference between Hyperion Planning and EPBCS?

         Oracle EPBCS includes pre-built yet flexible dashboards that can fit your exact dimensionality, a feature that is missing from Hyperion Planning.

RDBMS vs OLAP

• 
                                               ====================

1.Types of   Database

    * RDBMS: Relational Database Management System- Store and Manage the Database.

    * OLAP (BI/BPM/EPM ): Online Analytical Processing-  Analysis and Reporting, Ex: Essbase

             BI: Business Intelligence

             BPM: Business Performance Management

             *EPM: Enterprise Performance Management.

                                         Difference between RDBMS, OLAP?

                          RDBMS                                                         OLAP

• Store and Manage the Database.                     * Analysis and Reporting
• RDBMS database called “Table,”       * OLAP Database called “Cube.”
• It is stored in Rows and Columns.        * Stores in “Cells and Blocks”.  
• 2-Dimensional Database                         * Multi-dimensional Database
• Ex: Oracle Suite   * Ex: Oracle Hyperion Essbase,  IBM Cognos                                                                                                      

                        Note: Oracle acquired Hyperion in 2007

1. What is an OLAP server?

• Multi-Dimensional Database(Cube)
• OLAP Database called “Cube (Multidimensional Database)- Dimensions/Members/Parents/Children
• Analytical Server                                               

             2. What is the difference between Multidimensional (OLAP), Two Dimensional (RDBMS)?

• Multidimensional database where the data will be stored in cells & Blocks.
• Two-dimensional databases where the data will be stored in Rows & columns.

                          =============== Hyperion=======

1. What is Hyperion Software?

       Hyperion Software is an OLAP/Multi-Dimensional/BI/BPM/EPM Tool.

2. What is Hyperion Essbase?

   Essbase is a multidimensional database where the data is stored in cells & Blocks.      

• Environment: Development/Testing (QA)/Production