Statsby Rule Cube

Post Reply
Chuks
Posts: 30
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 »

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 2535 times
The cube has a simple rule,
sample2.PNG
sample2.PNG (7.7 KiB) Viewed 2535 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 2535 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 »

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: 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: Statsby Rule Cube

Post by Steve Rowe »

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.
Technical Director
www.infocat.co.uk
Post Reply