Search found 16 matches
- Wed Apr 18, 2012 2:15 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 load cube problem.
- Replies: 5
- Views: 4307
Re: TM1 load cube problem.
Dear all, I got one problem in our production. There's a cube with large amount data, when we startup the TM1 server (no demand load) (sic). And our user double click the big cube(just name it A), it will show the default View. My question is: will TM1 load all the data of the cube or just load the...
- Wed Apr 18, 2012 2:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 load cube problem.
- Replies: 5
- Views: 4307
Re: TM1 load cube problem.
"Load" is not the proper terminology I don't think as the user cannot load data by opening a view. I think you mean "retrieve" or "calculate". When a view is opened TM1 only retrieves and/or calculates what's defined in the view. If that view has a lot of high level co...
- Tue Apr 17, 2012 10:06 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 load cube problem.
- Replies: 5
- Views: 4307
TM1 load cube problem.
Dear all, I got one problem in our production. There's a cube with large amount data, when we startup the TM1 server (no demand load). And our user double click the big cube(just name it A), it will show the default View. My question is: will TM1 load all the data of the cube or just load the data w...
- Mon Apr 16, 2012 8:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: re-order dimension result
- Replies: 8
- Views: 13361
Re: re-order dimension result
Thanks for your opinion.
I am confused now,abt the data amount in the cube,does it affect the reorder result?
eg: 2 cubes with the same dims and the dims are in the same order. one has 1G data, while the other has 50G data.
does the reorder result just the same?
I am confused now,abt the data amount in the cube,does it affect the reorder result?
eg: 2 cubes with the same dims and the dims are in the same order. one has 1G data, while the other has 50G data.
does the reorder result just the same?
- Mon Apr 16, 2012 7:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: re-order dimension result
- Replies: 8
- Views: 13361
Re: re-order dimension result
One more point,
Athought the test result was terrible, the memory usage was just the same as that one before re-order.
Athought the test result was terrible, the memory usage was just the same as that one before re-order.
- Mon Apr 16, 2012 7:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: re-order dimension result
- Replies: 8
- Views: 13361
Re: re-order dimension result
I tried the re-order function in a big cube, here's the test result: Percent Change: 20228151.412903% Would anyone tell me what this result mean?? Thanks. If is was a big cube then it is now A VERY BIG CUBE. When reordering dimensions / optimizing cube structure what you want is negative percent ch...
- Mon Apr 16, 2012 3:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: re-order dimension result
- Replies: 8
- Views: 13361
re-order dimension result
I tried the re-order function in a big cube, here's the test result: Percent Change: 20228151.412903%
Would anyone tell me what this result mean?? Thanks.
Would anyone tell me what this result mean?? Thanks.
- Fri Apr 13, 2012 1:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: HELP,memory usage when load cube
- Replies: 4
- Views: 3117
Re: HELP,memory usage when load cube
That's a rule of thumb but it's right more often than it's wrong. Element density will play a part as well and obviously this one will be as dense as it's possible to be. What the effect of that fact is on your optimal dimension order is anyone's guess. I am rather confused about the re-order test ...
- Fri Apr 13, 2012 12:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: HELP,memory usage when load cube
- Replies: 4
- Views: 3117
Re: HELP,memory usage when load cube
We got 2 big cubes,just named them cubeA & cubeB cubeA's size is 23.04G, while cubeB's size is 18.41G. cubeB has 6 dimensions in order for example:a,b,c,d,e,f. cubeA has 7 dimensions a,b,c,d,e,f,g. My question,it's so strange that when we load cubeB, it will cost about 20+G memory, however, whe...
- Fri Apr 13, 2012 12:05 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: HELP,memory usage when load cube
- Replies: 4
- Views: 3117
HELP,memory usage when load cube
We got 2 big cubes,just named them cubeA & cubeB cubeA's size is 23.04G, while cubeB's size is 18.41G. cubeB has 6 dimensions in order for example:a,b,c,d,e,f. cubeA has 7 dimensions a,b,c,d,e,f,g. My question,it's so strange that when we load cubeB, it will cost about 20+G memory, however, when...
- Fri Sep 30, 2011 11:08 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI generate file slowly
- Replies: 11
- Views: 8746
Re: TI generate file slowly
in my java program, for(int i = 0;i<**;i++){ make a new view; run TI ----> generate cma file calculate with the cma file. } suppose all the files' size to generate are 70M, then,the first one(i = 0) cost less than 2mins when ' run TI ',when i=19,,'run TI' cost more than 45 min. i cannot explain why ...
- Fri Sep 30, 2011 10:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI generate file slowly
- Replies: 11
- Views: 8746
Re: TI generate file slowly
another example: to generate a 70M file, if it's the first file to generate, it will only take 2 mins. however, if it's the 20th file, it will take 30 mins..
- Fri Sep 30, 2011 9:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI generate file slowly
- Replies: 11
- Views: 8746
Re: TI generate file slowly
I used the same TI to generate several cma files,and watching the size of the cma file updating. I found that the speed of file generation more and more slowly. For example, to generate the first cma file, it's about 1M per second, very quick,however, when it was generating the 10th fie, the speed ...
- Fri Sep 30, 2011 9:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI generate file slowly
- Replies: 11
- Views: 8746
Re: TI generate file slowly
What is the disk space like on the server being written to, and what is the general health and performance if the resource being used for the file share? We have had this issue intermittently (where any TI writing out has horribly slow performance but otherwise performance is normal) and found rest...
- Fri Sep 30, 2011 9:12 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI generate file slowly
- Replies: 11
- Views: 8746
Re: TI generate file slowly

- Fri Sep 30, 2011 5:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI generate file slowly
- Replies: 11
- Views: 8746
TI generate file slowly
I used the same TI to generate several cma files,and watching the size of the cma file updating. I found that the speed of file generation more and more slowly. For example, to generate the first cma file, it's about 1M per second, very quick,however, when it was generating the 10th fie, the speed w...