Stargate Views for complex TM1 Cube

[saptrishi]

Hi All,

I have a complex TM1 model which has more than 100 cubes fueled from approx 10 assumption cubes. We are facing some performance issues on some of the complex cubes and on investigation It looks like those cubes are not cached in the the memory.

I tried updating the VMT and VMM property of that view but it still does not shows any stats for Stored Calculation, Views etc. In order to make sure the TM1 engine is caching, I tried it on a dummy cube and found to working.

Cube Details
-Highly Complex
-Sources data from other 3-4 complex cubes
-Having 9 dimensions
-Takes roughly 30-35 seconds to populate a test view (has few consolidated members selected)

I am bit confused, Could you please advise on this behavior?

Thanks in advance.

Regards,
Saptrishi

[ioscat]

have you tried adjust CalculationThresholdForStorage parameter?
http://pic.dhe.ibm.com/infocenter/ctm1/ ... orage.html

[saptrishi]

Thanks ioscat,

I got it working for a with a simple dummy cube having 3 calculations on the same server, it just not works for the bigger and complex cubes.

[Duncan P]

Are you seeing this behaviour when you are opening the views interactively, or are you using a TI to run ViewConstruct? If you are using a TI then what is done in the TI before the ViewConstruct calls?

[saptrishi]

I have tried opening the views interactively and even by using viewconstruct in a TI, but nothing works

[Duncan P]

You mention that you have set the VMM and VMT properties on the cubes but you have not said to what values. Also you have not said whether you have set CalculationThresholdForStorage as advised, and if so to what value.

For completeness it would also help if you turned on performance monitoring, waited a couple of minutes, and then included a picture of a portion of your }StatsByCube cube - like the one below.

stats_by_cube.png (24.45 KiB) Viewed 12805 times

[saptrishi]

Please find the snapshot of statsbycube

I am having two test cubes Reserve and Reserve Margin, both are working fine with simple rules, but as soon as I link a rule to read a data from a complex cube it stops caching.

I have set the following properties
VTM = 1; VMM = 4GB; CalculationThresholdForStorage = 5

[tomok]

VTM = 1; VMM = 4GB; CalculationThresholdForStorage = 5

You literally put "4GB" in the cube or the numerical equivalent? I'm pretty sure it has to be a number. Also, are any of your assumptions string values and are any of those strings determined themselves by rules? If so, then your cube(s) cannot be cached as string values cannot be cached. All strings used in rules must be literal values or no caching of the cube can take place.

[saptrishi]

No - I have used numeric equivalent of 4GB, I don't have any string values in my source or calculation cube

[Duncan P]

So what happened between 0M00 and 0M01? At 0M00 the Reserves cube had saved calculations and at 0M01 it didn't.
What happened between those times to invalidate the cube? Did someone write a cell, or change one of the dimensions? It might be worth checking in the transaction log.

[saptrishi]

I added a rule in the Reserve cube to read some values from one of a complex cube in my model and refreshed the view.

It was working fine with simple rules but as soon as I added the DB() to a complex cube, it stopped cachhing.

[Duncan P]

So after adding the rule did you open the view twice and compare the load time for both runs? And then did you wait for over a minute before checking the stats cube?

[saptrishi]

Yes and Yes

[saptrishi]

Hi Guys,

any thoughts on this issue?

[whitej_d]

Are you using TM1 10.1? If so there was a bug with the calculation cache if you had ParallelInteraction turned on (on by default in 10.1). It is fixed in the latest fix pack of 10.1.1.

You can easily see if this is the case by disabling parallelInteraction in the tm1s.cfg file and testing the behaviour of the calculation cache. You should find it works fine with ParallelInteraction disabled and very slow with it enabled.

We found this was a problem with almost any model pre 10.1.1 Hot Fix 4 with complex rule/feeder relationships between cubes.

If this doesn't fix the problem I would strongly suggest referring the issue to IBM support.

[saptrishi]

Thanks whitej_d,

It worked, I am on 10.1 and after setting this property it started caching.

[macsir]

I roughly go through your posts. Could you make your issues more specific? Slow on opening the views or what?
Have you tried to turn on the performance monitor to gather your stats numbers?