}TimeInterval Question

Darkhorse · Post by **Darkhorse** » Sun Jul 28, 2013 2:42 pm

Hi all

Im trying to see if anyone used a cube in the last hour but i cant decipher the time interval dimension i understand latest is the latest Minute but does this mean the stats are gathered every minute?

using this premise could i build a subset to collect the total of the values inside 00m01-00m59? Using the Rollup function inside a TI?

is it possible to get a total from the subset without there being a consolidation in there? I know its possible in excel can i ask what the TI would be?

thanks

Darkhorse · Post by **Darkhorse** » Sun Jul 28, 2013 4:01 pm

Answered this myself,

I created the Subset called "Hour" and in the cellgetn used "Hour" and this made the total from the subset appear.

thanks anyway guys

Wim Gielis · Post by **Wim Gielis** » Sun Jul 28, 2013 11:02 pm

Darkhorse wrote:Answered this myself,

I created the Subset called "Hour" and in the cellgetn used "Hour" and this made the total from the subset appear.

thanks anyway guys

Hello

That's undocumented (AFAIK) behaviour in TM1. You'd better create your own dimension, including consolidations.

ioscat · Post by **ioscat** » Mon Jul 29, 2013 9:21 am

such an interesting feature... does it lags in some situations or work fine?

Darkhorse · Post by **Darkhorse** » Mon Jul 29, 2013 9:39 am

Works fine and been running it for a chore and every hour.

TM1 Forum

}TimeInterval Question

}TimeInterval Question

Re: }TimeInterval Question

Re: }TimeInterval Question

Re: }TimeInterval Question

Re: }TimeInterval Question