Same cubes, but different memory usage

messiahxu

Hi all,
I have 2 cubes on two different TM1 instances on a same server.
To me they are identical cubes. The data is the same on both cubes. Same number and order of dimension.

However, one of the cubes takes much more memory when loading and much more time to update.
Logging is inactive on both instances.
The parameters on both Tm1s are the same.

Any idea on where to investigate where difference lies?

Thanks

cat-hao

Has one of the cubes been "optimized" that is has the internal dimension order been changed?

jsyyrs

jaudouig wrote:I have 2 cubes on two different TM1 instances on a same server.
To me they are identical cubes. The data is the same on both cubes. Same number and order of dimension.

You know (as opposed to assume) that they are identical because....? What I'm getting at is, did you copy exactly the same .cub file from one data directory to another? Come to that, are the two .cub files EXACTLY the same size?

(I was also going to ask whether one of the cubes had had its dimensions re-ordered but Lotsaram beat me to that one. That's a highly relevant question as well.)

jaudouig wrote:However, one of the cubes takes much more memory when loading

OK, but you are getting the memory usage for the cube (as opposed to the server session within Windows, which is a completely different matter) from where? Also, is Performance Monitor turned on in both sessions? If so, what does the breakdown of memory usage for each cube show in the }StatsByCube cube after startup?

jaudouig wrote:and much more time to update.
Logging is inactive on both instances.

Logging shouldn't have anything to do with load time unless a server goes down without a data save and has to reload a cube's data from the log file. Persistent feeders might though. Which means that:

jaudouig wrote:The parameters on both Tm1s are the same.

Have you confirmed this using a tool like , or just eyeballed it? Used to be in the olden days when .cfg files had but a few lines it would be safe to do the latter. These days with the files tending toward obesity it's really easy to miss a T in one place that is an F in the other so it's best to do an automated check.

str8899

The answer, my dear Watson, is that the two cubes cannot be identical. You are just currently unable to see in which ways they differ.

酥糖公子

I shouldn't have to ask this but does the cube have a rule, and if so does it make reference to other cubes? This is relevant whether the references are in the calcs section or in the feeders section.

Are the dimensions identical in the two servers, and are the attributes of the dimensions identical?

If there is a rule with external references then is the cube load order, and the feeder processing order the same?