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