EPBCS Tutorial

 

1. EPBCS Training
2. EPBCS Basic Questions 
3. EPBCS Interview Questions
4. LAB  PRACTICES- EPBCS

======= OLAP/ESSBASE/Hyperion Cloud Modules=======

1.  On-Premise vs Cloud Hyperion
2. Hyperion Cloud Modules
3. Essbase Basics
4. OLAP Basics

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

On-Premise vs Cloud Hyperion

ON-PREMISEs           HYPERION MODULES	CLOUD                   HYPERION 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

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

LAB PRACTICES- EPBCS

1. Creating an Application in EPBCS.

2. Configuring Financials

3. Navigating EPBCS

4. Importing and Exporting Metadata. 

5. Importing Data from Data Files.

6. Loading Data using Data Management.

7. Entering Revenue and Expenses in Financials.

8. Setting up Balance Sheet and Cash Flow Assumptions.

9. Maintaining Applications.

10. Creating Users and Groups.

11. Assigning Artifact Access.

12. Migrating Application Artifacts.

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 of Oracle Hyperion Planning.

Difference between PBCS, EPBCS

 

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

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.

EPBCS Training

 

1. Overview of EPM Cloud.

2. Difference between PBCS& EPBCS

3. Overview of EPBCS

4. Application navigation.

5. EPBCS Modules

6. Configuration of EPBCS Modules.

•    Financials
•    Workforce
•    Capital
•    Projects
•    Strategic modeling

7. Creating an EPBCS Application.

8. Metadata and Data loading

9. Data Maps/Smart Push.

10. Task List, Data Form, and Calculation Manager Rules.

11. Smart List 

12. Menus

13. Valid Intersection.

14. Navigation Flow

15. Workflow

16. Dashboard

17. Migration

18. Security

19. Cloud Data Management

20. Smart View

21. EPM Automate Utility

22. Business Rules

=============Interview EPBCS=====

1. Interview Questions- EPBCS.

Essbase Basics

                              

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.                          

3. What are the two storage options available in Essbase and what are the differences?

                                                          Difference between  BSO- ASO

BSO(Block Storage Option)	ASO(Aggregate Storage Option)
1. Write back in BSO.	No write-back in ASO
2. most of the Dimensions are dense in BSO	Most of the dimensions are sparse in ASO
3. can create more than 1 database per Application in BSO	cannot create more than 1 database per Application in ASO
3. Less no. of Dimensions(between 4 and 8) in BSO	large number of dimensions (more than 10) in ASO
4. Much suited for planning applications.	Not much suited for planning applications.
5. Calc Script/Two-Pass/Attribute   Dimension	no Calc Script/Two-Pass/Attribute Dimension
6. Supports LRO	Doesn’t Support LRO
7. Convent BSO to  ASO	can’t convert ASO to BSO
8. Currency Conversion	No Currency Conversion
9. Supports- Partitions-   Linked, Transparent, Replicated	support - Linked& Transparent
10. Copy Database	no- Copy Database
11. Sparse,  Dense	no- Dense, sparse
12. parent level- loading data	no - parent level- loading data
13. Attribute Dimension	attribute dimensions- Sum only
14. Dynamic time series	no- Dynamic time series
15. at any level, we can load	can load Data only to” Level 0” in ASO
16. Not Available DTS	available    DTS

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

bbbbbbbbbbb

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.