BLOCK SIZE
Block Size: It is
the multiplication of the store Dense
Dimension Member (DDM) from each Dimension *8 bytes.
A- Dense
A1- Store
A2- Store
Total Dense Members: 2
B- Dense
B1- Store
B2- Store
B3- Store
B4- Store
Total Dense Members- 4
Block Size:
2*4*8 Byte=64 Bytes
Types of Dimensions
Note:
Attributed Dimensions are below the Standard Dimension.
Types of Dimensions: Standard Dimensions, Attributed Dimensions.
I. Standard Dimensions (SD)
Types
of Standard Dimensions
1. Sparse (Default) - Low Probability Ex: Root bear
2. Dense-
High Probability, Ex: Pepsi
* Not
Associated with Attribute Dimension.
|
Consolidation
Operation. |
No- Two pass |
|
Sparse, Dense
|
Required Storage Space |
|
Standard Dimension above Attributed Dimension. |
Storage Property- all |
|
Formula |
UDA allowed |
|
Shared Members |
|
II. Attribute Dimensions
|
Should be associate to Standard Dimension with Sparse. Not
Associated with Dense. |
Two pass |
|
Should be associate to Standard Dimension with Sparse. Not
Associated with Dense. |
No formula |
|
If assign AD, automatically recovered Consolidation
operators: +-,*... |
No Shared Members |
|
No Consolidation Property. |
Required Storage Space |
|
Associated with Sparse |
Storage Property- Dynamic Calc |
|
Attributed Dimensions are below Standard Dimension. |
UDA allowed |
What are the two storage options available in Essbase, and what are the differences?
Or what is the 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 |
a 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. Convert 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 |
F or more details, Please Contact
---------------------------------------------
Job Market- Oracle EPM Cloud Modules
=================================
70%- EPBCS, PBCS Jobs
25% - FCCS, ARCS, EPCMCS
5% - EPRCS-NR, EPM Integration Agent, EDMCS
ON- PREMISE | CLOUD |
1. Location: On-site (Your Premises) | 1. Off-Site (Host Infra.) |
2. Cost: High Cost | 2. Lower Costs |
3. Control: High control by management. | 3. Less control by host. |
4. Customization: High customization | 4. Less Customization |
5. Security: full control by management. | 5. Depend on Host. |
6. Scalability: Limited , manual | 6. High scalability |
| |
| |
| |
