Pure Hybrid BSO
Hi Team
I want to understand how small a BSO cube can be considered a PURE (all sparse dimesnions have Dynamic calc for all intermediate parents) HYbRID BSO cube?
If we have 13 dimensions, with 3 dense and 10 sparse as below (the stored counts approximately as below) - will PURE HYBRID Cube work in terms of efficiency of retrievals also?
the biggest hierarchy Cost Center is having 4 levels and it is not a flat hierarchy
what are the best practices of choose which SPARSE to make DYNAMIC CALC?
or for all sparse - all level 1 should be STORE and LEVEL 2 onwards should be DYNAMIC ?
Tagged:
0