企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 1650|回复: 5

Ordering Dimensio in a Cube

[复制链接]

93

主题

423

帖子

630

积分

高级会员

Rank: 4

积分
630
QQ
发表于 2014-6-28 21:43:37 | 显示全部楼层 |阅读模式
Hi Team,

I have one question in ordering a dimension when creating a cube ?

Dimensions are : Subsidiries , Versions, and ,Year ,and Measure dimensions.

I am ordering it in : 1) Subsidiries 2) Year 3) Versions 4) Measures

it it OK if i order it in this way, if not can you give me the correct order and explination why we need to give in that order.

Regards
Ashok
回复

使用道具 举报

77

主题

412

帖子

594

积分

高级会员

Rank: 4

积分
594
QQ
发表于 2014-6-28 22:52:18 | 显示全部楼层
There is no "correct" order for how dimensions should be listed in a cube. There used to be before TM1 added the dimension re-ordering function but now that is moot. Put them in the order you want and then let TM1 decide the best order for performance after the fact.
回复 支持 反对

使用道具 举报

85

主题

414

帖子

607

积分

高级会员

Rank: 4

积分
607
QQ
发表于 2014-6-28 23:03:46 | 显示全部楼层
Hi

There is a correct/mandatory order if you are using String elements in one of the dimensions - said dimension needs to be the last in the cube.
Also, and I haven't tested this in 9.5 and think the last time I have seen it happen was in a 9.4(.3?) version, you should not have more than one dimension with string elements in the same cube. Whenever I tried to browse one of those 'double string dim' cubes the server spit the dummy. Please check the documentation on this and it is really beside the question of correct order.

As for 'let TM1 decide the best order'... I personally don't trust the suggested order and have found many examples where I was able to still gain more than 30% improvement by manually setting the order after TM1 'said' this is the best order.

Cheers
回复 支持 反对

使用道具 举报

78

主题

397

帖子

582

积分

高级会员

Rank: 4

积分
582
QQ
发表于 2014-6-29 00:12:10 | 显示全部楼层
tomok wrote:There is no "correct" order for how dimensions should be listed in a cube. There used to be before TM1 added the dimension re-ordering function but now that is moot. Put them in the order you want and then let TM1 decide the best order for performance after the fact.
Over time, there has been a combination of vendor advice and user/ developer experience (anecdotal or otherwise) to show that there are various different optimisation strategies that can be employed - predominantly, staging the dimensions from sparse to dense can realise a saving in memory footprint and you may experience a performance improvement. I'm not saying don't try it, but TM1's internal re-ordering function is not always consistent with this, and other strategies, and it is certainly not the end of the matter.
回复 支持 反对

使用道具 举报

83

主题

388

帖子

565

积分

高级会员

Rank: 4

积分
565
QQ
发表于 2014-6-29 00:42:29 | 显示全部楼层
The internal re-ordering routine only works if your cube is populated to the same extent it would be in production. Just building it, and running the re-ordering process in an empty cube will not produce consistent results. The routine has never really produced significant savings for me because I always build my cubes going small-sparse to large-dense out of habit. However, there have been instances where it does produce savings. I always put my dimensions in the same order over all the cubes in my models, for user consistency sake, even when that violates the small-sparse to large-dense mantra. The re-ordering helps in those instances. Of course, YMMV.
回复 支持 反对

使用道具 举报

96

主题

400

帖子

617

积分

高级会员

Rank: 4

积分
617
QQ
发表于 2014-6-29 00:53:28 | 显示全部楼层
tomok wrote:The internal re-ordering routine only works if your cube is populated to the same extent it would be in production. Just building it, and running the re-ordering process in an empty cube will not produce consistent results. The routine has never really produced significant savings for me because I always build my cubes going small-sparse to large-dense out of habit. However, there have been instances where it does produce savings. I always put my dimensions in the same order over all the cubes in my models, for user consistency sake, even when that violates the small-sparse to large-dense mantra. The re-ordering helps in those instances. Of course, YMMV.
I think the point that Gregor and Robin were making is that the dimension order suggested by TM1 is in fact only very rarely the real bona fide optimal order and it is possible to gain much better memory footprint saving and performance gain by setting the order manually or using other tools which actually do always arrive at the optimal order.
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2022-12-1 11:43 , Processed in 0.067146 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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