Statsby Rule Cube

Post Reply
Chuks
Posts: 25
Joined: Wed Dec 05, 2012 2:18 pm
OLAP Product: IBM Cognos Planning Analytics
Version: 2.0
Excel Version: 2010

Statsby Rule Cube

Post by Chuks » Tue Jan 08, 2019 7:12 am

Hi All,
To understand StatsbyRule cube, i created a simple cube with 2 dimensions as shown below
Cube name sample:
sample.PNG
sample.PNG (23.14 KiB) Viewed 814 times
The cube has a simple rule,
sample2.PNG
sample2.PNG (7.7 KiB) Viewed 814 times
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.
sample3.PNG
sample3.PNG (34.75 KiB) Viewed 814 times
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!

captnknz
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

Post by captnknz » Tue Jul 23, 2019 12:40 am

The rule is calculating for each cell, not just when there is a value in the dependent cell
Kirk Bensemann

User avatar
Steve Rowe
Site Admin
Posts: 1956
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Statsby Rule Cube

Post by Steve Rowe » Tue Jul 23, 2019 8:44 am

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.

Post Reply