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 |
No comments:
Post a Comment