Search found 16 matches

by wuruimao
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...
by wuruimao
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...
by wuruimao
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...
by wuruimao
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?
by wuruimao
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.
by wuruimao
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...
by wuruimao
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.
by wuruimao
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 ...
by wuruimao
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...
by wuruimao
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...
by wuruimao
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 ...
by wuruimao
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..
by wuruimao
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 ...
by wuruimao
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...
by wuruimao
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

:mrgreen: any suggestion? I just typed in the version carelessly...Sorry about that..
by wuruimao
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...