企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 454|回复: 3

Consolidation - disadvantages?

[复制链接]

96

主题

400

帖子

617

积分

高级会员

Rank: 4

积分
617
QQ
发表于 2014-3-18 06:55:16 | 显示全部楼层 |阅读模式
Hi,
I've a requirement to club a few stores in the location/geography dimension and to find the sum of the sales figure. Though we've defined an flag attribute (Y/N), i presume we can only use the attribute to create a subset of stores which have the attribute as 'Y' or 'N' - and not create a consolidation of such stores. So I'm into creating a new consolidation by altering my dimension manually. Here I would like to know the following:

Think of a location dimension, and we have the following consolidations:
C1
---S1
---S2

C2
---S2
---S3

C3
---S1
---S2
---S3
a) By adding a new consolidation, does the cube re-calculate individiual stores' data (S1,S2,S3) again and again for each of the consolidations(C1,C2,C3) ?
b) By adding a new consolidations, do I increase the volume of data that the cube is holding?

Regards,
Deepu.
回复

使用道具 举报

72

主题

369

帖子

527

积分

高级会员

Rank: 4

积分
527
QQ
发表于 2014-3-18 08:06:50 | 显示全部楼层
a) By adding a new consolidation, does the cube re-calculate individiual stores' data (S1,S2,S3) again and again for each of the consolidations(C1,C2,C3) ?
b) By adding a new consolidations, do I increase the volume of data that the cube is holding?

a) No.
b) No.

The reason both of these answers are no is the way TM1 stores and retrieves information. It only holds the values stored on N-elements and consolidated numbers are calculated on demand (as opposed to pre-calculated) when someone tries to retrieve them.
回复 支持 反对

使用道具 举报

83

主题

388

帖子

565

积分

高级会员

Rank: 4

积分
565
QQ
发表于 2014-3-18 08:25:01 | 显示全部楼层
deepu_sree wrote:a) By adding a new consolidation, does the cube re-calculate individiual stores' data (S1,S2,S3) again and again for each of the consolidations(C1,C2,C3) ?
b) By adding a new consolidations, do I increase the volume of data that the cube is holding?

The previous answers are correct - no and no - but with the proviso on (b) that when you may end up using slightly more memory if someone calculates all of the consolidations. Obviously more calculated values means more memory used, though for most consolidations the effect would be negligible. (And as was stated above, the consolidation values aren't stored as part of the cube file.)
回复 支持 反对

使用道具 举报

82

主题

429

帖子

624

积分

高级会员

Rank: 4

积分
624
QQ
发表于 2014-3-18 11:25:31 | 显示全部楼层
Thanks a lot Alan and qml for your replies...that solves my problem..!!!  

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2020-10-28 12:55 , Processed in 0.140140 second(s), 11 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表