ITPub博客

首页 > Linux操作系统 > Linux操作系统 > essbase block creation

essbase block creation

原创 Linux操作系统 作者:jerry_yin 时间:2012-02-08 02:05:42 0 删除 编辑

essbase blocks are created on: ( if there is no block, no pag and ind file)

1) data load

2) aggregation/calcuation on sparse dimension

      the block number created by agg, say agg(location) is dependent on the number of members of other sparse dimenion.

     This also include if a member with formula with "dynamic calc and store",

for example, Variance (@var(actual, budget)). everytime you view a block

which has Variance, the block will be created. for example: 100-30->california->Variance

 

 

3) datacopy

4)

a) set a sparse member to a constant:

      budget=100

this will create a lot of blocks include upper layer blocks.

use cleardata budget and clearblock empty to remove extra blocks, but pag

files are still there. the reason is clearblock just blank out pointers in ind file.

so the cleared blocked marked free. a essbase restructure will shrink the pag file

 

  if use:


FIX(FY09,"L_101601","E_A45","H_Master Distributor",NO_Department,"P_VOICE_PI", final)
budget=1000;
ENDFIX

all are sparse dimension member, will only create 1 block

b) set a sparse member to a non-constant :

    budget=actual*1.20;

no need to "set createblockoneq on"

5) submit data through smartview

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

下一篇: dynamic calculation
请登录后发表评论 登录
全部评论

注册时间:2011-07-12

  • 博文量
    22
  • 访问量
    16242