Hi All,
To understand StatsbyRule cube, i created a simple cube with 2 dimensions as shown below
Cube name sample:
The cube has a simple rule,
For the first time, when I turn on the Performance monitor and recalculate the view from Screen shot1, to capture the results in StatsbyRule cube. I see the below screenshot.
The total run time is 23, and all other factors are 0( which is understood that it has been executed within 1 millisecond)
But what I don't understand is,
1) how the total run time is calculated as 23, whereas the rule is applied only to 12 cells? or does the total run time indicate something else?
2) why there is no run time for Feeder statement?
Thanks in advance!
Statsby Rule Cube
-
- Posts: 12
- Joined: Wed Jan 05, 2011 10:14 pm
- OLAP Product: Tm1
- Version: 13.0
- Excel Version: 2016
- Location: Sydney
Re: Statsby Rule Cube
The rule is calculating for each cell, not just when there is a value in the dependent cell
Kirk Bensemann
- Steve Rowe
- Site Admin
- Posts: 2417
- 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: Statsby Rule Cube
IMO Total Run Count should be 6 as these are the only cells that are fed. But this would be if
A. This is the first time the rule has been calculated
B. None of the cells that are currently zero had previously had a number in it prior to the rule being calculated, this would mean that some of the zeros were being calculated since they have already been fed, and fed cells don't become unfed.
But according to the documentation this measure is cumulative, if we trust this then 23 is a valid number.
Note to OP you have Total Run Time in your post, assume this is a typo.
A. This is the first time the rule has been calculated
B. None of the cells that are currently zero had previously had a number in it prior to the rule being calculated, this would mean that some of the zeros were being calculated since they have already been fed, and fed cells don't become unfed.
But according to the documentation this measure is cumulative, if we trust this then 23 is a valid number.
Note to OP you have Total Run Time in your post, assume this is a typo.
Technical Director
www.infocat.co.uk
www.infocat.co.uk