Total Pageviews

Thursday, June 26, 2025

Oracle Hyperion EPM Competitors

                                                        


-----------  Oracle EPM Cloud- Competitors ---
  1. OneStream 
  2. Anaplan 
  3.  CCH Tagetik Intelligent Platform   
  4.  SAP Analytics Cloud
  5. IBM Planning Analytics 
  6. Workday Adaptive Planning
  7. Prophix One
  8. Planful
  9. Board
  10. edox EPM Software.

Oracle EPM Hyperion Job Market

            

                     Oracle EPM Hyperion Job Market


                Job Support/Job Assistance 

       1. EPBCS Job Support
       2. EPBCS Job Assistance 





Tuesday, June 3, 2025

Loading Data using Rules file, Free form method, Excel lock& send methods.

                   

                                        LOADING DATA INTO ESSBASE DATABASE

To load data into the database, we must build all dimensions first. The data will be loaded into a 

page file and indexes also will get created. When page file reaches 2 GB, it creates another file 

and so on. Same with index file. The files are created in the following path.


ARBORPATH/APP/app-name/db-name/ESS00001.PAG

ARBORPATH/APP/app-name/db-name/ESS00001.IND


Loading data can be done using any of the following methods.


1. Loading data using rules file

2. Free form data loading

3. Through excel lock and send (or through analyzer





Build the Dimensions using the Rule File

 


                                                  Build the Dimensions using the Rule File.


RULES FILES: Rules files are used to build the dimensions and to load data into Essbase database.


 * Rules files are stored with.RUL extension on the server.

 * To create the rules file, right-click on the rules file and click create Rules file.


Building Dimensions using Rules files: We can create the hierarchies in the outline manually or 

using rules files. There are 3 ways to build the rules files.


1. Generation reference method

2. Level reference method

3. Parent-child reference method

Consolidation properties

                                                 ESSBASE

+ Addition

- Subtraction

* Multiplication

÷ Division 

Ignore

^ Never