Page 1 of 1

}StatsByRule

Posted: Fri Feb 09, 2018 5:24 pm
by ravi
Hi All,

I am looking to generate stats by rule to monitor rules statistics - Old vs new rule.

I am currently do not see the }StatsByRule cube in the model-so I enabled }CubeProperties control cube selected the Cube and enter YES for RULE_STATE (ELEMENT)
After that I enabled the start (server) performance monitor and then ran/refresh few cubes.

I am still not able to see the cube }StatsByRule created in under control cube.

I did not restart the server per IBM note below:

Note
RULE_STATS is a dynamic parameter. It does not require a server restart to take effect, but there may be a delay of up to 60 seconds before the property is applied.

Any advise appreciate your help!
Thanks
RB

Re: }StatsByRule

Posted: Mon Feb 12, 2018 4:22 am
by sachin
What version of TM1 are you on? My understanding is that, this feature is available from the initial release of PA (see below link)
http://public.dhe.ibm.com/software/data ... m1_nfg.pdf

Re: }StatsByRule

Posted: Wed Jul 08, 2020 12:39 pm
by MarenC
Hi,

I have been looking into the StatsbyRule facility and have a couple of questions:

Does Total Run Count effectively mean the number of cells that the rule applies to?

There are a number of guidelines in the following guide:

https://code.cubewise.com/blog/7-tips-t ... tics-rules

Does anyone know if further analysis has been done or how reliable these are?

I will do some testing myself but it seems like a lot of effort so any insights would be appreciated.

Maren

Re: }StatsByRule

Posted: Wed Jul 08, 2020 3:57 pm
by Steve Rowe
I recently tried to use this to test out some logic that I was trying.

I found that the cell count is accurate though note it is cells the rule applies to that have been requested from the engine, not all possible cells the rule applies to.

I was trying to use it to test the calculation cache and the relative performance of different methods. My conclusion was that the counts do not include the impact of the calculation cache. The counts are the number of time a cell is requested, not the number of times a rule is calculated.

To clear the stats for a cube, save the rule. This will clear the calculation cache too.

I can't vouch for the results you linked to but most of them look broadly in line with accepted practice.

Re: }StatsByRule

Posted: Thu Jul 09, 2020 9:49 am
by MarenC
thanks.

I have tested this a little and Total Count doesn't make much sense because I created a rule on a cube and then created a view.
And Total Count kept changing, so it would be 41, then 42 and then 78 and I didn't, as far as I know, fundamentally change the number of cells the rule would apply to.

So I am a little confused!

Maren