On-Premises vs Cloud Oracle EPM Hyperion

ON-PREMISEs           HYPERION MODULES	CLOUD               ORACLE EPM  MODULES
BI Modules (Technical)-  On- Premises	BI Modules (Technical)- Cloud
1. Essbase (OLAP)     2. HFR (Hyperion Financial Reporting)	1. ESSCS (ESSbase Coud Service) 2. EPRCS-NR: Enterprise Performance Reporting Cloud Service (EPRCS) and           Narrative Reporting
Application (Functional)- On Premise	Application (Functional)- Cloud
1. Planning	1. EPBCS (Enterprise Planning and Budgeting Cloud Service)
2.  HFM (Hyperion Financial Management)	2. FCCS (Financial Consolidation and Close Cloud Service)
Data Management Modules (Integration Tools)- On- Premises	Data Management Modules (Integration Tools)- Cloud
1. FDMEE (Financial Database Management Enterprise Edition).	1. EPM Integration Agent
2. DRM (Oracle Data Relationship management)	2. EDMCS- Oracle Enterprise Data Management Cloud Service).
***	***
Hyperion Admin/Infra- on Premise	EPM Admin- Cloud
*Essbase, Planning, HFM	*EPBCS, FCCS

   

*  Hyperion On-Premise Modules

   * Hyperion Job Market: 2022- Q2

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

COMMANDS

                                            COMMANDS

 COMMANDS- frequently used commands are:

1.  SET COMMANDS
2.  FIX COMMANDS 
3.  IF . . . ELSEIF . . . ELSE . . . ENDIF
4.  AGG
5.  CALC DIM

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

    CALCULATION COMMANDS

COMMENTS

                                                         COMMENTS

1. • Comments in Business Rules can be inserted between stars surrounded by forward slashes. This text will be ignored by the calculation engine.
2. • Comments will be displayed with green font.

OPERATORS

                                                                 OPERATORS

Operators define equations for Business Rules. 

                           There are three types of operators:

1. Mathematical Operators
2. Conditional & Logical Operators
3. Cross-Dimensional Operator

                   

            CALCULATION OPERATIORS

FUNCTIONS

                                                       FUNCTIONS

BSO calc language supports an enormous number of functions.

 categories of Functions

1. Boolean Functions
2. Relationship Functions
3. Mathematical Functions
4. Member Set Functions
5. Range & Financial Function
6.  Allocation Functions
7. Forecasting Functions
8. Statistical Functions
9. Date & Time Functions
10. Miscellaneous Functions
11.  Custom Defined Function

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

 CALCULATION FUNCTIONS 

FIX COMMANDS

                                                           FIX COMMANDS 

The FIX . . . ENDFIX command block restricts calculations in a BSO database to a specific set of members within that database.

SET COMMANDS

                                              SET COMMANDS

     Most of the Business Rules start with a "series of Set Commands".

COMMANDS for Business Rules

 COMMANDS- frequently used commands are:

1.  SET COMMANDS
2.  FIX . . . ENDFIX.  
3.  IF . . . ELSEIF . . . ELSE . . . ENDIF
4.  AGG
5.  CALC DIM

Calculation Manager

  Calculation Manager 

             allows Service Administrators to create, validate and deploy scripts, rules and rulesets.

• Service Administrators can launch rules from Calc Manager, which can be useful 

during testing.

Oracle Business Rules

                               

Oracle Business Rules: 

        Business Rules are used to calculate stored data that persists in the database.

Business Rules - EPBCS

                                  

                                            BUSINESS RULES- EPBCS

                                                 BUSINESS RULES

 Business Rules are used to calculate stored data that persists in the database.

1. CALC MANAGER       
2. COMMANDS
3. FUNCTIONS
4. OPERATORS               

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

       *   COMMENTS

Configuration of EPBCS Modules

 

Configuration of EPBCS Modules.

1.    Financials
2.    Workforce
3.    Capital
4.    Projects
5.    Strategic modeling

EPBCS Modules

                                            

Application navigation EPBCS

 

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

Overview of EPM Cloud

 

Enterprise Performance Management(EPM), technology specializes in

  Forecasting and Financial Management. 

 It provides,

•               Analytics, 
•               Reporting, and 
•               Forecast modeling.  

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

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

12. Migration

Glossary Essbase 

=========

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.