Total Pageviews

Tuesday, July 29, 2025

Oracle Hyperion Planning

 

1. Planning, Budgeting, and Forecasting
2. Planning Dimensions
3. Creating an Oracle Hyperion Planning Application- the classic way
4.  Creating an Oracle Hyperion Planning(EPMA)
5.  Settings
6.  Loading Metadata
7. Data forms
8. Data Entry
9. Data validation Rules
10. Security
11. Budget Process Management
12. Tasks List
13. Business Rules

Monday, July 28, 2025

Essbase Backup


                                                              Essbase Backup 

Backup

To prevent data loss we use backup and recovery. You take of backup of data base so that when any miss happening accord. You can get back your data. There are many type of database backup.

Types of backups

1. Hot Backup:  Perform backup while server is up and running mode.

2. Cold Backup:  Perform backup while server is not in running mode.

Calc Scripts

                                     What is a calculation script?

                Series of commands, equations, and formulas that control calculation of the database

                Text files with a .csc extension.

                     /* Creates Initial Budget */

                    SET UPDATECALC OFF;

                     CLEARDATA Budget;

                     Budget = Actual * 1.1;

                     CALC ALL;

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

1. What is the difference between Calc Dim and Calc All?

                  Calculating Dimensions 

       *Aggregate one dimension and calculate its formulas:

                  CALC DIM (dimension);                     

       *Aggregate all dimensions and calculate all formulas:

                    CALC ALL

2. What is the difference between Calc All and AGG?

              Calculating Dimensions

     *Aggregate all dimensions and calculate all formulas:

               CALC ALL;

    *Aggregate a sparse dimension:

              AGG (dimension);

   3.   Clear Data

 *Clear dynamic calc and store members:

       CLEARBLOCK Dynamic;

Upgradation, Migration- Oracle EPM, Oracle EPBCS, Hyperion

                                                            

                 Difference Upgradation- Migration

                ====Oracle EPM, Oracle EPBCS, Hyperion=====

                  Upgradation- Oracle EPM

               Migration

1. Upgradation: moving to a newer version of the same software.

Migration: Process of copying all Application instance form Operating environment to another.

 2. Example: Upgradation from Hyperion 9.x to 11.x

Planning 11.2.x to Oracle EPBCS (On premise to Cloud)

3.System: same System, newer version.

Different system

4. Data: Preserved.

Requires careful Migration.

5. Complexity: Less complex than Migration.

More Complex.

6. Focus: new features.

Moving to Environment.