企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 416|回复: 3

Very Large Dimensions - Consolidations

[复制链接]

81

主题

389

帖子

575

积分

高级会员

Rank: 4

积分
575
QQ
发表于 2014-3-16 15:10:07 | 显示全部楼层 |阅读模式
I am trying to create a total of all of the elements in a very very large dimension. It has over 1.5 Billion elements. It builds electronically but when I try and put a simple consolidation in to get a total for the dimension it won't build. Is this a know problem or can it just not be done. I have already tried building the dimension first then adding an update for the total, I have tried building the dimension with out attributes and still trying to build one consolidation but the server will crash each time.

We have a large development box on 64 Bit. Any Ideas are welcome!

thanks

Rose
回复

使用道具 举报

85

主题

414

帖子

607

积分

高级会员

Rank: 4

积分
607
QQ
发表于 2014-3-16 17:44:32 | 显示全部楼层
You probably already tried this, but couldn't you establish the consolidation when you are automatically building the dimension?

1)Create the parent
2)Create each element (1.5B)
3)Assign each element to consolidate into parent.
回复 支持 反对

使用道具 举报

84

主题

399

帖子

588

积分

高级会员

Rank: 4

积分
588
QQ
发表于 2014-3-16 18:18:16 | 显示全部楼层
rmelillo wrote:It builds electronically but when I try and put a simple consolidation in to get a total for the dimension it won't build.
Building with what. A TI process, dimension editor, or dimension worksheet?
回复 支持 反对

使用道具 举报

74

主题

428

帖子

599

积分

高级会员

Rank: 4

积分
599
QQ
发表于 2014-3-16 19:27:22 | 显示全部楼层
tomok wrote:[quote]rmelillo wrote:It builds electronically but when I try and put a simple consolidation in to get a total for the dimension it won't build.
Building with what. A TI process, dimension editor, or dimension worksheet?
[/quote]
Presumably via TI, I think that goes without saying as I can't imagine it would be possible in the dimension editor and it categorically isn't possible with XDIs.

What in the design is it that requires such a large dimension? Is it required for a cube that is transactional in nature? If so why and what other options have been considdered?  TM1 isn't really built to handle transactional data pure and simple.

The theoretical maximum dimension size is somewhere around 2 billion. I have worked with dimensions of several hundred thousand members and up to 1.5 million which TM1 has handled quite well complete with multiple hierarchies and attributes and very good query response time (just beware of the properties pane in the subset editor.)  I have heard of models with dimensions of up to 10 million members but a dimension of 1.5 billion elements is breaking new ground as far as I'm aware.  Although it may be within the theoretical boundaries it is certainly pushing the boundaries.  Are you doing a theoretical exercise or attempting to build a ganuine application? I would recommend you get yourself some expert advice in how to design your application and also to try and follow up with IBM technical support as a dimension with 1 billion elements is probably a first.
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2020-11-24 15:05 , Processed in 0.134643 second(s), 11 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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