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)
Cube size - is this a record?
- garry cook
- Community Contributor
- Posts: 209
- Joined: Thu May 22, 2008 7:45 am
- OLAP Product: TM1
- Version: Various
- Excel Version: Various
-
- 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?
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
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
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
- 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?
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
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!
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!
- 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?
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.
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
-
- 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?
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).
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).
- 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?
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 offThe 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)
- 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?
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
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- 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?
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.
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
-
- 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?
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.
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.