Total Pageviews

Tuesday, March 19, 2024

Essbase Basics

                              

1. What is Hyperion Software?

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

2. What is Hyperion Essbase?

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

3. What are the two storage options available in Essbase and what are the differences?

                                                          Difference between  BSO- ASO

   BSO(Block Storage Option)

       ASO(Aggregate Storage Option)

1. Write back in BSO. 

   No write-back in ASO

2. most of the Dimensions are dense in BSO

Most of the dimensions are sparse in ASO

3. can create more than 1 database per Application in BSO

cannot create more than 1 database per Application in ASO

3. Less no. of Dimensions(between 4 and 8) in BSO

large number of dimensions (more than 10) in ASO

4. Much suited for planning applications.

Not much suited for planning applications.

5. Calc Script/Two-Pass/Attribute   Dimension

no Calc Script/Two-Pass/Attribute Dimension

6. Supports LRO                                                 

Doesn’t Support LRO

7. Convent BSO to  ASO        

can’t convert ASO to BSO                                  

8. Currency Conversion                                      

No Currency Conversion

9. Supports- Partitions-   Linked, Transparent, Replicated                                          

support - Linked& Transparent 

10. Copy Database                                              

no- Copy Database

11. Sparse,  Dense                                               

no- Dense, sparse

12. parent level- loading data                              

no - parent level- loading data

13. Attribute Dimension                                      

attribute dimensions- Sum only

14. Dynamic time series                                      

no- Dynamic time series

15. at any level, we can load                               

can load Data only to” Level 0” in ASO

16. Not Available DTS                                      

available    DTS


































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

bbbbbbbbbbb

No comments:

Post a Comment