OLAP Basics

 

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

                                                                OLAP/BI/BPM/EPM 

                    OLAP- Cube (Multidimensional Database): Dimensions/Members/Parents/Children

                                                     RDBMS- Table (2-Dimensional Database- Row, Colum)

                                Environment: Development/Testing (QA)/Production

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

                                             OLAP/ Essbase Concepts

1. What is difference between Multidimensional (OLAP), Two Dimensional (RDBMS)?

• Multidimensional database where the data will be stored into cells & Blocks.
• Two Dimensional databases where the data will be stored into Rows & columns.

2. What is OLAP server?

     OLAP is called Online Analytical Process. Ex: Essbase

• Multi-Dimensional Database, Analytical Server
• OLAP Database called “Cube”
• 
  
  
                                               ====================

3. Difference between RDBMS, OLAP?

                          RDBMS                                                                      OLAP

• Stores and Manage the Database.                     * Analysis and Reporting
• RDBMS database called “Table”       * OLAP Database called “Cube.”
• It stores in Rows and Columns                           * Stores in “Cells and Blocks”.  
• 2 Dimensional, Pepsi, $10                                       * Multi dimensional
• 
  

=============== Hyperion=======

1. What is Hyperion Software?

       Hyperion Software is OLAP/Multi-Dimensional/BI/BPM/EPM Tool.

2. What is Hyperion Essbase?

   Essbase is a multidimensional database where the data will be stored into cells & Blocks.