Cube size - is this a record?

Post Reply
User avatar
garry cook
Community Contributor
Posts: 209
Joined: Thu May 22, 2008 7:45 am
OLAP Product: TM1
Version: Various
Excel Version: Various

Cube size - is this a record?

Post by garry cook »

I've just come across a service with a 7 dim cube running at 78.6Gb direct from startup. There's another cube operating at 22Gb but that looks a tiddler in comparison.

Pretty sure this is the biggest one I've seen in a production environment and before I start looking at re-engineering, I'm wondering - is this a record?

God bless 64 bit and its ability to make crazy design run (even if "run" is a relative term) ;)
Wim Gielis
MVP
Posts: 3113
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Cube size - is this a record?

Post by Wim Gielis »

For me personally, this is a record by far.
For the models that I've been working on until now: I've never come across a model (entire TM1 model running as a service or application) that would not fit in a 8GB RAM server.

In this particular case, you cannot coin the term "design".
Any chance to have a look at it and see what disaster decisions have been made when setting up this cube?

Wim
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
garry cook
Community Contributor
Posts: 209
Joined: Thu May 22, 2008 7:45 am
OLAP Product: TM1
Version: Various
Excel Version: Various

Re: Cube size - is this a record?

Post by garry cook »

In terms of investigating, I'm trying quite hard to back away as fast as I can with my fingers stuck in my ears shouting "Can't hear you!" to be honest :roll:

Sadly though, this tactic has rarely worked in the past so guess it's dissection and re-engineering ahoy. Main problem is that I'm actually scared to open it for fear of blowing the server!
User avatar
qml
MVP
Posts: 1094
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Cube size - is this a record?

Post by qml »

The biggest models I have heard of and will soon have a chance to look at more closely run at hundreds of gibibytes (200-400 GiB methinks) and the box required to accommodate them has 1TiB of RAM.

The biggest models I have actually worked with are in the low tens of GiB per model which equates to about 10 GiB per cube.
Last edited by qml on Thu Sep 27, 2012 7:40 pm, edited 1 time in total.
Kamil Arendt
JDLove
Posts: 49
Joined: Thu May 21, 2009 1:16 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Re: Cube size - is this a record?

Post by JDLove »

I think my business partner has a rather chunky model thats maybe a similar size but its dam rare and in his case its a very complex set of calculations and pretty big data sets as well.
I also know he would have designed it very well as much time and thought went into it.

Personally most models I work with are Budgeting and Planning and they never get beyond 10 to 20 GB maybe for the whole model (thats a pretty big model as well).
User avatar
garry cook
Community Contributor
Posts: 209
Joined: Thu May 22, 2008 7:45 am
OLAP Product: TM1
Version: Various
Excel Version: Various

Re: Cube size - is this a record?

Post by garry cook »

The biggest models I have heard of and will soon have a chance to look at more closely run at hundreds of gibibytes (200-400 GiB methinks)
Damn, I thought I'd got a record for finding the most ridiculous cube ever and unless there's a stupid number of cubes in those it turns out it's miles off :)
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Cube size - is this a record?

Post by jim wood »

The biggest one I've ever worked with was 29GB. This was due to a product dimension that contained a few hundred thousand members.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
Harvey
Community Contributor
Posts: 236
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: PA, TM1, CX, Palo
Version: TM1 8.3 onwards
Excel Version: 2003 onwards
Contact:

Re: Cube size - is this a record?

Post by Harvey »

Guilty as charged, I worked on a model that, at it's peak, was around 80GB.

This was an incredibly complex incentive calculation engine that needed to be dynamic and have visible working of the individual calculation steps available. The model is currently around 25GB since I worked on the feeder efficiency, though, and not quite so scary!

I don't have the stats, but I know of a particular telco implementation that got very large. Some of the developers on that project are on the forum, so perhaps they'll weigh in with a new record.
Take your TM1 experience to the next level - TM1Innovators.net
John Hammond
Community Contributor
Posts: 295
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: Cube size - is this a record?

Post by John Hammond »

Worried about getting your Model out at the TM1 conference?

Then try FEEDERMAX (R) Pills and your RAM is guaranteed to measure up!

Only $99.99 for a pack of 20. Order 200 or more and receive a 600Watt cooling fan for your tower.

Just listen to the testimonials:

Mr W - Brisbane Australia

We had the only 32 bit machine in the datacentre but 2 weeks of FEEDERMAX (R) saw me add 90Gigs to my RAM. Forget about the 3G switch, I now have a phat, 64 bit machine that is the envy of all my colleagues and my assistant tells me she can really feel that double precision default.
Post Reply