}StatsByRule

Post Reply
ravi
Posts: 138
Joined: Mon Apr 26, 2010 12:39 pm
OLAP Product: cognos
Version: tm1 9.5
Excel Version: 2007

}StatsByRule

Post 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
User avatar
sachin
Posts: 92
Joined: Fri Jan 15, 2010 9:54 pm
OLAP Product: Transformer,SSAS, EP, TM1
Version: 7.3 2005 10.1 10.1.1
Excel Version: 2013
Contact:

Re: }StatsByRule

Post 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
Check out my blog for some good information on TM1, SPSS
MarenC
Regular Participant
Posts: 346
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: }StatsByRule

Post 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
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: }StatsByRule

Post 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.
Technical Director
www.infocat.co.uk
MarenC
Regular Participant
Posts: 346
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: }StatsByRule

Post 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
Post Reply