Confirm Essbase 21c is using ASO Aggregation
Hello, we have a 21c on prem hybrid cube where we have marked all upper level sparse members as Dynamic Calc. Data gets aggregated upon retrieval however we want to confirm it is using the ASO aggregation and not creating Dynamic Calculated Blocks like BSO applications would do. In the WebUI/Jet log I see lines likes these (not necessarily in this order)
- Ignoring span Hybrid Analysis option. Spanning into Hybrid Analysis Relational Source has been disabled. See the essbase.cfg file
- Hybrid Aggregation Mode enabled.
- Spreadsheet Extractor Big Block Allocs -- Dyn.Calc.Cache : [0] non-Dyn.Calc.Cache : [0]
- Spreadsheet Extractor Big Block Allocs -- Dyn.Calc.Cache : [1] non-Dyn.Calc.Cache : [0]