Total Pageviews
Thursday, July 31, 2025
Tuesday, July 29, 2025
Oracle Hyperion Planning
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
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. |
|