EPBCS Tutorial

 

1. EPBCS Training
2. EPBCS Basic Questions 
3. EPBCS Interview Questions

======= OLAP/ESSBASE/Hyperion On-Premise/ Cloud Modules=======

1. Hyperion On-Premise Modules
2. Hyperion Cloud Modules
3.  On-Premise vs Cloud Hyperion
4. Essbase Basics
5. 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

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

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.