============
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.
