ITPub博客

首页 > Linux操作系统 > Linux操作系统 > BSO or ASO essbase

BSO or ASO essbase

原创 Linux操作系统 作者:jerry_yin 时间:2012-01-21 08:05:33 0 删除 编辑
ASO is good due to its speed, less space, etc. but it has many limitations.
for a reporting cube, the first choice should be ASO.

Now if a reporting cube has time-balance set, which require TIME dimension
to be stored, which mean no formula allowed in TIME dimension, this make
YTD, QTD almost impossible, in this scenario, BSO is better choice
 
 
a few points about ASO/BSO cube:
 
1) for ASO cube, account and attribute dimension don't have hierarchy info
   hierarchy include stored, dynamic, and multiple hierarchies
2) for ASO cube, formula only allowed on account and dynamic hierarchy
3) for BSO member, member dataStorage can have all types,including "dynamic calc" and "dynamic calc and store"
   for ASO member, only "store data" "never share" "label only" "shared member"
4) Aggregate storage outlines require non level-0 members in accounts dimension to be either non-stored members or have internal/external formula
  ( have to use LabelOnly for Subscriber_Metrics, never share not working)
Ensure that all non level-0
members in the accounts
dimension and in dynamic
hierarchies are tagged as
label only, have a child that
rolls up, or have a member
formula.
5) labelonly member can not have a formula with it 
6) level 0 member can not be defined label only

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8583032/viewspace-715158/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
下一篇: DRM for essbase
请登录后发表评论 登录
全部评论

注册时间:2011-07-12

  • 博文量
    22
  • 访问量
    16348